11-23-2020, 12:03 AM
(This post was last modified: 11-23-2020, 12:04 AM by HawkingsHalfpint.)
FWIW, the internet is no use. Otherwise wouldn’t be posting here.
Used to use an add-in called MoreFunc which isn’t supported in 64-bit, sadly. The argument was called INDIRECT.EXT. Maybe if I’d inserted the terms Brexit, SJ or Slav’s Future, it would have been a better argument. Sigh.
Thanks Mike. VLOOKUP is handy, but not what I need here.
Used to use an add-in called MoreFunc which isn’t supported in 64-bit, sadly. The argument was called INDIRECT.EXT. Maybe if I’d inserted the terms Brexit, SJ or Slav’s Future, it would have been a better argument. Sigh.
(11-23-2020, 12:01 AM)baggiemike Wrote:(11-22-2020, 10:50 PM)HawkingsHalfpint Wrote: Any on here? Trying to get a spreadsheet to call in a load of data from another one. Easy enough, but not when you have to change the referenced workbook for a few hundred others. Oh and to me, and Macros are something where you don't have to pay VAT.
Tried turning back off and on again already. That made it go away for a bit, but that's all.
Try "VLOOKUP" it will take data from sheets and applies it
into other sheets depending upon the parameters you set.
Lots of info on Google and You Tube
Hope this helps
Thanks Mike. VLOOKUP is handy, but not what I need here.

