Macro for filling data from specific cell to another [Solved/Closed]

Report
Posts
3
Registration date
Thursday June 25, 2015
Status
Member
Last seen
June 30, 2015
-
Posts
3
Registration date
Thursday June 25, 2015
Status
Member
Last seen
June 30, 2015
-
Hi all,

i need help with creating macro to fill data from specific cells in column to another specific blank cells in other column.
screen shot is attached for this example.



thanks in advance,
kayuf

3 replies

Posts
2669
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 15, 2020
446
Hi kayuf,

Could you be a lot more specific. Is there supposed to be some kind of pattern or logic in the provided screenshot?

What are your actions and what do you want the macro to do?

Best regards,
Trowa
Posts
3
Registration date
Thursday June 25, 2015
Status
Member
Last seen
June 30, 2015

Hi Trowa,

what i want this macro to do is to take the specific cells that contain data from column B and Fill them in the Blank cells in column A and Vice Versa.
i want to do this in one rather than filling each cell manualy.
The data that i filled in cell as shown in the attached pic is just for example.
I hope that this was more understandable.




Thanks in advance,
Kayuf
Posts
2669
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 15, 2020
446
Hi Kayuf,

So if column A is empty and column B is not then move the data from B to A.
In your text you say "Vice Versa", but this doesn't show in your sample pic. So I'll start with what the pic shows.

An easy solution would be to:
Copy column B > select column A > Paste special > skip empty cells > OK.
Then delete column B.


Will this work for you?

Best regards,
Trowa
Posts
3
Registration date
Thursday June 25, 2015
Status
Member
Last seen
June 30, 2015

Thanks a lot Trowa ,that was really helpfull