JuicyMusic
Board Regular
- Joined
- Jun 13, 2020
- Messages
- 210
- Office Version
- 365
- Platform
- Windows
Good morning,
I have a PDF that I'm converting to Excel. All the data gets populated in column A. The last row of data varies.
I usually use the Ctrl-G autofill formula to copy the data from the row above. I need a different autofill formula. I would prefer a Macro to run on whatever column I am highlighting.
Is there a VBA to insert whatever type of text I'd like in the blank cells....till the last row of data? For example, I'd like two asterisks (**) to be filled in every blank cell in column A (or whatever column I have made active.
Thank you so much,
Juicy
I have a PDF that I'm converting to Excel. All the data gets populated in column A. The last row of data varies.
I usually use the Ctrl-G autofill formula to copy the data from the row above. I need a different autofill formula. I would prefer a Macro to run on whatever column I am highlighting.
Is there a VBA to insert whatever type of text I'd like in the blank cells....till the last row of data? For example, I'd like two asterisks (**) to be filled in every blank cell in column A (or whatever column I have made active.
Thank you so much,
Juicy