| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract Data from Dataset
I'm looking to extract data that meets a certain criteria but not sure how to do it via a macro. What I'm after:-
Workbook1= Dataset Workbook2 = Where it will be extracted to (copied not cut) I will copy rows 1-12 as headers first Based on a value I input in a Dialogue box, this is the data that will be extracted to new Workbook2 The value input above will reside in Column A (starting at Row 13) in Workbook1 Once matched I will copy all the Row The match/copy process will continue until it hits the first blank cell in Column A, signifying the end of the Dataset Then Copying the column widths in Workbook1 to match Workbook2 I hope above makes sense |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to extract a dataset to the active cell? | Excel Programming | |||
| Charting only partial data from a large dataset | Charts and Charting in Excel | |||
| Sorting dataset automatically after entering data in a row [or cel | Excel Discussion (Misc queries) | |||
| assign dataset to matching dataset | Excel Programming | |||
| Converting A Quarterly Dataset to Weekly Dataset | Excel Programming | |||
Threaded Mode
