View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 2,203
Default 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.