Move data from one sheet to many sheet using VBA

[hayder]

hi All,

i have a problem, i have a sheet having master data of customers. and at the end of every week i move date (Via Copy Paste) from master sheet to other sub sheets of the same workbook.
these sub sheets are around 100 so it is very boring and time consuming work for me. any body please help me to get rid of this.
i attached a sample file for reference, and "Customer Name" Column is use for Distribute or move data to other Sheets.

Thanks

Hayder Ali

[Olly]

Does the data in [Master Data] replace the existing data in each customer worksheet, or should it be appended to the bottom of existing data?

[Olly]

Try this:

Please Login or Register  to view this content.

You can change the 'DataOption' value to choose between replacing existing data, or appending to existing data.

Updated workbook attached.

[Exited]

Hi,
Give this code I developed for others on another forum a try & see if it does what you want.
Code displays an inputbox where you select the field heading (customer name) you want to filter & will copy data to their respective sheets. If sheet does not exist, code will create it.
Each time you run the code, all sheets will be refreshed.
Solution is designed to be universal & should be able to be used in any project without any changes.

Hope helpful

Dave

[hayder]

Thanks for your prompt reply dear. it is indeed very helpful for me.
thanks again