code to take specific cells from sheet and copy to next blank line on other sheet across

First time poster and I have tried searching all the forums to see if I could grab a piece of code to do what I am trying to do
I have no vba coding background other then what i can find and tweak to get to work.

Here is my Dilemma ....

I have sheet1 and need to transpose to a summary sheet in same workbook only specific cells.

For example from sheet1 I need the values of C7,C11,C12,D16,D17,D18 and D22 copied to summary sheet across
the first blank line below A8 which contains the headers .

The summary sheet gets added to until the person finishes all items from same supplier and then saves file and starts again.

I tried to use a recorded macro to accomplish this but of course all it does is over write the original data.

Is there a way to use the recorded macro but to check from a8 every time it is run and put the data below it.
(if it was just copying a row completely from sheet1 to summary I can get that to work but I am only pulling the values from the cells indicated
each time the macro is run.


Here is what I recorded below in the code tags which might give some insight where I am trying to place the values.

Please Login or Register  to view this content.

Any help at all would be appreciated.

All the best,
Lew

This would be the summary sheet
summary.jpg

This would be the summary sheet
summaryEXPLAINED.jpg

This would be the summary sheet
summaryEXPLAINED.jpg

sorry cannot seem to delete the duplicated post. I apologize in advance and am trying to figure out how to do that,

Maybe:

Please Login or Register  to view this content.