Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a formula to capture data between "Tabs" on a spreadsheet
I have a question?
Is there a formula that I can use which references a different "tab" on my spreadsheet. For example if on sheet 1 (which of named New Rules) I have dates in which clients were admitted to our treatment program. Also on sheet one, I list their diagnoses (e.g depression, anxiety, etc). On sheet 2 (which I nammed QA Data) I want to list "stats only". For example, cell A1 on the QA Data sheet may list the total number of clients in 2007, and another cell may list a break out of diagnoses. Again, the raw data for this information (name of client, admission date, diagnosis) is on sheet 1 (New Rules), but I want to use sheet 2 (QA Data) to tally the various stats that I desire (a tab dedicated to stas). I just didn't know if you can write Excel formula on one sheet askinig to capture information from another sheet. The only thing I know how to do is to "link data" between sheets, but I don't want to do that. Thanks for any suggestions! Dan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
When I type "13" the spreadsheet shows "14." Possibilities? | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
pictures to work with "data" "sort" option | Excel Discussion (Misc queries) |