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 |
#3
|
|||
|
|||
unfortunately it's more complicated than that...the function has to look at
the name of the sheet and validate it against the date on that column then validate that the regions are the same before it populates that cell with the correct value. "Bryan - " wrote: It sounds like you want to reference cells on another worksheet. If that's what you're asking, that's simple. Click in the cell where you want the referenced value to be placed (sheet 1). Type an "=" (no quotes) Click sheet 2 Click the cell containing the value you want to reference. Press Enter Repeat steps for all cells you want to reference. Now when you update the values on sheet 2, sheet 1 will automatically update because it's just referencing the values on sheet 2. Hope this helps! Bryan- "chartasap" wrote: 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 |
Reply |
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 |