updating spreadsheet from another spreadsheet

i need to update spreadsheet(B) from a seperate spreadsheet(A) that is on a
share drive. i only want information that has been update, added, ect from
(A) to populate (B). With a color coded cell (yellow) showing that the data
from (A) is new when opening or manually running the macro on (B). (A) is a
master spreadsheet that i need only a few of the columns data to populate
(B).

i am using Excel 2003

thanks

also wanted to add that spreadsheet (B) will have data getting inputed on it
and i don't want that over written when new or updated data is entered on
spreadsheet (A).

thanks

"Mintz87" wrote:

> i need to update spreadsheet(B) from a seperate spreadsheet(A) that is on a
> share drive. i only want information that has been update, added, ect from
> (A) to populate (B). With a color coded cell (yellow) showing that the data
> from (A) is new when opening or manually running the macro on (B). (A) is a
> master spreadsheet that i need only a few of the columns data to populate
> (B).
>
> i am using Excel 2003
>
> thanks
>