Hi I have a little issue that I can not seem to work around I am no good in vb but can record macros do lookups etc.
Oh and i think this forum is great btw.

I am looking to record a macro that copys a cells data for example a1 which has a unique identifier an example would be 812345612. Looksup the unique identifier on another sheet/workbook then change column b to match the first sheets column b. Then copys the whole row to another sheet insets a row at the top then goes back to the original sheet and deletes the row and starts again.