Making Short term memory in Excel file cell

September 8, 2011 at 05:41:04
Specs: Windows XP, 2048
Hello everyone!


My Excel file contains production plan for particular weeks of the year and for different products.
As every week arrive new (updated) schedules from customers I have to correct the old volumes (put in the last week) to be produced in the coming two or three weeks and I simply overwrite the old values.
But diong it like that I loose the old information and I don't know if there is an increase or decrease in the volumes to be produced (this is important because it is linked with the information for the purchasing dept.)
So, the question is if I could have a kind of "short term memory" in the Excel file cells which would result in giving me additional info about "Delta Volume" every time when I overwrite the old values. This additional info might be put for example in some cells below the production program lines (for your information: I select the particular product groups from the list and make them display, so from the list of total ca.400 items I display e.g. 15-20 item of each group).

I'm not sure if it was clear for you what I've written here above - if any additional questions or doubs just ask me...
I thank you guys in advance for your support!

Zennon


See More: Making Short term memory in Excel file cell

Report •


#1
September 8, 2011 at 06:15:18
Two things have to happen in order for you to get "Delta Volume" values:

1 - The old values have to be retained and stored someplace.
2 - There has to be a formula to calculate the difference between the old values and the new. That formula could be in a cell, in a macro or in your head.

You said: "I don't know if there is an increase or decrease in the volumes to be produced (this is important because it is linked with the information for the purchasing dept.)"

How is it linked with other information? It seems to me that this relates to Item 2 mentioned above.

If you don't currently have these Delta values being calculated in the sheet, how are you passing this information along to Purchasing?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
September 9, 2011 at 04:14:40
Hi DerbyDad03,

Thanks for your suggestions.
We calculate the "Delta Vol." manually and pass them on paper to Purchasing but as we entered into cooperation with new bigger customers that use weekly schedules it has to be automatized, definitely.

Thanks!

Zennon



Report •

Related Solutions


Ask Question