Forum Discussion
Imported data not aligning with manually entered data in table
I would like a table with 2 manually entered data columns and 1 imported data column as shown: The imported data (just a single column table of data with the stock items) is the middle column:...
Thank you, I did see you personally reccomend this to someone in my searches.
I read it, tried to do it, but you can't add data after you have created the connection as it kept wiping any new data I entered when you refresh.
This would work if I didn't need to keep adding data.
I read it, tried to do it, but you can't add data after you have created the connection as it kept wiping any new data I entered when you refresh.
This would work if I didn't need to keep adding data.
That's exactly the same method as Riny_van_Eekelen demoed in his sample, all shall work if you build the query correctly.
- Hello,
I completed all steps in the link. I have just done it again a 2nd time.
If i was to sort the items, yes they do stay together.
HOWEVER, when i add a new stock item to the source data and refresh my connections,
The data will no longer be aligned where it is meant to. This is why I couldn't continue with this method the first time.
I promise I did every step twice now, exactly as listed. It does not work when adding new items to the source data.