Hi, I'll be happy to help - macros would be one way of doing this but would it be possible to see the current files etc and work out the best solution?
can you mail them to [email protected]
ok great, I'll do that. I did not see a way to attach them on here
e-mail is usually the best way
ok just sent them.
great - will check them when received and come back to you
Have received files now and reviewing
Am I correct in assuming the highlighted information is what needs to be collated into Excel?
Yes, the highlighted data are the fields that are continually changing for each item and we would like the highlighted data that is inputted to automatically populate into the certification report and the listing template.
thanks - will see what the possible solutions are
Apologies for the delay but having reviewed the documents and tried a few things it looks to me like the best option would be an Access database for the information as this would allow collation of the necessary fields and information and give good options to integrate with Word as well as reporting. An Access form could be created for data entry purposes as well
I can create a quick mock up based on the sample data if that would help and send it through later today?
Let me know