External data with manual entered data

  • Hi all,


    I have a spreadsheet which pulls data from Sage. There are two columns added on the spreadsheet which the user picks items, the and Department it is for.

    The issue I have is that if something gets added or removed from Sage and then the databases is updated, the quantity and department are no longer assigned to picked product row.

    Is there a way to keep these assigned to the selected row?


    e.g of what is looks like..



    Thanks guys

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!