Home |
Search |
Today's Posts |
#1
|
|||
|
|||
referencing another worksheet
Hi,
I have two worksheets. Worksheet #1 [call tracking] and worksheet #2 [wss]. in Worksheet #1 i have listed regions in column a (ie east, central, southeast, southwest, etc) and on row 5 the labels are the days of the week. Spreadsheet #2 contains values that i need in worksheet #1. Instead of typing these numbers into worksheet #1 how can i compare these two based on the date so that if sheet #2 is for 7/11 that the cells on sheet #1 for east, central, southeast for the date 7/11 be populated. Worksheet #2 changes on a daily basis. Any ideas? Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing a newly created worksheet | Excel Worksheet Functions | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Referencing a worksheet name | Excel Worksheet Functions | |||
Summary worksheet referencing multiple worksheets | Excel Worksheet Functions | |||
Weekly Transaction Processing | Excel Worksheet Functions |