[TennUser]

Hello

My task is to move some values from one spreadsheet and creating new smaller spreadsheets based upon the data in the larger spreadsheet.

I need to move around the larger spreadsheet to determine some values. Am I restricted to using the $ExcelColumn$column# or can I use other variables?

In my spreadsheet there are multiple sets of info that need to be broken out into separate files. So I look for the end of a list, then go back up and pull out info and put into the separate spreadsheet. After I have completed that table, I close the new small file and move on to the next set of information.

So I have multiple issues:
1. keeping two spreadsheets open and pointers correct in each
2. moving up and down in a spreadsheet.

I have used the product in the past to take spreadsheet data and paste it into a web doc, that was great! I am now trying to use it for spreadsheet to spreadsheet which I thought would be just as easy.

Thanks for your help.