Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.setup
|
|||
|
|||
Print range
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 |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.setup
|
|||
|
|||
Print range
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 |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.setup
|
|||
|
|||
Print range
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 | | | | |
#4
Posted to microsoft.public.excel.misc,microsoft.public.excel.setup
|
|||
|
|||
Print range
One thing to be aware of, if you ever change the parameters of the worksheet,
such as margin, number of rows to print at top, your sheet MAY remove the offset and hardcode what was last printed. Just be aware. Also, if question was answered, be sure to check it, thank you! -- John C "Lawman" wrote: 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 | | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print range | Excel Discussion (Misc queries) | |||
Print Range | Excel Discussion (Misc queries) | |||
Print Range | Setting up and Configuration of Excel | |||
Print Blank Pgs - Preview margins outside print range | Excel Discussion (Misc queries) | |||
Print Range | Excel Worksheet Functions |