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!

Vba to copy and paste rows if condition is met
Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
Excel copy data from one sheet to another if a condition is met - Excel Forum
Macro to compare 2 sheets and copy differences ✓ - Excel Forum
How to enable vba in excel - Guide
Number to words in excel without vba - Guide

1 reply

Answer 1 / 1

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

Similar discussions

Excel VBA copy and paste loop with logic condition

vba copy data from a range and paste to empty column

Copy paste special into last row of another worksheet

How to copy a data from one sheet to another, when specific criteria is met

Merge rows if it meets criteria in Excel

Copy rows based on a condition

Similar discussions

Subscribe To Our Newsletter!