create multiple worksheets from a mastersheet same workbook

G

Guest

I am attempting to create a Master data entry sheet as well as having it
break out into multiple sheets based on the data entered in the first column.
Example: If I put "MAA" into the first column the row of data would also be
entered into a workbook sheet named MAA, if I enter SRP data would also be
entered into a sheet name SRP. Any help with this would be greatly
appreciated.

Currently at the end of each month I am manually sorting though data,
cutting and pasting it into indiviual sheets.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple column search and Copy 7
Auto update worksheets 2
Excel Workbook with Multiple worksheets 2
combining data from multiple worksheets into one 6
AVERAGE NON-ZERO CELLS ACROSS SEVERAL WORKSHEETS IN SAME WORKBOOK 7
Multiple worksheets within a workbook 2
Splitting data from one spreadsheet into multiple spreadsheets 2
summary values across worksheets within the same workbook 2

Top