#1
|
|||
|
|||
Moving columns Automatically with Frozen Panes
name | dated columns incrementally increasing->
--------------------------------------------------------------------- name 1 | name 2 | name 3 | name 4 | the name column is a frozen pane column and the dated columns can move left or right depending on which date ( Row A ) you want to view for the information the table holds per person in column 1. when I open the spreadsheet, is there a way I can use today's date and search for today's date in Row A, then make the table automatically slide left or right to make the selected column the first column after the frozen pane? |
#2
|
||||
|
||||
See the attached file.
Open it and allow macros, then move to Sheet1 (it was saved with Sheet2 being the active sheet). It will try to scroll the current date to be at the left. This does not change the selected cell, that may be off screen; this behaviour can be changed if you want. The macro only runs on the file being opened. It could instead/as well, act every time you switch to that sheet; there is commented-out code to do that in Sheet1's code-module. You just have to enable it. |
#3
|
|||
|
|||
Works a Charm, thank you very much
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Footnote Help- Automatically moving to next page | thesisformatter | Word | 7 | 03-09-2016 09:57 PM |
Moving from Rows to Columns | jimmydd2121 | Excel | 1 | 06-02-2014 09:05 AM |
moving columns in excel 2007 | Straitsfan | Excel | 2 | 02-06-2013 04:07 PM |
Moving columns | plantzj | Word | 3 | 09-17-2011 10:30 AM |
moving data from single to multiple columns? | mzimmers | Excel | 3 | 08-23-2010 08:20 AM |