Previous Topic Next Topic

Copying data from worksheet 1 to worksheet 2

Solved/Closed
FromNC2PR Posts 4 Registration date Tuesday December 20, 2011 Status Member Last seen December 22, 2011 - Dec 21, 2011 at 06:31 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Dec 22, 2011 at 01:04 AM
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!
Related:

2 responses

Answer 1 / 2
FromNC2PR Posts 4 Registration date Tuesday December 20, 2011 Status Member Last seen December 22, 2011
Dec 21, 2011 at 12:07 PM
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)
0
Answer 2 / 2
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
Dec 22, 2011 at 01:04 AM
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
0