Copy one line to another sheet

[Cupragsw]

I know this may be an easy one but I cannot remember.

I need to copy Cell c16 d16 and e16 on sheet called Graeme to a the next blank space on a sheet called worked cases and then clear the cells C16 d16 e16 on Graeme

Many thanks

[JapanDave]

Maybe,

Please Login or Register  to view this content.

[Cupragsw]

thanks but that only clears the row I need to copy across first then clear

[JapanDave]

You lost me???????

[Cupragsw]

you code did not copy the data over to the other workbook

[JapanDave]

What is the actual name of both sheets? And capitals matter

[Cupragsw]

Graeme and Cases Worked

[JapanDave]

So you want copy and paste code,

here you go,

Please Login or Register  to view this content.

[Cupragsw]

Yeah no that not working
nothing appears on the second sheet

sheet Graeme is for data enter so the info is entered into the cells I have reference and then copied across to the cases worked sheet col A B C Not including row 1.

and the data cannot overwrite its self it is just meant to write below the pre line so the next clear row on cases worked

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.

[Cupragsw]

that does work but it cuts out my drop down box in d16.

it just needs to copy the value in that box at the time and clear it ready for the next selection

[bakerman2]

Please Login or Register  to view this content.