Hi,
I'm a newbee and trying to automate an excel spreadsheet. Here's what I have so far:
In one section of the spread sheed I have actual cell references in the cell: like a2 c2 d2 What's important is that each cell has a different letter but they all have the same number. the actual matrix is 20X60.
What I do now is I high light the reference cells and do a find replace all. Each time I do this I increment the cell reference by 1. So in the first example all data is referenceing data in row 2 I do the find and replace and now all the references are for data in row 3.
When I update this my other data is updated with the new results. I then do a copy for that matrix and do a paste special value in a new worksheet.
I repeat the procedure and each time append the data in the new spreadsheet following the last paste special.
I have to go through this procedure about 100 times. Is there anyway to automate this?
Bookmarks