Hello,
I am somewhat new to this, but have a task for my business that im hoping someone may know how to do. I am looking to have a master spreadsheet automatically pull 3 columns from any spreadsheet saved into the sharepoint folder. So the master spreadsheet would have All of the spreasheet files names down the left side column and the 3 fields pulled to columns B,C, and D to the right. (Column A would be the file name). By chance can someone help me with this?
Thank you!
Shayne