Alternative to links for updating worksheet?
 

Hi,

I am using Excel 2000. I have a workbook with about 30 worksheets. Each worksheet has an identical layout containing 14 sections every 45 rows with a number of empty rows and cells. I am using coumns A through S. The columns I want to use are in column A and B, and G through S. It is model forecasting volume, revenue, expense (months in G:S and year in S).

Right now these I have linked these 30 worksheets into a single worksheet in a separate workbook, the purpose for which is to organize my data in tabular form so that I can create a pivot table.

Updating the links in 15,000 rows and 19 columns is much too slow in Excel 2000. I am wondering if there is a macro available I could use to copy and paste value the data i need.

I could record a macro to do this, but I am wondering if there is a better way.

For example, if I recorded the macro, I would tell it to in worksheet 1, copy A6:B6 and paste value in new workbook sheet, copy and paste G6:S6A6:B6, copy paste A12:B18, copy paste E12:S18, copy paste A20:B33, copy paste G20:S33, and so on, until all my data is repasted into a tabular format in the new workbook.

Thanks very much.

I've read
http://j-walk.com/ss/excel/tips/tip82.htm

and

http://www.google.com/groups?hl=en&l...r.com&r num=6

but I am not sure how to make these work for my situation.