Hi there!
I'm hoping someone can help me here.
We have many issues with an Access database we've been using for years and are unable to do many edits/updates because no one has the user name or password so we are trying to make due with what we have until I have time to build a new one.
In the meantime...
The database holds the following information:
Data related to orders that are shipped out from our warehouse.
I pull the data from the database into an Excel spreadsheet so I can filter it, sort it, and use it to create pilot tables. I was able to add a column to my spreadsheet that is linked to the database that is a formula to find the difference between two cells so that if someone has entered a weight differently from the original weight it will be a flag for me to follow up. This new column works fine and is not erased each time I update the spreadsheet to get any new entries.
I tried added another column that so that I can add a unique number that is associated with each order. An order number can be repeated multiple times because sometimes things are out of stock and when the item is ready it is still associated with that original order number. A delivery number, however, is generated by SAP and is unique. So one order could have many delivery numbers but only one order number.
Now...to my problem...I was able to add the column with the formula but I can't add a new column and manually add the delivery number. Each time I do that information is overwritten to blank when I update the spreadsheet with whatever new data the sales staff have added.
TLDR:
How do I add a column to a spreadsheet linked to an Access database that allows manually entry that won't overwrite each time I update the data?
Thanks,
Lisa
Bookmarks