Reply to thread

Message: <blockquote data-quote="Heretic Apostate" data-source="post: 895792" data-attributes="member: 696">Here's an example of what I'm trying to do.The summary page (what is used by the acctg. department for the audits) starts in cell Y31.  I'd like, when the macro gets there, for cell Y31 to be the upper-left cell on the screen.  (Not moving data, but moving the view.)The trouble is, while the macro DOES go to cell Y31, the upper-left cell might be W12.  So if I were then to do the freeze pane on cell AC37, they'd only be able to view 3.5 rows at a time (and half the data would be off the screen to the right), with lots of wasted room at the top and left.I've got to do this for the Summary (breaks the data down by month, within each month by state and federal tax intercepts, and by what money went to nonwelfare, welfare, foster care, and other), the Specifics (choose what to search for, and get a non-detailed summary by month), two Detail tables (Detail Other, which gives details of the other column from the summary by month or for all of it, and Detail All, which gives a list of all relevant transactions within a month), and a manual data entry area (a 36 x 5 table that dumps into the Summary table; used for a special welfare program).The spreadsheet has to show the data entry table, the options area (set up obligations, start dates, end dates, payment exclusion ranges by dates, and standard limits to audits), the summary, specifics, and detail tables.  The rest of it, I plan on hiding until needed by the macros.I can easily move the options area to another tab without adding any formulas.  The summary tab would require 6 x 132 additional formulas.  The specifics would require 4 x 132 additional formulas.  Those wouldn't hurt too much to move (1,320 additional formulas, less than me adding one more calculation to the original data).  The TANF (36 x 5 table, with no additional calculations wherever it is placed) wouldn't hurt to be moved, either.The detail pages, however, will have 1,800 lines x 2 tables, each of which would have 8 pieces of data I'd want to transfer over.  So these definitely have to stay on the data entry tab.Do you think it'd help if I put the detail tables at the top of the tab?  Like, for instance, starting on row 1, instead of row 3620?</blockquote>

Verification