Well basically.... I have quarterly statements that must be produced.
There are 4 quarters and there are 4 files for each quarter. Under the quarters are the several fund names and the director's names that have investments in each of those funds. At the end I would like to create a separate spreadsheet that consolidates all the information into on worksheet. For example: John Smith 1st qtr 2,000 2nd qtr 5,000 3rd qtr 2,000 and 4th qtr 1,000 of the ABC fund.
In the separate spreadsheet I want to be able to add up all those amounts into one cell. The cell amount should be 10,000.
I hope I explained it correctly. Do you really think that linking it would be better? What is the VBA code way?
Thanks for responding so quickly.
Uby