referencing another worksheet

[Guest]

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

 

[Guest]

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- (e-mail address removed)

 

[Guest]

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.

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- (e-mail address removed)

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