Wanting to create a Excel 2007 macro that loops, or auto repeats until it runs out of data to copy/paste. I manually recorded the code below. It works, but depending on the data size (small sample file attached), I might have 1 iteration or 5000 to process.
' Macro1 Macro
Range("B4").Select 'The pattern is Select (the first step will always be B4)
Range("H3").Select 'Select (a cell up 1 and over 6 in this case H3)
Selection.Delete Shift:=xlUp 'Delete
Range("B5").Select 'Repeat until there is no data in the next B cell
Range("B6").Select 'If empty then stop