Get data for 1 spreadsheet from another spreadsheet automatically in Excel 97?
But there’s a hitch – The info on spreadsheet B is not always inside same spot (always while in the same column but not similar line) Case:Spreadsheet B (Source with data) THE B C D E Shiny 1000 2000 3000 Red Dave FOUR THOUSAND 5000 6000 Blue Mark 7000 8000 …