C
C. Corodan
Hello,
I have a sales planning worksheet, some of the columns being:
Sales Rep Customer Ship-to Article Plant Aug 08 Sept 08 ...
There can be up to few hundreds rows. At the top of the worksheet I have a
row with validation boxes that allow me to enter new Sales
Rep/Customer/Ship-to/Article/Plant combinations and the sales forecast for
the respective combination.
1. I want to create a macro that can check if the combination selected in
the validation boxes already exists in the spreadsheet.
2. I also want to check if the respective combination exists in a different
spreadsheet and, if yes, to copy some sales volumes (e.g. Aug and Sept) to
the initial file.
Thanks in advance for your help,
I have a sales planning worksheet, some of the columns being:
Sales Rep Customer Ship-to Article Plant Aug 08 Sept 08 ...
There can be up to few hundreds rows. At the top of the worksheet I have a
row with validation boxes that allow me to enter new Sales
Rep/Customer/Ship-to/Article/Plant combinations and the sales forecast for
the respective combination.
1. I want to create a macro that can check if the combination selected in
the validation boxes already exists in the spreadsheet.
2. I also want to check if the respective combination exists in a different
spreadsheet and, if yes, to copy some sales volumes (e.g. Aug and Sept) to
the initial file.
Thanks in advance for your help,