Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Linking a dinamic cell value from one sheet to another
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell color index comparison | New Users to Excel | |||
Using the Active cell in one sheet for another sheet | Excel Discussion (Misc queries) | |||
GETPIVOTDA - Linking Into Pivot-table Cell | Excel Discussion (Misc queries) | |||
Linking to an Entire Sheet | Links and Linking in Excel | |||
Automatic cell increment with data from sheet 1 to sheet 2 | Excel Worksheet Functions |