PC Review


Reply
Thread Tools Rate Thread

March 2005 Actual Info vs March 2006 Plan Info

 
 
=?Utf-8?B?QWw=?=
Guest
Posts: n/a
 
      18th Mar 2005
I have a large spreadsheet which needs to populate actual information for
March 2005 and Plan information for March 2006. (each month contains both
plan and actual information.

I'm using ADO to populate this spreadsheet, so I need range names which
properly differentiate between these two months.

My tentative solution is to use the range name 'MARCH1' {for the first
instance of March, March 2005}, and to use the range name 'MARCH2' {for the
second instance of March, March 2006}

I'll use a table to identify the range name for which I'm updating
actual information. and another table to identify the range names
for which i'm updating plan information.

I did not include the year in the range name, because next year, I'd want to
roll the year and not make any changes to the range name. {populate March
2006 Actual Information and populate March 2007 Plan Information}

I was wondering if anyone knew of a better way to do this.

Thanks in advance.
 
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
Material Requirements Plan (MRP) and Capacity Requirements Plan (C =?Utf-8?B?VHJpY2lhIFlvdW5n?= Microsoft Excel Worksheet Functions 1 1st Feb 2007 07:55 AM
Formula on Actual Vs Plan Eddy Microsoft Excel Discussion 5 11th Jun 2005 02:03 PM
Security programs 2005 - , Firewall programs 2005 -, Antivirus programs 2005 -, APPDEV DOT NET SECURITY, Linux Security and Firewall programs 2005 -, CiscoWorks ( CW ) Security programs 2005 - , futa Microsoft Access Security 3 2nd Mar 2005 05:04 AM
Security programs 2005 - , Firewall programs 2005 -, Antivirus programs 2005 -, APPDEV DOT NET SECURITY, Linux Security and Firewall programs 2005 -, CiscoWorks ( CW ) Security programs 2005 - , futa Anti-Virus 0 25th Feb 2005 02:30 PM
McAfee 2005 All In One, McAfee AntiSpyware V1.0 2005, McAfee Personal Firewall Plus V6.0 2005, McAfee QuickClean V5.0 2005, McAfee SpamKiller V6.0 2005, McAfee VirusScan V9.0 2005, new !, other code_fu Anti-Virus 0 1st Oct 2004 11:00 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:59 PM.