View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
J.W. Aldridge J.W. Aldridge is offline
external usenet poster
 
Posts: 425
Default 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