Automatically populate data to multiple sheets

Hi,

I have a spreadsheet that contains many lines of information that will constantly be added to and updated. One of the columns contains a drop down with 4 possible options. I am trying to get the data to copy to a sheet based on 1 of the 4 options selected. So for example, if Education is selected, then that row of data should also appear in the Education sheet. Same goes if one of the other options is selected.

I have seen several examples on this forum, but they are mostly macros (or formulas that don't quite apply). I am trying to use formulas so that the information is updated live so macros don't really seem to be a viable option.

I am including a sample of the spreadsheet with data on the main sheet and how I want it to look when it is transferred over to the other sheets. I had to substitute a lot of the information (with numbers or filler words) due to it being confidential, but this should give a good enough idea of what I am trying to do. Please let me know if you have any additional questions.

Thanks in advance!

Originally Posted by Melvinrobb

By adding in some helper columns and rows, the attached should work
I only added the formula for the entertainment tab. The rest will work exactly the same way.

Awesome, I only briefly looked at it, but that looks perfect.

Thanks Melvinrobb! Happy New Year

Originally Posted by Melvinrobb

By adding in some helper columns and rows, the attached should work
I only added the formula for the entertainment tab. The rest will work exactly the same way.

I was able to look at this further and it looks like it will work perfectly. Thanks again Melvinrobb

Originally Posted by xladept

Hi dfulmer,

Here's an event procedure for your "All Content" sheet:

Please Login or Register  to view this content.

Directions for running the routine(s) just supplied

Copy the code to the clipboard

Press ALT + F11 to open the Visual Basic Editor.

Select “Module” or “Sheet” as directed above from the Insert menu

Type "Option Explicit" then paste the code into the white space on the right

With the cursor between Sub and End Sub press F5 (F8 to Single Step)

OR

Press ALT + Q to close the code window.

Press ALT + F8 then double click on the macro name

Although the formula solution above works fine, I am kind of curious to check this method out but it isnt working for me. I add the code to the sheet page and then close the window. When I hit Alt-F8, there is nothing for me to run in that list, but if I change one of the drop downs I get a Run-time error '1004' - Method 'Range' of object '_Worksheet' failed. Any ideas what I'm doing wrong?