Copying cell values to different file

Hello,

I've got a quote template where if the user enters a customer contact information that doesn't appear on a database excel file, then it will automatically add it to the database file. I've got everything to work (selecting value, opening database file etc..) except for moving the contact information over to the database excel file. It works by getting the company name on the template file, then finds and selects the cell that has the same company name. I need it to then take the contact first name from the template and copy it to the same row (but 4 columns to the right) the company name is on in the database file. Hopefully that makes sense. Here is the code:

Please Login or Register  to view this content.

Hi Dave, I tried your first suggestion as I didn't need to modify the rest of the code all that much, but it didn't work. It's not populating any info into the database file. Thanks.

Originally Posted by davegugg

Try this:

Please Login or Register  to view this content.

I won't quote you anymore. I tried the last suggestion and it's not working either. It debugs fine, but still not copying the data over to the database file. Thank you for help on this.

No go on that one either. No error messages, just not copying the values over.

That looks to be a winner, I need to tweak it a little but it pulled the data over. Thanks for all your help.