Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
checking if a combiantion of values exists on a different row
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, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
checking if a combiantion of values exists on a different row
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, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
checking if a combiantion of values exists on a different row
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checking to see if a file exists. | Excel Discussion (Misc queries) | |||
checking if a sheet exists | Excel Programming | |||
checking if an url exists | Excel Programming | |||
Checking if a worksheet already exists... | Excel Programming | |||
Checking to see if Folder exists | Excel Programming |