rogster001
New Member
- Joined
- Jun 17, 2010
- Messages
- 45
Hi all,
I am not quite sure of the appropriate function to use, or how to build a statement to allow the following:
Define an area of a worksheet as a data source,
fill a second worksheet with the contents of the data source area
When the area that the data source defines is expanded, it automagically populates the second worksheet with the new rows or columns that have been captured when expanding the data selection...
I have been playing around with 'defining' names and then importing it as external data, this seemed ok-ish, but the column labels are coming out as 'F1, F2, F3' etc, and non of the formatting remains either.
Essentially the problem is one worksheet which is the master covers financial year by week.
The formulas populate the cells into the future with meaningless values, which is fine and in certain cases i have hidden it with conditional formatting etc.
But for a report that is to be circulated we need to get rid of the meaningless counts, so i would like to see if a condition could be put in to say, '"Only apply the formula as far as the current defined week"
Sop if i could somehow flag to the worksheet which is the current 'maximum' row would fix it... this is easy in code, but i have no real clue interpreting this as excel.
I am not quite sure of the appropriate function to use, or how to build a statement to allow the following:
Define an area of a worksheet as a data source,
fill a second worksheet with the contents of the data source area
When the area that the data source defines is expanded, it automagically populates the second worksheet with the new rows or columns that have been captured when expanding the data selection...
I have been playing around with 'defining' names and then importing it as external data, this seemed ok-ish, but the column labels are coming out as 'F1, F2, F3' etc, and non of the formatting remains either.
Essentially the problem is one worksheet which is the master covers financial year by week.
The formulas populate the cells into the future with meaningless values, which is fine and in certain cases i have hidden it with conditional formatting etc.
But for a report that is to be circulated we need to get rid of the meaningless counts, so i would like to see if a condition could be put in to say, '"Only apply the formula as far as the current defined week"
Sop if i could somehow flag to the worksheet which is the current 'maximum' row would fix it... this is easy in code, but i have no real clue interpreting this as excel.
