Expert: Bob Umlas - 3/15/2008

Question
There are 2 workbooks (one New and one Master).  Both workbooks have the same column headings (there are 8 columns).  Every time there is a change to data under Column B in the New workbook, I would like a Macro to append the entire row that was changed from New workbook to the Master workbook as a new row and the new row in the Master workbook will be highlighted in Yellow color. In addition, if a new row is inserted (in the middle or anywhere, it could be at the end), I would like the Macro to append the entire row from the New workbook to the Master workbook as a new row and the new row in the Master workbook will be highlighted in Yellow color.  

Answer
There's one basic problem which needs to be addressed: If an entire row in New is being updated, from col A thru H, then when col B is changed and the macro "kicks in", the rest of the information is not yet present to copy to the Master. Same when a row is inserted -- there's no information present yet -- the user is ABOUT to enter new data in the inserted row. But you're requesting a macro to transfer data when col B is changed, even when most of the data isn't present. Please clarify.