I am trying to write a macro that, after starting at a given reference point,
loops to do the following action for several hundred lines in Excel:

-Moves left a constant number of columns
-Highlights and copies 10 horizontally adjacent cells
-Jumps to another tab
-Pastes the copied values into a given range of cells on the new tab
-Moves to a given cell on the new tab then copies the value from that given
cell
-Moves back to the initial tab
-Pastes the copied value into a given cell on the initial tab

The loop should then tell the sheet to move down one row and repeat the
procedure (moving left a constant number of columns, highlighting and
copying, jumping to another tab, etc).

Any thoughts on how to do this in visual basic? Any help would be very much
appreciated! Thank you in advance.