I have a worksheet where a large amount of data that is constantly updated. It is a table with some auto formatting applied based on the value entered in Column C. I would like to have Excel Copy an entire row of information from the first worksheet to a second worksheet in the same workbook.
Please see the attached example.
What I want to happen is to have all of the rows that have a "status" (Column C) = 1 (In worksheet "Estimate List")to be copied to the "Vendor Bid List" worksheet. When the "status" in worksheet "Estimate List" changes to something other than 1 it should be removed from worksheet "Vendor Bid List". I would like all of the compiled data in "Vendor Bid List" to be grouped together and separated by blank rows.
I am not sure the best method to attack this, so the easiest method for accomplishing would be greatly appreciated.
Thanks in advance.