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 |
#2
|
|||
|
|||
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. |
Reply |
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 |