Busscheduler
New Member
- Joined
- Nov 23, 2020
- Messages
- 41
- Office Version
- 2016
- Platform
- Windows
Hi, I’m working on a macro to copy and paste different cells:
Cells(rows.count, “AF”). End(xlup).select
Active cell. Offset(0,-1).select
I have the macro finding the last cell in column AF, coming back up to the first cell with data and then moving one cell to the left “AE” and selecting that cell. I need it to copy cells AE:AG of that row and insert that into AH and shift the cells down to insert. I need it to loop through the rows from bottom to top and do this for each row, if cells in AF have data in them.
Thanks for any help I can get on this. I just can’t find the right code to make all of this happen in the short time I have to get this done.
Cells(rows.count, “AF”). End(xlup).select
Active cell. Offset(0,-1).select
I have the macro finding the last cell in column AF, coming back up to the first cell with data and then moving one cell to the left “AE” and selecting that cell. I need it to copy cells AE:AG of that row and insert that into AH and shift the cells down to insert. I need it to loop through the rows from bottom to top and do this for each row, if cells in AF have data in them.
Thanks for any help I can get on this. I just can’t find the right code to make all of this happen in the short time I have to get this done.