I'm working with some Excel at the moment where I'm creating some macros to make my life easier. I'm looking for a little bit of code that can move all data from column B underneath column A. The problem with the code is the amount of data in the columns is always different. The paste location will therefore always be different. I'm just looking for the code to move it x amount down and one column to the left.
Screenshot:
Range("A:A").SpecialCells(xlCellTypeBlanks).Address
{}
tag, it'll help us make any attempts in Excel too).