EXCEL Help
Does anyone know how I can have a cell within a worksheet show the same info that's on the tab for that pageautomatically? SO...let's say there is a tab for each day that is labeled with the date...within the worksheet I want a cell to show the same value. I know how to have cells show the same info as another cell (ex. =B2) or whatever...but how do I do it for a tab? =TABX? or something?
Also, if I have a list of names in a column. How can I do a count of how many nanes are in that column? I know how to do it if there are numerical values in a cell [ex. =COUNT(B2::B17], but that doesn't work for Alphabetical lists. Thanks for your help! |
Quote:
If you want that value to be posted in your sheet to a cell and update when things are added subtracted: =COUNTA(A:A) * A:A would be for colum "A" .... change this to whatever you're using. |
Quote:
or infomation in other tabs? ... for this lets say you're entering names into colum "A" .... starting with A1 and you would like those names to also display on Sheet 3 starting at B5.... On sheet 3 simple, B5, simple enter "=" then go to sheet 1, click A1, and enter.... not A1 from sheet 1 will display in B5 of sheet 3. ... lets say your first sheet is named MYFIRSTSHEET , and you want that info in MYFIRSTSHEET A1 to display on MYTHIRDSHEET starting at B5..... go to B5, enter "=MYFIRSTSHEET!A1" and that will also work **** Note: you need the sheet name EXACTLY correct **** Once it is entered then just grab the little black box and you can drag this function left/right/up/down to populate other cells from that function (assuming you're going the same way as the sheet/cells you're getting your initial info from) |
Nick...Awesome...thanks! Didn't know about "=COUNTA(A1:A15)" or whatever...
FOr the other one...I'm probably just being lazy, but I want to label the tab for the worksheet 12-7-11...then have a header on the sheet that pulls exactly whats on the tab into the worksheet...like this. http://imageshack.us/photo/my-images/28/exampleg.jpg/ |
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1) )-FIND("]",CELL("filename",A1)))
Save the file then F9 to recalc. |
Quote:
|
All times are GMT -7. The time now is 8:44 PM. |