Hi,
I'm pretty new to VBA and would like to write a simple Macro to hunt down rows until a gap is found and then fill this gap with data copied from the row above - the number of columns might vary but 'A' will always have a continuous list of timestamps. I've attached a sample file below.
Any advice on how I might best go about this would be great
I'm pretty new to VBA and would like to write a simple Macro to hunt down rows until a gap is found and then fill this gap with data copied from the row above - the number of columns might vary but 'A' will always have a continuous list of timestamps. I've attached a sample file below.
Any advice on how I might best go about this would be great