Copy Row if condition is met

Closed
Jen - Mar 17, 2011 at 01:41 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 18, 2011 at 10:41 AM
Hello,

I am new to using excel and vba, but below is what I am trying to do.

I want to know if I can copy a row from one sheet to another if a cell is equal to a specific value in Excel. I have one sheet that contains all of my "Raw Data." If column R is equal to "644", then I want to copy that row of data into my "644 Batches" sheet.

Thanks for any help!

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Mar 18, 2011 at 10:41 AM
So for all values in column "R", there is a corresponding sheet names "xxxx Batches", where xxxx is the value in column R . Also when it copies, would it be like a batch process, meaning wipe out exisitng sheet and then copy information to "644 Batches" sheet
0