macro and worksheet name

[Andersan]

Hello guys,

I created a macro for data segregation and extraction.

My currently flow is:

• create new worksheets
• rename the worksheets to eg, sheet1 to product1, sheet2 to product2, etc
• manually filter the main data sheet, copy and paste the data into the respective sheets

how to i edit the codes to allow the renaming of the worksheets to be non-static?
meaning it doesn't have to be sheet1 to product1, sheet2 to product2
i can have sheet3 to product1, sheet4 to product2 or sheet7 to product1, sheet8 to product2

i feel that my method of data segregation and extraction is kind of rigid. is there any methods i can make it to be more fluid/dynamic?

I'm a novice to advanced excel, appreciate your help.

[swoop99]

Please Login or Register  to view this content.