Excel Forum
-
Which macro (of many) changes the data in my workbook Closed
I am working with an old macro enabled spreadsheet that has many tabs and many macros. On one tab I have a column that reports "yes" or "no" when the...
-
Formula to subtract one cell value from another. Closed
Hello, I am trying to do a formula that would subtract cell a2 from a1 if cell a3 has "Closed" in it. Is this possible?
-
Auto Transfer questioner with right answer to another sheet Closed
Hello, I have questioner list (yes or no) about 60question. I want to make it automatically transfer (all the row) to another sheet if answer is ‘N...
-
Insert Picture in Ms Excell Closed
Hello Friends, Please help me out, how I can insert the picture in front of the name automatically. Means I just select the images these pictures auto...
-
partial matches in lists of 6-digit numbers Closed
Hello! I have a list of ~500 6-digit numbers. They were all hand entered, and we want to proof the list and see if any of them were duplicated by typi...
-
Formula to create generations based on birthday Closed
I need a formula in excel that will indicate generations based off of a birthdate. Generations: Traditionalists (Prior to 1943) Baby Boomers (194...
-
Copy and paste selected cells a given number of times Closed
Hello, I had a quick course on macro and I would like to write my first one, but I would need some help with it. Id like a macro which copies t...
-
Send mail if today is the birthday. Solved/Closed
Hello, I have a Excel sheet containg profile of some employee like this: Name ID Date of Birth Rahul 335221 15...
-
Comparing Two Excel Sheets and copying like data to third sheet Solved/Closed
Hi, I'm trying to compare two sheets in excel and have matching column data copy the entire row into a new third sheet. Ex: Compare Sheet 1 column...
-
Getting multiple largest values with specified limits Closed
Hello, a1 is 110,a2 is 236,a3 is 175,a4 is 352,a5 is 257,a6 is 175.In b1 find value is greater than or equal to 400.i need all answers numbers not re...
-
Extract data from few XML file into Excel. Closed
Hello, i hope someone will be able to assist me, and i hope it is possible to do what i need. I need to extract specific data from a few XML files...
-
COMPARING 7 COLUMN Closed
HI I WOULD LIKE TO KNOW HOW TO COMPARE 7 DIFFERENT COLUMNS AND FIND COMMON VALUE IN NEW COLUMN I'M ATTACHING ONE SAMPLE HERE PLEASE CHECK AND...
-
Trying to insert multiple rows between rows in excel with copied data. Closed
Hello, I have used the two listed vba macros but i am having no luck combining the two. First one to add 13 rows between current data: data is on ...
-
Using a Named Field for Autofill Solved/Closed
I am performing an Autofill using a macro. Is there a way to enter the ranges using a "Named Field" in the macro without having to hardcode them in t...
-
Find and Replace using VB; from a txt file, find all commas "," Closed
I need to find all occurances of a comma "," in a txt file and replace it with a blank space and output a csv file. Is there an easy way to do this in...
-
Excel Macro - Set and autofill a range? Solved/Closed
Hello, I am creating an excel macro to reformat a CSV file. In doing this, I need to select a column (F) and replace the values in that column with a...
-
Excel autofilter stops filtering Solved/Closed
Hello, I am working with Excel 2003 professional and just yesterday after entering a bunch of records to my file, which has about 19,000 rows, I di...
-
Formula for conditional format to color cells Closed
hi, need a formula or conditional format: if cell a1 has text, then apply the color RED to cells underneath say a2-a15. then, once numbers are i...
-
Save excel file as specified titles in different workbook Closed
Hello Trowa and team, I just saw you solved a task for another user, who wanted to recreate a file with specified names in the list. I have a s...
-
If a cell contains any text then add a value Solved
I hope someone can help me with this...I've done this before but can't remember how. I have a list of names (for an attendees list) and I need to s...
-
How to copy a data from one sheet to another, when specific criteria is met Closed
Hello, If, for instance, the criteria changes in column "C" - it gets higher number, how to transfer the row data to other sheet2, copying the row d...
-
Need to delete rows in multiple sheets simultaneously Closed
Hi I have a worksheet that has 3 sheets. Sheet 2 and 3 have data linked from sheet 1. If I delete a row in sheet 1, I want to have the correspondi...
-
VBA Code to apply in each monthly worksheet Closed
Hi, I have a monthly creditor file (create new tab for each month when required) and want to calculate the amount outstanding each month, which is ...
-
Formula in Excel to turn numbers into text Solved/Closed
Hello, I found formula but sir I want at last as per below. As per formula =words(1234) = one thousand two hundred thirty four But sir I wan...
-
Formula/Solution Closed
Hi, Is there a way for me to link in one spread sheet the Leave Dates that will automatically apply to the specific date in a second/third/forth sp...
-
VBA Regex Closed
i need a help to create regex to use in Excel vba. Actuality 3 regex 1. Only Numerics Valid: 12,12.000, 2343342.123221321398783, 0.9874, -12, -2...
-
Compare two excel file and provide unmatched excel data in separate file Closed
Hello, I have two excel files with common identification column A in both files. I need macro which will provide unmatched data in separate file. ...
-
use RegEx in vba sub in general sheet Closed
How to use regex in general vba sheet. i am getting lot of red lines and not able to find the reason for that. I have enabled the Regularexpression...
-
Listboxes with Checkboxes to filter data Closed
Hello, Greetings! I have a query regarding making dashboard. I have a data sheet where all data is managed. I want slicer with listbox having ...
-
read special character value Closed
how to read the cell value in vba if A1 has special character like -------- I used Range("A1").Value , Its throwing an error plz help me
-
VBA code to count invalid Values Closed
Hi, I have created a vba code to circle the invalid data based on the custom data validation rule being written. I want to count the all those i...
-
Automatically update a cell with last modified date and time Solved/Closed
I am maintaining a Test Environment Catalogue, with various users editing it. It is change controlled in SharePoint, however, I'd like to insert a cel...
-
Repeated copy/paste Macro Closed
I have basic knowledge of Macros. I need to copy 1Lakh data in such a way that it takes 10k rows and paste in new sheet1 and again it takes next 1...
-
Keeping track of ages Closed
Hello, I operate a small daycare and need help figuring out a system to help keep track of my group ratios. I haven't been able to find a software...
-
Please help me connect my workbooks to a master excel worksheet. Closed
Hello, I have been through every excel video and forum trying to figure out how to connect my Excel workbooks for a tracker I have been working on. I...
-
VBA find column by name and sort Solved/Closed
Hello, I am trying to make a code that should: - Go to the first worksheet - Find the first column with header "sku" - Sort this column ascen...
-
copy x rows from a worksheet and paste x rows into another worksheet n times Solved/Closed
Hi, I am struggling to create a macro that can copy an excel range of data (A1:B50) from sheet 1 and paste into sheet 2 for 4000 times. Currently, sh...
-
Create new sheets based on Column A data. Solved/Closed
Hi, Is there a way to create a new tab based on column A? For example: I want to create a new tab for each vehicle, copy and paste all of vehicle ...
-
False error Closed
Hello, How to remove false error while using this formula *if(c2="A",sumifs(sheet2!AA:AB,sheet2!B:B,sheet1!B:B, sheet2! Sheet1! A:A))*
-
Excels with different data Closed
Hi All, sorry if this is already answered. I have two excel sheet having data of customers. the first report is 'old' one and the second is the '...
-
Finding duplicates between two columns with partial text Closed
Hello, I am trying to compare a list of names in column A to a list of names in column B. I am trying to highlight the names in column A that matc...
-
Arrow keys not working in Excel Solved/Closed
Hello, I am using Excel 2000. I am tring to move from one cell to another in Excel by using the arrow keys on my keyboard but nothing happens. I wa...
-
How to change date with the change in time Closed
How to change date with the change in time and how to use if formula for date range
-
excel on Mac Closed
Im trying to setup my friends computer to invoice I have run time 1004 error occurring. Any help please Sub NextInvoice() Range("I13").V...
-
color cell Closed
Hello, I have this formula to place a date in cell when negative number. =IF(D14
-
I want to change date format in Excel Solved/Closed
Hello, I want to change date format from SAP system i.e. 20.05.2010. When I apply thru format cell it doesn't work.
-
Need to extract specific XML data from a cell in excel Closed
Hi, I have the following data in cell A1 of an excel sheet: 39211000011200100100019 i would like to extract the value from this and print it o...
-
Automatically data to another sheet by adding new rows Solved/Closed
Hello, I have created a "request form" - the form is not designed in VBA - it is simply a spreadsheet using Column B, only, and each row has either ...
-
Creating search and update command buttons in a userform Solved/Closed
I have created a userform for inputing new records in an Excel spreadsheet. I have written the code for the Save Record and Close Form command button...
-
Update of Copied Excel sheet Closed
Hello, I want to make copies of excel sheet such that if I delete rows/columns in main sheet they should be deleted in copy too.
