| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying an Entire row using an IF Statement
Hi
I want to use the below code to copy an entire row to a new sheet when a = true. Can anyone help ! Sub YTD_Modifer() r = 2 a = "1st Quarter Quarter" Do Until Sheets("Data").Cells(r, 2) = "" r = r + 1 If Sheets("Data").Cells(r, 2) a Then copy entire row to a new sheet End If Loop End Sub Many thanks Marcus |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If statement to copy an entire row to other worksheet w/ in same b | Excel Worksheet Functions | |||
| Copying/Linking Entire Workbook | Excel Discussion (Misc queries) | |||
| copy an entire row IF a statement is true | Excel Worksheet Functions | |||
| Copying entire worksheets | Excel Discussion (Misc queries) | |||
| Macro for copying entire raw | Excel Programming | |||
Threaded Mode
