Hi Guys,
I'm battling to get a macro to perform the following:
My workbook contains 150 sheets [stock items] on each sheet variuos
information appears. I've got a summarysheet witch reflect all information
from the sheets.
It's much easier to copy the formulas from column A [which contains all 150
shhet names] on the summary sheet to column B. The sheet names remains te
same of course, but the cell adress changes. I've tried the macro recorder
without sucess.
To summirise I would like to copies the formula in column A [Sheet 1 "B2"]
to column B [Sheet 1 D2] etc.
Any help would be appreciated
Thanks
--
HJN