Firstly, see the image http://i39.tinypic.com/scz5eu.jpg
What I was tasked to do (Why an IT Technician had been delegated a tedious data entry job, I do not know!) is to merge a ton of information from an Excel spreadsheet into an existing database. This is now done, but I need to add to that data.
Looking at the image, the large rectangle shows what I need, basically:
‘Cal_Ref’ – I need to enter the number ‘1’ in that field for the rest of the records
‘Cert_No’ – I need to enter the text ‘nocert’ in that field for the rest of the records
‘Cust_Ref’ – Now this I need to copy from the field (on the right) and paste it in there – If you notice, where It’s being copied from and where it’s being pasted to are different tables.
Is there any Macro or VB code that could help me with this?
There are about 8400 records…. so you can see why I’m trying to automate this.