Happy to help Just out of curiosity where is the data from the reports coming from. You cud automate the whole process straight into access I bet Richard wud advise do it all in access but if that's not possible you cud transfer from different sheets to a table I had to do something similar at work as not everyone had an access license. Alex
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Excel Forum.