G
Guest
An excell spreadsheet works as a master log of forms completed over a period
of time.
A macro opens the master log, finds the next empty cell in a column and
copies a cell of information to the cell in the other workbook. This part
works fine.
It then needs to go to the next cell on the left and copy an additional
information from the form workbook. When I use the "record a macro" it
inserts the absolute cell name (say G2) rather than a relative address (i.e.,
move one cell to the left). What statement should I use?
of time.
A macro opens the master log, finds the next empty cell in a column and
copies a cell of information to the cell in the other workbook. This part
works fine.
It then needs to go to the next cell on the left and copy an additional
information from the form workbook. When I use the "record a macro" it
inserts the absolute cell name (say G2) rather than a relative address (i.e.,
move one cell to the left). What statement should I use?