This is a weird question probably. I have a simple table of columns. The data changes daily of course thus I use PowerQuery to keep other tabs updated based on criteria and this all works fine.
However, one column in the data is a blank column that on each connection that column is for notes for the user to type in. However, when refreshing the data from the main tab which has blanks int he column it will overwrite any written notes they had put in. Is there a way to keep the existing data in a specific column?
Wow this was harder to explain that I though. I used to do this in other ways, without using pivot tables but it was a mess, required vlookups and copying sheets and lots of macros - so I was trying to simplify this all using PowerQuery.
I attached a small sample file.
Basic premise:
Sheet one "Quotes" is the data set that the queries are created from, it changes daily. The "Notes" column J is always blank here.
There are two other sheets which are just Queries to the main table and pull in the data, but the "Notes" Column J on those tabs the user would be typing in data, and that data should REMAIN when refreshing the data.
I am sure there is some simple way to do this, thanks in advance
Sorry that my explanation is pretty awful haha.
(For reference, the only solution I came up with might be to have a separate table that is all the notes from each of my sheets, and then using VLOOKUP on each sheet for the Quote Number on the Notes table, this will work just wanted to make sure there wasn't a better way)
Bookmarks