Help with a function to copy a rown when a criteria is met in a colomn

[gracefilkins]

I have an excel spreadsheet. (Tabs: Everything; CourseCatalog; Old) In the CourseCatalog I need anything from Everything in Colomn C that is marked as GA to copy over the entire row. When it is copied over to CourseCatalog I will hide some colomns. This will need to be something that happens automatically so as to avoid human erro and missing anything. I have tried a VBA code (which I am not very familiar with), a Pivot table and a VLOOKUP but I just cannot get it to work right. I am not very familiar with VBA and I cannot get the Pivot to do what I want it to. I am open to any options.

For informational purposes Colomn C in Everything is an IF Statement. When someone puts a date in a range this IF statement changes so a user can look to see if the project is in Alpha, Beta, GA or Retired.

Thanks for any help.

 

[dmt32]

Hi welcome to forum,

Have you tried using AdvancedFilter Copy which should be able to do what you want.

Have a look at these links & see if any help to you:

http://www.contextures.com/xladvfilter01.html

Copy Data to Another Worksheet with Advanced Filter | Excel Semi-Pro

Hopefully will assist you but if not, post back with more detail of your workbook - plenty here to offer advice & guidance.

Dave