Hello,

I have a bit of a problem. Once a week I receive updates from several
sources that need to be input into my master workbook. I have twelve columns
of data including two date formatted columns and one hidden column. The
master workbook has anywhere from 1200 to 1500 rows. When I open the update
workbooks with updated information all updates are in red. Is there a way
using vba that after opening the updated workbook, I can have a macro in my
personal workbook that would by the click of a button, open the password
protected master workbook, lookup the id code located in column 4 and if the
same id code column 4 of the update workbook has red font in columns 5
through 12 in the updated workbook, have it copy that entire row as it and
paste it to the master workbook close and save the workbook. I will have as
many as 200 to 300 changes form each source to update. If I could get help
with this it would make life much easier for me and I would greatly
appreciate it. By the way I have row one as the column header. All
workbooks are formatted the same with the same type of data in all columns.
Thanks in advance for your assistance and direction.
--
By persisting in your path, though you forfeit the little, you gain the
great.