Previous Topic Next Topic

Copy Row if condition is met

Closed
Jen - 17 Mar 2011 à 13:41
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 18 Mar 2011 à 10:41
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!

Related:

1 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
18 Mar 2011 à 10:41
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
Yogibearv -
Yogibearv -

6 responses
vba copy data from a range and paste to empty column
vonnyS -
vcoolio -

7 responses
Copy paste special into last row of another worksheet
Roy -
TrowaD -

3 responses
How to copy a data from one sheet to another, when specific criteria is met
TomasSurvilas -
TrowaD -

13 responses
Merge rows if it meets criteria in Excel
cacaip89 -
rizvisa1 -

6 responses
Copy rows based on a condition
Blossom83 -
ravichennai86 -

30 responses