Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Parse Data Sheet (anti-consolidate)
Hi everyone. I have a data sheet that 14,000 rows long. In column A
is the customer number. Then I have a "control" sheet, where I have a list of customer numbers to pull (copy) from the data sheet (A3:A20). Can VBA scan the data sheet, create a new sheet for all entries in Control("A3:A20"), and copy in the entire row for every instance found in the data sheet for each customer identified in Control("A3:A20")? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to consolidate 580 file's data in 1 sheet without oppening all | Excel Worksheet Functions | |||
Consolidate an XLS sheet | Excel Discussion (Misc queries) | |||
trying to consolidate info into one sheet | Excel Worksheet Functions | |||
Consolidate data to summary sheet | Excel Discussion (Misc queries) | |||
How to parse the comma seperated strings into the excel sheet | Excel Programming |