N
nrobinson
I would like to create a file of data that has quanties used from one time
period. Then, periodically take another file of the same items from another
time period and bump it up against the first one. I want to match the items
and put the usage quantities side by side. Then calculate a variance of the
change in quantities and sort from hi to lo. I know how to do the basics but
how to write a macro so that I take the new file and just do the bumping up
against automatically.
period. Then, periodically take another file of the same items from another
time period and bump it up against the first one. I want to match the items
and put the usage quantities side by side. Then calculate a variance of the
change in quantities and sort from hi to lo. I know how to do the basics but
how to write a macro so that I take the new file and just do the bumping up
against automatically.