Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show Data from Various Tabs in one Tab within the same worksheet
I still am working on my Teacher test result WorkBook. The problem I
am having now is transferring data from students tab to Roster tab, I tried to explain this in my last post but I think I failed Due to No response, no luck, so I am trying it again. (Roster Tab- Sheet1) A B C D E F G H Up To BM 1 2 Name1 Data Data Data Data Data 3 Name2 4 Name3 5 Up To 42 Name (Name1 Tab - Sheet3) Sheet 2(Template) Is Hidden all Student tabs are copy of Sheet2 Student Tabs are all have the same format. The data points are all the same i.e Cell's F8, F14, G25 etc. My goal is to place a code or formula in Either Roster Tab-Sheet1 or the respected cells to show these data points for each student, sort of overall look. So the Info in Cell F8 of the student tab should be reflected in cell C2 of the roster Tab =(StudentName!F8). Any Idea of approach. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Separating data onto separate worksheet tabs | Excel Discussion (Misc queries) | |||
Naming of tabs from data in a worksheet | Excel Worksheet Functions | |||
how do i sort a worksheet data to show repetitve data and show | Excel Worksheet Functions | |||
Help with data manipulation between 2 worksheet tabs | Excel Discussion (Misc queries) | |||
How do I show two rows of worksheet tabs instead of one? | Excel Discussion (Misc queries) |