T
Taylor
I need a macro that will copy information from a specific range of cells
(A1:A3, for example) and paste that information into a selected range of
cells. Here's the catch: after new info is input and copied, I would like
for it to be pasted in the range of cells directly below whatever info was
previously copied and pasted without deleting the info previously copied and
pasted.
For example:
Type Name Address Phone Number in Cells A1, A2, A3, respectively. Run macro
to copy information from A1:A3 and paste it in B1:B3. Return to Cell A1 and
type Taylor, 123 4th St, 999-9999 in cells A1, A2, A3, respectively. Run
same macro as above with command that will paste this new information in
cells C1:C3 (directly below previously entered info). I hope this makes
sense?
(A1:A3, for example) and paste that information into a selected range of
cells. Here's the catch: after new info is input and copied, I would like
for it to be pasted in the range of cells directly below whatever info was
previously copied and pasted without deleting the info previously copied and
pasted.
For example:
Type Name Address Phone Number in Cells A1, A2, A3, respectively. Run macro
to copy information from A1:A3 and paste it in B1:B3. Return to Cell A1 and
type Taylor, 123 4th St, 999-9999 in cells A1, A2, A3, respectively. Run
same macro as above with command that will paste this new information in
cells C1:C3 (directly below previously entered info). I hope this makes
sense?