VB code help- need copy cells in a row and paste to new sheet on next available blank line

NEED A BIT MORE INFO...
What type of cells will you be pulling, and for what point?

cells will be date, text and numbers
they are to prevent user having to dupe entry from one sheet to another
same data to be transferred from one sheet to another, but transferred to the next available blank line on the new sheet

hope thats helps

Here is attachment hope it helps

so you do not want to copy the cells that are not blue? or can they be copied as well?

HI
no i need to copy the blue cells from copy from
and paste them to the red area in paste to

its not the whole row just the blue cells

that makes it harder...
Will the non-blue cells in copy from be blank or have other data in them?

they will have data in them

There are too many variables here...
Will it always be columns B C E G and I that get copied...
Please specify mroe thoroughly what you are trying to accomplish...

would it help if the cells to be copied are only columns 12345 and get pasted to 12345 columns on the copied to sheet on the next available blank line?

yes it would help greatly...

ok cool can you help me with that?

yes, but i am still missing some info...
Will the blue spots always be in the same spot?

yes in column but maybe in a different row, the row to be determined by the user selecting the first cell of the row they want to copy blue cells from

Is this like what you are looking for?
CopyInfo.xlsx.xlsm

if that solved your issue, click solved, and the star under my name if i helped...

Thanks for that- that is perfect
I appreciate your help

Regards
Barbara

no problem, dont forget to mark as solved...