View Single Post
  #1   Report Post  
chartasap
 
Posts: n/a
Default 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