Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
3 step consolidation.
one workbook with one master sheet and several other sheets.
1. Need to run macro "filldownid" on each sheet in workbook except "master data". 2. Then for each worksheet.... Copy using this criteria. (must be xldown from row 10 - no headers) Range("A10:B10").Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select Selection.Copy 3. Paste this data to the next available row in "master data" sheet. I have already tried Ron's code several times, but unfortunately I've made so many ammendments to get what I want that I end up breaking the whole darn thang to where nothing works. Any help would be greatly appreciated. Thanx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Drop Down List with Step by Step Instructions for 2007 | Excel Worksheet Functions | |||
Need step by step to add invoice numbering to excel template | New Users to Excel | |||
can't install CD from Excel 2003 step by step | New Users to Excel | |||
What is the step-by-step procedure for making a data list? | Excel Discussion (Misc queries) | |||
I need step by step instructions to create a macro for 10 imbedde. | Excel Worksheet Functions |