GhostofWanted
New Member
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
i added a demo book
Thank you all
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
Code:
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