PC Review


Reply
Thread Tools Rate Thread

Auto update production sheet

 
 
OrlLBX
Guest
Posts: n/a
 
      29th Aug 2007
Helpp Please
(Using Aug as an Ex).At the End of the month, we woud like to have a formula
to replace the data of the corresponding month with updated data located on a
seperate worksheet. Information must remain constant until end of month due
to 12 month review cycle. Example: the end of this month, the information in
A8 and B8 should be updated ( Changing the month (A8) , is not as significant
as the data...but would be nice) with actual data located from a seperate
production sheet.

A B
1. Jan'07 95
2. Feb'07 94
3. Mar'07 93
4. April'07 96
5. May'07 97
6. June'07 92
7. July'07 91
8. Aug'06 92
9. Sept'06 90
10. Oct'06 99
11. Nov'06 93
12 Dec'06 90

Thanks for any assistance you can provide.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto Update a sheet through Macro Chetu Microsoft Excel Programming 4 7th Aug 2009 12:26 PM
Summary sheet auto update SUMMARY SHEET AUTO UPDATE FROM WORKBOOKS Microsoft Excel Worksheet Functions 0 28th May 2009 01:49 PM
I need a payroll sheet that can auto update figures each week =?Utf-8?B?U2hlaWxh?= Microsoft Excel Worksheet Functions 1 4th Apr 2006 07:56 PM
Auto Update Sheet Tab =?Utf-8?B?S2FyZW4=?= Microsoft Excel Worksheet Functions 3 16th May 2005 08:11 PM
Auto Update text box on data sheet form Robert Raley Microsoft Access Forms 0 4th Nov 2004 01:26 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:33 AM.