I have been getting into all sort of problems using the record function and ive tried modifyin these to help but to no avail.
I have 2 workbooks with large amounts of data. I am basically taking an ID number from column B in wb1 then using Ctrl F in wb2 and after finding a match I am copying the data in Col H, AL, AR, BI and copying them into Col I, K, J, L of wb1 respectively.
I have like 1000 of these to do and I am sure a macro could help me do this faster.
That's good news because in that case it sounds to me like you can do this using formulas, thereby avoiding the more difficult VBA solution. Have you used VLOOKUP() or INDEX() and MATCH() before? I can attach an example if required...