Hi,
I wondering if it is possible for a macro to recognise whether or not there is text in an adjacent cell, and if there is, then to copy data from another adjacent cell.
For example, because there is data in C2, data from A2 has been inputted into B2. And any blank cells are left alone.
a b c d e ref1 (cell A2 data here) DATA DATA DATA ref1
Any ideas/help would be very much appreciated.
Last edited by BPSJACK; 07-15-2014 at 06:04 AM.
Try this code...
It only covers 100 cells.. you can adjust it...
Don't forget to click *
Please Login or Register to view this content.
That works great, however is it possible to tweak the code so the macro only looks for populated cells to the right of cells in column B only.
For example; the code above will populate B2 because there is data in A2. But I'd like to populate B2 only if there is data in C2. If C2 is empty I would want B2 to remain empty also.
Is there a way to achieve this?
Dear BPSJACK,
Try below
Please Login or Register to view this content.
Regards,
Nandkumar S.
---------------------------------------------------------------
Don't forget to Click on * if you like my solution.
Fantastic, works like a charm. Thank you!
You're welcome. Glad to help you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks