samanthanyw
New member
- Joined
- Dec 9, 2019
- Messages
- 4
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
I'm fairly new to VBA and thus I need some help with this.
I have a worksheet "Activities", and whenever a number (other than 0) is entered into the column "# of Travel Shifts" I'd like that whole row to be copied onto the tab "Travel".
I've searched on here to find answers - but they never seem to do exactly what I'm looking for (or they don't work at all).
I've attached the sheet so that you know exactly what I'm referring to.
My second issue is that this workbook will be constantly updated - and I do not want to repeat the rows on the Travel tab - but instead update travel tab. So for example, if I put travel days at 2 for row 8 - then that row would show up on the Travel tab. But if I change that 2 to 0 - then that row will be removed on the Travel tab.
Does that make sense?
I'm not sure if VBA is the way to do any of this - but I thought it would be a good place to start.
I have a worksheet "Activities", and whenever a number (other than 0) is entered into the column "# of Travel Shifts" I'd like that whole row to be copied onto the tab "Travel".
I've searched on here to find answers - but they never seem to do exactly what I'm looking for (or they don't work at all).
I've attached the sheet so that you know exactly what I'm referring to.
My second issue is that this workbook will be constantly updated - and I do not want to repeat the rows on the Travel tab - but instead update travel tab. So for example, if I put travel days at 2 for row 8 - then that row would show up on the Travel tab. But if I change that 2 to 0 - then that row will be removed on the Travel tab.
Does that make sense?
I'm not sure if VBA is the way to do any of this - but I thought it would be a good place to start.