Auto Xfer Specific Data to a New Wkst
Closed
LSL18
Posts
2
Registration date
Thursday January 31, 2019
Status
Member
Last seen
January 31, 2019
-
Jan 31, 2019 at 12:36 PM
Blocked Profile - Jan 31, 2019 at 01:54 PM
Blocked Profile - Jan 31, 2019 at 01:54 PM
Related:
- Auto Xfer Specific Data to a New Wkst
- Grand theft auto v free download no verification for pc - Download - Action and adventure
- How to stop facebook auto refresh - Guide
- Grand theft auto iv download apk for pc - Download - Action and adventure
- How to find specific words on a page - Guide
- Auto redial samsung - Guide
1 response
How are ypu qualifying the top opportunties?
Do you have any Access experience? If not then you are at the same knowledge level as with the excel program, except Access is for maintaining records in a scaleable solution! Where excel is for calaculating complex math problems. Let us know if you need help with table structures.
If you insist on using excel, then I encourage you to record a macro of what you want to happen, then edit it with values that are variables. If you need help with that, post your maceo jere for review.
Do you have any Access experience? If not then you are at the same knowledge level as with the excel program, except Access is for maintaining records in a scaleable solution! Where excel is for calaculating complex math problems. Let us know if you need help with table structures.
If you insist on using excel, then I encourage you to record a macro of what you want to happen, then edit it with values that are variables. If you need help with that, post your maceo jere for review.
Jan 31, 2019 at 01:00 PM
Initially I hoped to achieve this by way of a simple VLOOKUP, and its doable, but there's still elements of manual work in having to check/re-check the data and outcome with every refresh and frankly was hoping to spend the time now on building a tool that I'd never have to touch again, allowing those who needed the info simply to refresh the data (which is built off of a dynamic existing connection).
I have some Access experience, literally a graduate class a few moons ago but no relevant use of that knowledge since...
I'm thinking what I have is as good as its going to get.
Appreciate the swift response.
L
Jan 31, 2019 at 01:54 PM
It would seem to me that data entry, then reporting on the data through modified queries would be the best solution for a stable model. It would eleinate the possibilty of deleting formulas or some sort of disastor when moving the cells. Let us know what you think about that model.