GMC The Macro Man
Board Regular
- Joined
- Mar 23, 2023
- Messages
- 64
- Office Version
- 2021
- Platform
- Windows
Hi there
I have a daily report that I need to run a Macro on however some of the detail in Column D (Ticket) is missing. What I need is the Macro to look at Column D only and if there is a BLANK cell then to copy the Cell above that has Data.
So Cells D3 & D4 will become Ticket -806, Cells D6 & D7 will become Ticket -804, D9 will become Ticket -802, D14 & D15 will become Ticket -803 and so on until the end of the column. Once that is done I can then continue with my Macro.
Any help would be appreciated
Thanks in Advance
I have a daily report that I need to run a Macro on however some of the detail in Column D (Ticket) is missing. What I need is the Macro to look at Column D only and if there is a BLANK cell then to copy the Cell above that has Data.
So Cells D3 & D4 will become Ticket -806, Cells D6 & D7 will become Ticket -804, D9 will become Ticket -802, D14 & D15 will become Ticket -803 and so on until the end of the column. Once that is done I can then continue with my Macro.
Any help would be appreciated
Thanks in Advance