Macro: Cut/Paste Entire Row Into New Sheet Based On Cell Value

Closed

IAmClearlyNotBatman Posts 1 Registration date Monday May 12, 2014 Status Member Last seen May 12, 2014 - May 12, 2014 at 06:36 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 13, 2014 at 10:45 AM

Hi there,

I'm struggling to create a working macro that finds a specific value in a column and then, only if the condition that the cell's value equals a specific value, cuts and pastes the entire row of that cell into another sheet.

Any thoughts?

Thanks

Excel move rows to another sheet based on criteria
Vba code to move rows to another sheet based on criteria - Best answers
Excel vba copy data from one sheet to another based on cell value - Best answers
Spell number in excel without macro - Guide
Macro excel download - Download - Spreadsheets
Automatically run a macro when opening a worksheet - Guide
Excel macro to create new sheet based on value in cells - Guide
Macro to insert row in excel based on criteria ✓ - Excel Forum

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
May 13, 2014 at 10:45 AM

Hi IAmClearlyNotBatman,

Take a look at the link below and let us know where/if you get stuck:
https://ccm.net/forum/affich-752710-insert-row-data-on-sheet2-based-on-sheet1-cell-value-text#p753151

Best regards,
Trowa

Similar discussions

Code to move rows into another sheet based on certain values

Copy rows to other sheets based on value in column

Copy Rows from one sheet to others based on a condition

Copy rows based on a condition

copy a row from one worksheet to another, based on criteria

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

Similar discussions

Subscribe To Our Newsletter!