| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
create a dymamic range for printing
I would like to be able to create a dynamic range to pull the last seven days
of data from spreadsheet and place it in a different tab in the same spreadsheet. I am familiar with dynamic ranges, =OFFSET(Master!$I$1,COUNTA(Master!$I:$I)-7,0,7,1) I use them in several charts, just not sure how to transfer that same functionality to a spread sheet. Thanks Jeff -- Jeff |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create pop-up message in Excel before Printing | Excel Discussion (Misc queries) | |||
| Printing from Excel. First row of range to be repeated | Excel Discussion (Misc queries) | |||
| printing only active range (changing) | Excel Discussion (Misc queries) | |||
| how do I print a range without printing the blank pages? | Excel Discussion (Misc queries) | |||
| How do I change or create different watermark optons for printing. | Excel Discussion (Misc queries) | |||
Threaded Mode
