Linking a dinamic cell value from one sheet to another

[Guest]

Hi,

I am working on a model where I integrate Microsoft Excel and Microsoft
Project. There is a constantly changing resource data in Microsoft project. I
have written a VBA code in Project to export the required data into an Excel
sheet. The exported data does not comprise of a standard column set; in other
words, the number of columns varies according to the necessity. There is a
cell containing the total value at the bottom of the last column. This cell
value should be linked to a cell in another sheet. Since there is
inconsistency in the number of imported columns, the location of this cell
keeps shifting making it difficult to link to another sheet. Can anybody
think of any suggestions? Any help would be really appreciated.

Thanks
KT

 

[Dave O]

Does the Total cell in the imported sheet have something unique about
it- is it *always* in the bottom right cell of the spreadsheet, for
instance? If it was you could write some code for the master
spreadsheet that creates a formula based on that cell. If the cell has
a unique label that's *always* shown in the cell immediately to the
left of the Total cell, you could write code to look for that.