I am making a sheet for work and I need to split a colum up into groups of worksheets

[caseymallory]

I have a sheet I'm doing for work. The master sheet is set up with 4 columns. A= the persons customer number, b= date ordered, C= customers name, D= Item ordered, E= location. I would like to be able to type Location 1,2,3,4 and so on and have them each auto put the info from columns A-D into a worksheet for each Location. So I can pull up the Location 3 worksheet and all the persons info will be in a list there and so on with the other locations. I was wondering if this was possible and if so how do I do it. Thanks for your help.

[arlu1201]

This is a possible through a macro. A few questions for you -

Do you want the data transfer to happen once you have updated all the info or once each line is complete?

If you want to update fresh data into the master sheet, will you clear the existing data and then update or will you update the new data in the next available row of the master file?

[caseymallory]

I would like it to do it as I type so each row. I would like to just continue on one sheet not deleting. Hope this answered your questions. So update after each leaving the list. Thanks