Not sure if this is even possible, but would anyone know if theres a way of using app script to move cell data to a specified area. Sort of a reverse Vlookup? I want it to send a cell's data to an area that matched the cell's title, in a similar way to how Vlookup will pull data from a cell that matches the title... But in reverse.
Thanks for any help you guys could give :)
Update: Below is a link to a practice cell with no script https://docs.google.com/spreadsheets/d/1ie8k6a9gcOg06tVVc1bCFhandIH7vy2LUgk2_vusOAc/edit?usp=sharing
The idea is that The cell containing £300 (D7) would be directed to B7 through the titles of their cells (both being 02/01/22)