VBA Loop - Copy and Paste Individual Cells

[stansmith216]

Hello,

I have a giant file that I am trying to use VBA to quickly work through.

In column D, there are ~4500 unique identifiers. Somehow, i need to copy and paste those 4500 identifiers in the cell B1, individually.

(Essentially I am trying to find a way to copy cell "D5" paste it in cell "B1" then to "D6" and paste back into "B1" and so on...)

Any idea how to code this on VBA?

[YasserKhalil]

Hello
Not so clear. Can you upload sample workbook to clarify what are you seeking to do?

[stansmith216]

Hi Yasser,



Essentially this is the file:

A B C D
1 ID Code:

2 ABC123

3 DEF234


I am not sure if this makes sense, but i am trying to move "ABC123" (D2) to cell B1. Then put "DEF234" (D3) in cell B1, essentially overriding what i just pasted in B1.

Does that make sense?

[KOKOSEK]

So what for pasting any value into B1 (from D2), when later on you want to overwrite B1 value it with value from D3?
Do you want to do something meantime with B1 value? In other way step by step does not make sense.

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

finally gives the same result.

Or I've missed something......

[stansmith216]

is there a way to pause after pasting in cell B1?

[KOKOSEK]

As I was asking in prev. post:
Do you want to do something meantime with B1 value?
What for You need a pause?

[Fluff13]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Read this to understand why we (and other sites like us) consider this to be important.

As you are new I have added the link for you, but in future you need to do it yourself.
https://www.mrexcel.com/forum/excel-...-vba-loop.html