if product exists then copy to that row

[Wagstaff]

Hi,

I have posted this to another forum but have not received a reply so

The workbook I have created will allow user to set up records for customer
pricing.
The code below is the module that will check if the file already exists and
if so it will add the new record to that file and If it does not exist it
will go to a nother module to create a new workbook.

Please Login or Register  to view this content.

The problem I am having is that if the product already eixts for that
customer I want it to overwrite that row with the new data. I have tried the
code below but, yes you have guessed it doesn't work. Just copies to the last row,same as before.

Any ideas

Please Login or Register  to view this content.

[Wagstaff]

I have managed to sort.

if there is anyone interested I will post.

Cheers

[royUK]

post in case anyone else needs similar help

[Wagstaff]

Here is the completed code. Alot neater than before many thanks to Per Jessen who help me tidy things up abit.

Please Login or Register  to view this content.