Macro for filling data from specific cell to another

Solved/Closed
kayuf
Posts
3
Registration date
Thursday June 25, 2015
Status
Member
Last seen
June 30, 2015
- Jun 25, 2015 at 09:44 AM
kayuf
Posts
3
Registration date
Thursday June 25, 2015
Status
Member
Last seen
June 30, 2015
- Jun 30, 2015 at 04:52 AM
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

TrowaD
Posts
2888
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
August 16, 2022
515
Jun 25, 2015 at 11:26 AM
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
0
kayuf
Posts
3
Registration date
Thursday June 25, 2015
Status
Member
Last seen
June 30, 2015

Jun 28, 2015 at 01:05 AM
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
0
TrowaD
Posts
2888
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
August 16, 2022
515
Jun 29, 2015 at 11:02 AM
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
0
kayuf
Posts
3
Registration date
Thursday June 25, 2015
Status
Member
Last seen
June 30, 2015

Jun 30, 2015 at 04:52 AM
Thanks a lot Trowa ,that was really helpfull
0