I apologise if this has been answered before but I want back over 7 sheets and couldn't see it.
Here is my problem.
I have a spreadsheet that tracks projects and their various states of completeness. I need to go through the sheet and find anywhere that states more or less than a percentage and pull it into another sheet for my boss to look at so that he can determine if he needs to get involved. This might include peoples comments that say "I am about 50% done but waiting for X" My boss needs to know all of the information in all of the columns to judge whether his involvement is necessary. This was easy in the past to do manually but with more projects and less time (something we can all relate to) this spreadsheet is getting too big.
I would like to have an input cell at the top to say something like <50% and then hit a button to extract all of the rows that fit that criteria. Some weeks he may only need to see the projects that are 25% but some weeks he may need to see anything less than 75%. In the explanation below the Working Sheet is where everyone inputs their data and the Copying Sheet is where I want the information extracted too. I figure it would be easier to insert a row at the top than to try to find the bottom. I can talk out the macro but I can't write it...Here it is:
find "(contents of the input cell)" in (range)
Copy row (or columns A - Z in the row that contains the criteria)
Goto (copying sheet)
Insert row at the top
Paste
Goto (Working sheet)
continue search for next match
Copy row
Goto (copying sheet)
Insert row at the top
Paste
Goto (Working sheet)
(continue to the end of the range)
Thanks in advance for your help.
Bookmarks