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