Forum Discussion
Dale-Smith
Dec 27, 2022Copper Contributor
Autofill from a changing list
Hi, Very new to more than basic excel. I've got a fixed table on the master sheet that I would like certain cells to autofill data from another sheet where I am copy pastying a basic table to. ...
XXplore
Dec 28, 2022Brass Contributor
If in your 2nd sheet columns remains same order, "vlookup" "xlookup" can meet your needs
If column order changes but remains same name, "match" and "offset" helps.
Adding new rows should not impact anything in your formular when you refer to columns.
If column order changes but remains same name, "match" and "offset" helps.
Adding new rows should not impact anything in your formular when you refer to columns.