I have spreadsheet A with hidden columns, some columns with formulas etc.
I need to update the data in spreadsheet A with raw data from Spreadsheet B. Easy enough to copy and paste...but what I might have to do later is update A when the data from B is updated (let's call that C). and then again for D, E,F and so on.
wat I would love to do is simply download a new version of B and then A automatically updates. So link A to B and everytime B changes, A does as well.
I was able to get it to work but then I couldn't sort in A because I created an array I guess and sort didn't like that.
There has to be a semi easy way to do this right? I'm not an excel expert by any means.