Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I receive a workbook with three worksheets that have cells in them that are
changed. the worksheets are Servers, Network and Storage The cells have a colorindex = 4 if changed. I put the received in a folder C:/site changes and the Master in C:/Master Inventory I would like to have a Macro that would match column A between worksheets and if the received file has any change cells (green) move the value of that cell to the corresponding cell in the master worksheet. The worksheets have up to 37 columns and could have a thousand rows or so. The received worksheets typically have 5 to 75 changed rows. -- Thank You |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to copy specific data from master workbook to another workbook | Excel Programming | |||
Copy worksheet from one workbook to a master workbook | Excel Worksheet Functions | |||
Copy Worksheets Into Master Workbook | Excel Programming | |||
copy data from one worksheet to identical sheet in different workbook | Excel Discussion (Misc queries) | |||
Replacing workbook with master copy | Excel Programming |