create multiple worksheets from a mastersheet same workbook

I

Insurance Pam

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

Embed the same Excel multiple times 0
Create a chart from a table in word thats dynamic 0
Multiple column search and Copy 7
Lookup Question with multiple dynamic variables 14
Creating a Chart on form from selected data in query. 0
Automatic Update in Multiple Worksheets 0
Copy entire row from another sheet onto first sheet if a unique text matches 1
External cell reference between two excel worksheets both in One Drive 0

Top