Paste to next empty cell in named range of cells
 

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.

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.

Paste to next empty cell in named range of cells
 

JLatham Thanks for the help
1 Yes, It is a regular worksheet made to look like a form
2 The INS (transaction) cells are A23-A29 each containing a drop down
list were the defalt value is a blank AND D23-D29 containing a
corresponding dollar amount. One or more transactions may be utilized with
each use of the form.
3 The DCS (Daily Cash Summery) destination cells are A12-A19
(transaction), C12-C19($ amount) E12-E19, G2-G19 and I12-I19, K12-K19

I can re-format Daily cash Summery to

"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.

Paste to next empty cell in named range of cells
 

Sorry Hit enter
The INS needs to clear for next use after posting to DCS
I have the same issue posting an OUTS form.
I can re-format the DCS to hve INS and OUTS to be in a continuous list like
A12-A35, C12-C35 for ins and F12-F35, G12-G35 for OUTS if it simplifiess the
issue. Thanks

"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.