Paste to next empty cell in named range of cells
Is "ins" a UserForm or is it a regular worksheet that you've set up to look
like a nice, neat data entry form?
I'm going to assume it's a worksheet set up to look like a data entry form
-- if that's correct, we need to know:
which cells will be accepting data that is to be copied over to "dcs",
how to decide which cells to copy over to "dcs" and which ones not to copy,
and
where (which columns) do you want to put the information that is copied and
pasted into the "dcs" sheet.
"Sully" wrote:
I need Macro or code to paste between 1 to 6 entries from a form "ins" to a
range of cells on a summary document "dcs", and clear "ins" entries. Then
be able to use "ins" again and post to "dcs" starting at next empty cell in
range.
|