VBA Struggler
New Member
- Joined
- Apr 4, 2013
- Messages
- 2
This isin't brain surgery. I can read. I've spent DAYS trying to figure this out and I'm simply spinning my wheels.
Problem
Colum A <-------a buncha junk inbetween----->Column J
John John
Henry
Beth
Francie
Caroline
Bill
I am hopelessly trying to create a subroutine where John is replaced by Henry, then Beth, then Francie, etc. etc. BUT, it can ONLY be J1.
Whomever figures this bad boy out, can you please explain WHY you did whatever you did?
Thanks.
P.S. I actually work in an IT department and I'm too ashamed to ask for their help as none of the them know VBA!!! *sigh*
Thanks again, everyone.
Problem
Colum A <-------a buncha junk inbetween----->Column J
John John
Henry
Beth
Francie
Caroline
Bill
I am hopelessly trying to create a subroutine where John is replaced by Henry, then Beth, then Francie, etc. etc. BUT, it can ONLY be J1.
Whomever figures this bad boy out, can you please explain WHY you did whatever you did?
Thanks.
P.S. I actually work in an IT department and I'm too ashamed to ask for their help as none of the them know VBA!!! *sigh*
Thanks again, everyone.