Copying data from one workbook to another workbook

[jpstirad]

Hi Excel Wizards,

I have 2 excel workbooks- workbooks 1 is linked with workbook 2. How do you automatically transfer data entered in workbook 1 onto workbook 2- preserving it format along with font/background color?

 

[Anne Troy]

Copy the sheets instead of the cells.

If you don't want the whole sheet, copy it anyway, and delete what you don't want.