Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro for copying conditional data
I need a macro that copies data only if certain text is in column A
For example if Cell "A5" is Evan Jones, then Cells B5-J5 will get copied to the sheet named "Evan Jones", and if another cell in column A also says Evan Jones then the same applies for its row except it will be put in the next row of "Evan Jones" sheet. I have several names that this will be working with in "Column A" which is titled "Customer Name", and each line will have information in columns B-J for those rows.... I hope you understand what I mean, and I hope someone can help.... Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding data series to chart via macro | Charts and Charting in Excel | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
import data using macro | Excel Discussion (Misc queries) | |||
save original data after macro is run again | New Users to Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |