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
Related:

3 responses

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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