gregtgonzalez
New Member
- Joined
- Dec 16, 2016
- Messages
- 29
Hello all!
I have posted here before and am SO thankful there are so many willing people to help novice XL-ers......
So I have attached a sample workbook, I have a few macros going on this one right now, however, I have come across another dilemma that I cant seem to cross yet. As of right now in each sheet with each name, has Column "AA" which indicates the current status of the line item based on the values of other cells in that Row. If the conditions are met it populates with a simple "YES", what I have to do is manually go in and go to each sheet, filter that column and take all the "yes" line items and transfer them to another sheet called "Send". I have to do the same thing with Column AB, with the "yes, COMPLETE" answers and pull those to a "completed" sheet
I have tried to record a macro but it doesn't seem to be effective for what I am trying to do. Any insight would be of great help!
thanks guys!
https://www.dropbox.com/s/zv1sod4e44pv92y/sample book.xlsm?dl=0
I have posted here before and am SO thankful there are so many willing people to help novice XL-ers......
So I have attached a sample workbook, I have a few macros going on this one right now, however, I have come across another dilemma that I cant seem to cross yet. As of right now in each sheet with each name, has Column "AA" which indicates the current status of the line item based on the values of other cells in that Row. If the conditions are met it populates with a simple "YES", what I have to do is manually go in and go to each sheet, filter that column and take all the "yes" line items and transfer them to another sheet called "Send". I have to do the same thing with Column AB, with the "yes, COMPLETE" answers and pull those to a "completed" sheet
I have tried to record a macro but it doesn't seem to be effective for what I am trying to do. Any insight would be of great help!
thanks guys!
https://www.dropbox.com/s/zv1sod4e44pv92y/sample book.xlsm?dl=0
