I am using MS Office Excel 2007 and need to know how to copy a row of data from one worksheet to another worksheet using a criteria from column of cells with data.
example: worksheets are (2011 Surgeries) and (Non Paid Surgeries)
I have a column set up with If statement that has if cell a2 = 0 then enter "REVIEW" in Cell u2.
Now I want to either write an If statement or create macro to look at all cells in column u with "REVIEW" and copy the whole row of data from 2011 Surgeries to a row in Non Paid Surgeries. And then maybe add if I enter dollar amounts in 2011 surgeries when paid that it will delete the row of data in Non Paid Surgeries.
I am kinda stuck on this and am not savvy with excel
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com,http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.
Note: your data need not be to be real data but a good representative of how data looks like