Excel Macro Copy cells and pastes them in another sheet

[myfe]

Hi All,

I am trying to create a macro that copies cells and past C16, C18, C20, E16, E18, G16, G18 in another sheet (sheet1) in the next blank row and save the sheet( copy value only ).
File is attached

Thanx for the help

[abousetta]

Hello and welcome to the forum,

There is no file attached. Please re-attach.

Thanks.

abousetta

[myfe]

Hi abousetta ,

Thanx for your reply

I am sorry I wrote file attached my mistake
I couldn't find an option to attach the file I will try to upload the file later on some website

regards

[JapanDave]

You can post an attachment here, by navigating to manage attachments in advance posting.

[stubbsj]

You can try something like this

Please Login or Register  to view this content.

Hope this helps get you started

[Thalassa]

Cross posted and solved here http://www.mrexcel.com/forum/showthr...-another-sheet

[abousetta]

@myfe, please take the time to indicate if you cross-post on other forums and especially when you receive responses that you find fulfill your needs. In the MrExcel thread (which is also cross-posted at vbaexpress) you noted that you are satisfied by the response given by VoG. Next time please share it in all your cross-posted threads so people are not trying to find solution for your problem when you already have one. Also it's a learning exercise for anyone who any one of your cross-posts.

Now that you are satisfied with the answer, please mark this thread as solved.

[myfe]

Hi I am new to this I didn't know that sorry

[abousetta]

No problem. Good luck.

abousetta