re Alternative to updating 300,000 links in Excel 2000?
 

Hi,
Send a dummy workbook to me and I will evaluate the
project. It is free till I say its not. i will create
something that might fit the need.

see some of my samples at:
http://au.geocities.com/excelmarksway
http://www.geocities.com/excelmarksway

regards
Mark E. Philpot


-----Original Message-----
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&lr=&ie=UTF-
8&selm=sH1La.4495%24cJ5.436%40www.newsranger.com&r num=6

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

.