I posted something like this before, but maybe I wasn't clear in my
explanation.

Let's say I have 2 workbooks (A and B) and workbook A is in directory X and
workbook B is in directory Y. Sheet 1 of Workbook A has data in cells A1:F1
and an unlimited number of records. Sheet 1 of Workbook B has the same data
that's on sheet 1 of Workbook A in it's cells A1:F1 (basically duplicate
info) but sheet 1 of Workbook B also has other data in cells G1:K1.

When a new record is added or if any of the cells gets updated in sheet 1 of
Workbook A, I would like to copy all of sheet 1 of Workbook A (cells A1:F1)
over into sheet 1 of Workbook B in its cell A1:F1 since both sheets have the
exact same data in their A1:F1 range. But since sheet 1 of Workbook B has
different data in its G1:K1 cells, I want to leave that alone in the copy
operation.

Can someone please help me on this. I'm new to these features of Excel and
so I am somewhat lost.

Thank you,