smashthegas
New Member
- Joined
- Sep 10, 2015
- Messages
- 4
Hi everyone,
I am looking for some assistance please with some VBA to paste between worksheets. I have a workbook with three tabs all containing the same headers and I am looking for VBA to help paste rows from the first tab to the second or third when there is a certain value in columns V or W of the front tab - "live cases"
If the word "Yes" is entered in column V, then when the macro is run I want it to paste the entire row to sheet 3 "JMB" on the next available (blank) row, or if there is a date entered in column W I want it to do the same onto the "concluded" sheet, sheet 2. I would then like the entire row to delete itself from the "Active Cases" sheet.
I have played around an managed to do bits and pieces but I am still learning after many years and am still only on the basics. I have attached a screenshot of the first sheet - the other 2 sheets are the same, which is where the pastes will go.
Thank you so much
Excel 2013/2016
<colgroup><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
I am looking for some assistance please with some VBA to paste between worksheets. I have a workbook with three tabs all containing the same headers and I am looking for VBA to help paste rows from the first tab to the second or third when there is a certain value in columns V or W of the front tab - "live cases"
If the word "Yes" is entered in column V, then when the macro is run I want it to paste the entire row to sheet 3 "JMB" on the next available (blank) row, or if there is a date entered in column W I want it to do the same onto the "concluded" sheet, sheet 2. I would then like the entire row to delete itself from the "Active Cases" sheet.
I have played around an managed to do bits and pieces but I am still learning after many years and am still only on the basics. I have attached a screenshot of the first sheet - the other 2 sheets are the same, which is where the pastes will go.
Thank you so much
Excel 2013/2016
A | B | C | D | U | V | W | |
---|---|---|---|---|---|---|---|
1 | Surname | Forename | DOB | JMB | Concluded | ||
2 | Smith | Tom | 01/01/1960 | Yes | |||
3 | Smith | Tom | 01/01/1960 | 01/01/2019 | |||
4 | Smith | Tom | 01/01/1960 | 02/03/2019 | |||
5 | Smith | Tom | 01/01/1960 | 05/05/2016 | |||
6 | Smith | Tom | 01/01/1960 | Yes | |||
7 | Smith | Tom | 01/01/1960 | Yes |
<colgroup><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Live Cases