Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A Formula for tracking Data on It's own tab in my spreadsheet?
I'm familliar with the following process to create links and transfer data to
other tabs in on active spreadsheet: Hit the = key in the cell (on the tab) that you want the information to appear in. Go to the tab and cell you want to transfer the relevant data from Hit the ENTER key €śLink€ť created and changes to the cell containing the original value or formula will affect the cell to which its been brought forward. However, I'm attempting to clean up my spreadsheet for better clarity and ease of reading. I would like to do the following: Continue to have the "Master Tab" contain all of the relevant client information, and flags (identifying when I have to follow certain procedures). Create a unique tab (on the same spreadhseet) for all statistical tracking (e.g. number of client's referred to treatment, number of client's seen during a specific month or year, etc). I didn't know if there was a formula I could use which would allow me to do this outside of the standard "linking" process above. I still need to pull my various formulas from the "Master Tab" (e.g. Countif, array's, etc) to create the needed "stats", but I'd like to keep this "statistical Information" off of the Master Tab itself. Thus, if the formulas developed on "Tab 2" (for example) could grab the needed information from the Master Tab (Tab 1) my desired outcome would be accomplished. Thanks for any help! Dan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sending Excel Spreadsheet with Change Tracking | Excel Discussion (Misc queries) | |||
How do I create a payment tracking spreadsheet? | Excel Discussion (Misc queries) | |||
Tracking who accesses a spreadsheet | Excel Discussion (Misc queries) | |||
how to do a recruiting and tracking spreadsheet | Setting up and Configuration of Excel |