Linking a dinamic cell value from one sheet to another

Tech-Archive recommends: Fix windows errors by optimizing your registry

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
***. 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 ***. Since there is
inconsistency in the number of imported columns, the location of this cell
keeps shifting making it difficult to link to another ***. Can anybody
think of any suggestions? Any help would be really appreciated.

Thanks
KT
.

Quantcast