Automatically Filter to New Sheets

[mgabriel]

I am looking for a way that I can enter data in one master sheet of a worksheet and have it be filtered to different tabs within the same worksheet based on a data in one of the columns. Anyone know how this can be done?

[stnkynts]

Yes, but we are going to need a lot more information that what you provided.

[mgabriel]

I have a column in my master sheet labeled "Job #".. I would like the data distributed to tabs based on the job #'s.. I tried to upload my spreadsheet for you to see but the file is too big.. What else do you need to know?

[stnkynts]

Try this and see if it does what you want:

Please Login or Register  to view this content.

[mgabriel]

Where do I paste it?

[stnkynts]

Assuming you are using Excel 2013 as indicated, you are going to have to enable the "Developer" tab. Do a google search if it is not enabled to see how to do it. Then under the developer tab you will see Visual Basic. Click that to open up the visual basic editor (VBE). Within VBE right click on ThisWorkbook then Insert -> Module. Paste the code in that module which should be Module1 (any module will work)

Back under the "Developer" tab you should see an option right next to Visual Basic should be Macros. Click Macros to view and run the Job_Transfer Macro.