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.