I have info in cells a3, a19, a35, a51 etc, ie every 16th cell.
I want to copy that info into b3, b4, b5, b6 etc, therefore info running consecutively with no lines in between
Is there a quick way of doing this, eg b3=a3, b4=a3+16
there is other info in the cells/rows inbetween therefore cannot filter/delete
still a novice at this type of formula.....
Cheers
I want to copy that info into b3, b4, b5, b6 etc, therefore info running consecutively with no lines in between
Is there a quick way of doing this, eg b3=a3, b4=a3+16
there is other info in the cells/rows inbetween therefore cannot filter/delete
still a novice at this type of formula.....
Cheers