Forum Discussion
need help using header reference to pull data from worksheet
Hello everyone, thanks to those who take a moment to read this. I might be overthinking but I'm trying to setup a Master Inventory style sheet. Using date format as yyyymmdd or 20231125 if in...
Rob__James I would use power query to automate that process. I was able to generate the table below.