It really isn't practical to do this with a formula, that's why I provided the macro. If you add it to your workbook's 'main' sheet code module, your other sheets will be updated automatically any time a new line is completed on the 'main' sheet.



To add the macro to your workbook's 'main' sheet code module, press Alt-F11 to start the VB Editor, double-click on the 'Sheet1(main)' entry on the left, then paste the code from my post into it. Oh, and fix up the spelling errors (e.g. 'Customer A', not 'cutomaer A')!

PS: Please don't quote the entire post responded to in your replies; if something needs to be quoted, quote only that part.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

1. I have renamed the sheet Customer A.

2. Thanks for the opinion, i would now quote only important things.


Now since i am doing this for the first time, this easy job looks a bit hard for me
here is what i did>>>>>>


I copied your code, and in my workbook perss alt+ F11(it opened VB editor) i dubble click on sheet one(main) and paste your code there .

after that i go to "file" Tab and choose> "Close and return to Microsoft Excel"(alt+Q)

i dont see any changes in my workbook.nor i see any saved micro to run

what to do now?

i know i am not doing it in a right way.please help me

Now you enter some data on a new row the main sheet. As soon as columns A to D or F to I are completed, the data for that row will be copied to the Customer A or Customer B sheet.

The macro doesn't change any existing data. If you need to transfer the existing data, I'd suggest sorting columns A to D by customer name, transferring their data to the Customer A & Customer B sheets, then doing the same for columns F to I. You can re-sort columns A to D & F to I by date afterwards.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]