Hi,
Hope you can help. I am looking for a simple VBA code to look in column A and when there is only a number to combine it with column B then shift the contents back to column A. If there is a number and text in column A then skip until only a number is found.
So in the attached file the first 3 columns are the test data and the columns E to G are how I want it to look after.
Thanks in advance
VBA? This could be done easily with a formula too. Shall I move this to the VBA sub-forum. BtW... is Bishop's Stortford a mistake?
Its move from one column to another.... that is, not the town itself. I'm sure it's delightful.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Give this a try
Please Login or Register to view this content.
Yes, its addition to a longer VBA. If it's in the wrong forum then yes please if you can move it.
That worked perfectly, thank you so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks