Microsoft Office Questions? Ask a IT Expert for Support ASAP
Hello Richard, thank you for offering to help :)
The files themsleves are numerous and very large (just short of 5000 rows each), so I've extracted a small sample from one of them and uploaded for you.
The file ID is 460438.
I need the macro to analyse column H, and insert a blank cell (in column H, moving all data to the right) for only rows that contain "Co Code".
Hello Richard, sorry for the delay. Time differences between US and Aus quite substantial.
I tried DLing 226478 from home last night but I'm on a Mac at home and it doesn't like VBA, so I emailed the worksheet to work. I've just tried opening it on my work machine but I can't find your macro Checkcode? I've tried re-downloading from the office but I get a zip file, once extraced it's just full of xl templates & formatting files, no sign of a worksheet anywhere - probably my lack of any sort of IT expertise sorry.
Can you just copy and paste the macro code for me please? I can find my way around Alt-F11 and Alt-F8 to import it as a module.