I have seven workbooks which contain exactly the same number of columns but a different number of rows. I am looking to copy and paste the data from each into one long workbook which contains all of the data. I can then use this to produce pivot tables.
I am using Excel 2002 and cannot see the relative reference button that normally appears. I need to use relative reference because the number of rows of data will change every week. Thus without relative references the macro will fail. Does anyone know how to activate this in excel 2002? Or can you suggest an alernative solution.
thanks,
James
I am using Excel 2002 and cannot see the relative reference button that normally appears. I need to use relative reference because the number of rows of data will change every week. Thus without relative references the macro will fail. Does anyone know how to activate this in excel 2002? Or can you suggest an alernative solution.
thanks,
James