Kate has attended:
Access Introduction course
Access Intermediate course
VB project
Hi,
I'm running a macro which copies data into a spreasheet then uploads this data to access (refresh all) which then links back to other tables in the document.
The results of one of the tables are then copied across to a separate worksheet and these values are used within Sumifs.
Despite putting the copying at the end of all the procedures it still does this first, therefore copying the old table across.
How would you recommend avoiding this problem?
Thanks,
Kate
RE: VB project
Hello Kate
Thanks for your post and detail around the issues you are having with your spreadsheets and Access.
In these instances we will really need to look at your working files to establish if there is a solution. Any identified solution is beyond the scope of this forum and we will produce a scope of work with objectives, durations and related costs.
I shall email you directly should you wish to take this further.
Kind regards
Jacob
