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
kayuf Posts 3 Registration date Thursday June 25, 2015 Status Member Last seen June 30, 2015 - Jun 30, 2015 at 04:52 AM
Related:
- Macro for filling data from specific cell to another
- Transfer data from one excel worksheet to another automatically - Guide
- Tmobile data check - Guide
- Spell number in excel without macro - Guide
- How to reset safe folder password without losing data ✓ - Android Forum
- Count if cell contains number - Excel Forum
3 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Jun 25, 2015 at 11:26 AM
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
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
kayuf
Posts
3
Registration date
Thursday June 25, 2015
Status
Member
Last seen
June 30, 2015
Jun 28, 2015 at 01:05 AM
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
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
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Jun 29, 2015 at 11:02 AM
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
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
kayuf
Posts
3
Registration date
Thursday June 25, 2015
Status
Member
Last seen
June 30, 2015
Jun 30, 2015 at 04:52 AM
Jun 30, 2015 at 04:52 AM
Thanks a lot Trowa ,that was really helpfull
