Copy Row if condition is met
Closed
Jen
-
Mar 17, 2011 at 01:41 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 18, 2011 at 10:41 AM
rizvisa1 Posts 4478 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!
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:
- Excel copy rows if condition met
- Excel mod apk for pc - Download - Spreadsheets
- Dash becomes date on excel ✓ - Office Software Forum
- Gif in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Number to words in excel - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 18, 2011 at 10:41 AM
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
