Copying data from worksheet 1 to worksheet 2 [Solved/Closed]

Report
Posts
4
Registration date
Tuesday December 20, 2011
Status
Member
Last seen
December 22, 2011
-
Posts
368
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
-
Hello,
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

Please someone help!

2 replies

Posts
4
Registration date
Tuesday December 20, 2011
Status
Member
Last seen
December 22, 2011

Ok this helped now what I want to do is if in worksheet 1 (2011 Surgeries) where I have entered a payment, I would like to run another macro to delete that row from worksheet 2 (nonpaid surgeries)
Posts
368
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
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