Helps? Ideal!

Thanks John

Lawman


"John C" <johnc@stateofdenial wrote in message
...
| Assumptions: Sheet name = Sheet1, column with date = A, cell with how many
| rows deep you want printed = cell G1, total columns worth of data is 6.
|
| First, randomly select some cells and set as print area (this is just to
| ensure print area will be defined correctly). Then go to
| Insert--Name--Define, highlight the Print_Area, and in the refer to box,
| type the following formula:
|
| =OFFSET(Sheet1!$A$1,MATCH(TODAY(),Sheet1!$A:$A,1), 0,Sheet1!$G$1,6)
|
| Hope this helps!
| --
| John C
|
|
| "Lawman" wrote:
|
| I want to create a worksheet so that when I click Print, Excel will
| automatically print the area defined a top left cell that contains a
| particular value in a specified column and the lower right cell is a
| manually defined offset from the top left.
|
| In particular, the top left value is to be =TODAY() looked up in a
column of
| sorted dates, and the offset coordinates will entered in a cell(s) on
the
| worksheet
|
| Many thanks
|
| Lawman
|
|
|
|