DATA FROM MASTER SHEET TO SUB SHEETS

[BABU Baru]

I am entering data in Master sheet for all customers.

Name of sub sheets is entered in Column A of Master sheet.

I want all data or value to be copied from Master sheet to all sub sheets already created for each customer.

All sub sheets have sum formula in across rows.

Sum formula be applied after transfer of data in sub sheets.

Each time when I run VBA, only new data be transferred or copied in next empty row to sub sheets and apply sum formula without rewriting or over writing.

 

[alansidman]

Show us some sample data of before and after. Use XL2BB to upload your sample data. See my signature for instructions.

 

[Fluff]

Duplicate to: Copy data from master sheet to multiple sheets based on sheet name of individuals

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.