Filling out into fields

[GhostofWanted]

Hello,

I'm stuck and no clue how to fix it
hope someone can helpme out

i like to get from sheet3 the column 3 to fill into sheet PriceCards
but i don't get them all the correct fields into sheet PriceCards
i need to get them beside eachother and not under it

R = 2 ' the start row in the worksheet
Do While Len(Sheets("Sheet3").Range("A" & R).Formula) > 0
Sheets("PriceCards").Range("A" & R + 1).Value = Sheets("Sheet3").Range("C" & R).Value
R = R + 1 ' next row
countimages = R
Loop

i added a demo book

Thank you all

 

[vletm]

GhostofWanted
What are Your 'the correct fields into sheet PriceCards'?
You should give sample results based Your sample data.

 

[GhostofWanted]

GhostofWanted
What are Your 'the correct fields into sheet PriceCards'?
You should give sample results based Your sample data.

Hello,

Well as you see in the sample file
i get the results in 1 column in sheet pricecards and thats A
but what i need is to get the data from sheet3 in A C E G and under it
i hope you understand it a littel what my point is.

 

[vletm]

GhostofWanted
If You do not know Your 'the correct fields into sheet PriceCards' nor
You cannot give sample results
then You skipped my try to help You.

 

[GhostofWanted]

Not sure if i understand you 100%

but the sheet PriceCards fields are A C E G because they are merged fields
so i get in PriceCards in column A3 Till A8 the values from sheet3 column C

PriceCards values are

A3 100,05

A4 65,01

A5 65,01

A6 65,01

A7 65,01

A8 65,01

but i like to get it like

A3 100,05 C3 65,01 E3 65,01 G3 65,01

A4 65,01 C4 65,01

I hope it make any sense now.

 

[vletm]

GhostofWanted
Your original was: i like to get from sheet3 the column 3 to fill into sheet PriceCards
Your previous ... something else.
Next time, You should also show in Excel-sheet Your expected results based You sample data.

 

[GhostofWanted]

GhostofWanted
Your original was: i like to get from sheet3 the column 3 to fill into sheet PriceCards
Your previous ... something else.
Next time, You should also show in Excel-sheet Your expected results based You sample data.

Hello,

Okay, i will try to keep that in mind.
Do you have an solution for me to get that result? please.
Thank you

 

[vletm]

GhostofWanted
Did You open that my attached file?
Did You selected 'PriceCards'-sheet?
Do it look something that You have tried to get?

 

[GhostofWanted]

Hello,

Yes i open your file, thank you
and yes that's what i like to receive.