Hello everyone,
I have a project I'm currently stuck on and it goes like this:
Database in Sheet 2 containing Location & Item columns (A & B)
Sheet 1 contains a Searchbox I've made using vlookup & filter functions and this is fine.
Next to it, I want to add a location change function as items can have their location changed quite often.
Instead of going through all 1k lines of location and changing the item manually, I'm trying to automate this action using a script.
In Sheet 1, user inputs the location where a new item will be added, the said item, and hopefully, a script assigned to the icon will overwrite the new item on the specified location in Sheet 2.
I have some basic excel knowledge however macros & scripts are clearly not my forte.
I am searching for solutions but any hint, insight & such would be much appreciated. Hope I've explained it clearly.