Macro for updating specific cells

[r4gnar]

Hello Excel Forum,

I tried to find a solution before posting this, but since I don't really know how to name the problem I'm asking for help directly. English isn't my first language so bear with me.

I'm in desperate need of an macro that will update specific cells for me. Here are the details:

I have a database in excel format with over 140k records (company names). Sometimes I go to that database and filter what I need. I do that because some of those companies information need to be updated. Then I copy selected companies to a different file and I remove columns that I won't be updating. (For example I select 1000 companies from my big DB, copy them, and remove columns with phone number, website address and leave only fax number and postal code). Next, I update that 1000 records, not every fax number and postal code will be updated, but some surely will. After this is done I need this macro that will copy that 1000 records back to my big database and update what has changed. (For example if the fax number had changed, it needs to be changed in my big DB).

All the company names and column names are the same in both my files. But every time I need to update different information, email and adress for example, so I only leave this two columns, as I won't be touching anything else. After Im finished with finding adresses and emails, everything I found must go back to my big database.

After I select companies that require an update, the formatted file lands on google docs, and couple of people work on it. I then download it when they are finished. How do I put it all back to my big database without having to find it and copy/paste it all manually?

I hope it's clear enough for you.

EDIT: I forgot to mention that there might be duplicated names of companies, with different addresses.

[r4gnar]

/bump

Anyone?

[r4gnar]

/bump

Still nothing...

[r4gnar]

Come on guys, it's been 11 years. Surely someone figured this stuff out.

[cubangt]

If you can add a sample file to your post, may get more assistance..
Copying and pasting between sheets/ workbooks is pretty simple..
If your your company name is unique, then updating may be pretty straight forward as well..

And if you are deleting columns once you copy over to do your updating, you can simply copy only the columns you want to update..
instead of copying everything over and then deleting columns down to the two you will update.