Excel 2007 : Need to copy from one sheet to another

[diljeev]

Hello.

I need some help with this excel spreadsheet please. I have a purchase order and and the second sheet is a copy of the purchase order. Whatever is entered on the PurchaseOrder sheet I need all fields copied completely to the PurchaseOrderCopy sheet.

Please help me. I will attach the spreadsheet.

[sweep]

Hi,

On the purchaseordercopy sheet insert a formula of this style (G2 used as example)

=IF(PurchaseOrder!G2="","",PurchaseOrder!G2)

and copy to all required cells.