Creating separate spreadsheets and/or tabs in a spreadsheet defined from a column

[Colinb07958]

Hi All

I am pretty good at Excel but am struggling with this one a bit. I have experience of using Alteryx and I know there is a feature in that which allows me to do this. I was convinced I have used Excel for this but when I google it says I need to build a Macro (Macro are my nemesis).

Example: If I have 1 spreadsheet and a column titled Location. Within the column is (Office, home, warehouse and shed).

I want to pull the individual locations and data to their own Tab. Possibly also an individual spreadsheet for each one.

Is there a function in Excel that can do this?

Also any suggestions on a good starting point for VBA and Macro as it puts the fear of god into me.

Many Thanks
Colin

[alansidman]

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

[Colinb07958]

Thanks.

Please see example. So if I wanted the location bulked together in separate tabs. I also would like an option for separate spreadsheets too.

[alansidman]

Set up the names of your sheets and then apply this code

Please Login or Register  to view this content.