Macro help required...

[K@rl]

Hi Guys

Looking for someone to help put an Excel Macro together.

I have a list of names and addresses in Excel. I need to feed this information into our printing software and the Postcode has to be in a specific column - unfortunately the data I was sent is all over the place.

I'm thinking that a Macro might be the best way forward. I'll be creating a new column after all the address columns - the macro needs to look to the left of the current cell working its way across and copy the first cell containing a value and copying it to the post code column.



Hope that makes sense.

Not sure what the rules are but I'd be happy to compensate someone for their time.

 

[K@rl]

Thanks guys. Will give it a try later on today, will let you know how I get on.

 

[K@rl]

A quick and simple VBA function to do this; in the Visual Basic editor add a new module a paste the code there.

Thanks for that - excuse my n00bness but I'm struggling to get it to work.

Getting this error when I paste the code in - probably just me being an idiot.



Is there a way that I can highlight the column required or set it as j:j? Sorry about the questions - my excel skills max out at making unuseful graphs

Cheers

 

[K@rl]

Thanks again for the continued help - think I'm losing the will to live!

Got the formulas set in the cells - just trying to work out how to run the code.