Right now I have a import program (Barry should know this well). That imports a spreadsheet in to a form.
My Form = jat2
First Import Jan 1
[Group] [4thManager] [Area] [Catergory]
Mono Smith Color Travel
[Jan_Plan] [Jan_OL] [Jan_Act] [JanDelta]
10 08 08
[Feb_Plan] [Feb_OL] [Feb_Act] [FebDelta]
20 18 18
[Mar_Plan] [Mar_OL] [Mar_Act] [MarDelta]
I will try to use numbers to explain my question.
The First Import places the values in *_Plan and *_OL
Then the second Import (Jan 30) leaves *_Plan as is and changes *_OL (See Above) - Great working as it should
Then the next Import (Feb 1) comes. It should Leave *_Plan alone and place the new imported value in *_OL and *_ACT. (see Above)
I would like for the program look at current date and if the month is Feb thanks the column value for Jan.Col(4) places it in Jan_OL and Jan_Act and then puts the rest in the *_OL .
If the Date is March the import value for Jan.Col(4) = Jan_Act Feb.Col(5) = Feb_Act Mar.Col(6) = Mar_Ol Apr.Col(7) = Apr_Ol.
I hope this makes sense. Get current month and place the current value in OL and all previous months get placed in Actual.
This is like for planning people.
I think in Jan I need 5 people so that is my Plan and my OL
in Feb I only needed 4. I want to keep my Plan and OL for Reference but I only needed Actually 4. So all previous months are month_acts.