I have tried working my way through your first example but get to the append stage which seems okay but not sure how to group the table by product. ...
Hi Riny, Ive had a look but not sure how the second method is going to work. I have attached a diagram to try and explain but i'll see if this expl...
I cant access the query as it is asking for credentials to download but I can see the steps that you have taken. I'll see if I can recreate fr...
Hi Riny, I need the MillsListing.xlsx to be updated with the data from the csv listing so that it retains the previous items that may now not be in...
I can work out how to get the csv listing, add a column to add todays date and then change the headings, but then the next step you have which is elec...
Hi Riny, Hopefully attached ar the files. The excel list is the table with the current list of items in and the csv file is the new list which is g...
Hi Riny, I managed to get the data from the csv which is the new price listing which in your exmple is new and have added a column with todays date...
Hi Riny, I am so sorry but I have only just seen your reply, a year late but still trying to sort this. Yes I see how it works but have no ide...