Column A=Part No
Column B=Days on Hand
Column C=Dollars on Hand
all for week 1
week two is Column D,E,F all with same designation
week 3 - G,H,I...
total amount of rows differ from week to week
All Part number columns are in Accending order
Is there a way to match the part numbers so that they occur in the same row though each weeks data. this would leave empty cells where the part number does not occur in a certian week.
If better explination is needed, please ask.
Adam
Bookmarks