LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Referencing a newly created worksheet Charyn Excel Worksheet Functions 2 May 2nd 05 04:13 AM
Search/Match between 2 x separate Worksheets and populate result in third worksheet Alan Bartley Excel Discussion (Misc queries) 1 April 11th 05 05:21 AM
Referencing a worksheet name Greg114 Excel Worksheet Functions 3 March 23rd 05 10:23 PM
Summary worksheet referencing multiple worksheets Jon Excel Worksheet Functions 1 January 27th 05 01:12 AM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM


All times are GMT +1. The time now is 05:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"