copy columns based on value in a particular row
Hi there,
Any idea how to write a macro that will:
- copy the columns (say rows 4 to 100) from each sheet within the active
workbook where the value in row 3 = value in cell A1 (there will be only one
column per sheet satisfying this condition - it should give an error if
there are more than 1)
- paste them one under another in column B of a newly created worksheet
(call it "summary")
Thank you very much in advance for your help on this...
Mark
|