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,

Hi

Just to get you started: you might want to use for instance a DCOUNT
function, and test how many records result.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"C. Corodan" wrote:

> 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,

Thanks a lot, this is exactly what I was looking for with regards to point
number 1! I was not aware that such a function exists

Any idea for point number 2?

"Wigi" wrote:

> Hi
>
> Just to get you started: you might want to use for instance a DCOUNT
> function, and test how many records result.
>
> --
> Wigi
> http://www.wimgielis.be = Excel/VBA, soccer and music
>
>
> "C. Corodan" wrote:
>
> > 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,