ladyredbull115
New Member
- Joined
- Nov 29, 2016
- Messages
- 9
I have a massive Access DB that I run several queries out of and paste into an Excel summary page for sharing daily. I am looking into automating it a bit further because my data can be very volatile...for example yesterday, I had a query that returned the following data:
uploading images
but today the query doesn't have any information for Pilot and Unknown, or Wave 7 and 4.0.439, etc.
image upload no size limit
Copying and pasting is too cumbersome as I have about 15 tables that I update daily and often make errors in getting the right information in the right place.
What I would like to do is paste the raw query data from the second photo into a new sheet and create a formula for column c in the first image that automatically pulls the data into it from the new sheet based on the Wave and Version number.
I have tried a few different things, including a substitute, replace, and vlookup but can't figure out what's wrong with the formulas. Any help is appreciated, thanks in advance.
![](/board/proxy.php?image=https%3A%2F%2Fs12.postimg.org%2F43jlhxg25%2Fyesterday.png&hash=4193a8b66541525257a4b2d03b737eaa)
but today the query doesn't have any information for Pilot and Unknown, or Wave 7 and 4.0.439, etc.
![](/board/proxy.php?image=https%3A%2F%2Fs13.postimg.org%2Fowg64pns7%2Ftoday2.png&hash=1df9eb031ece5a08bbf11f633ca437d3)
Copying and pasting is too cumbersome as I have about 15 tables that I update daily and often make errors in getting the right information in the right place.
What I would like to do is paste the raw query data from the second photo into a new sheet and create a formula for column c in the first image that automatically pulls the data into it from the new sheet based on the Wave and Version number.
I have tried a few different things, including a substitute, replace, and vlookup but can't figure out what's wrong with the formulas. Any help is appreciated, thanks in advance.