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!
|