Excel boffins
#6
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.

(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.
Reply


Messages In This Thread
Excel boffins - by HawkingsHalfpint - 11-22-2020, 10:50 PM
RE: Excel boffins - by MancBaggie - 11-22-2020, 10:53 PM
RE: Excel boffins - by Big Daddy Cool - 11-22-2020, 10:56 PM
RE: Excel boffins - by SausEggBaton - 11-22-2020, 11:32 PM
RE: Excel boffins - by baggiemike - 11-23-2020, 12:01 AM
RE: Excel boffins - by HawkingsHalfpint - 11-23-2020, 12:03 AM
RE: Excel boffins - by baggiemike - 11-23-2020, 12:21 AM
RE: Excel boffins - by HawkingsHalfpint - 11-23-2020, 12:37 AM
RE: Excel boffins - by Fulham Fallout - 11-23-2020, 02:40 AM
RE: Excel boffins - by HawkingsHalfpint - 11-23-2020, 06:46 AM
RE: Excel boffins - by Anung un Rama - 11-23-2020, 07:16 AM
RE: Excel boffins - by Fulham Fallout - 11-23-2020, 07:15 AM
RE: Excel boffins - by HawkingsHalfpint - 11-23-2020, 07:35 AM
RE: Excel boffins - by Fulham Fallout - 11-23-2020, 07:41 AM
RE: Excel boffins - by HawkingsHalfpint - 11-23-2020, 07:47 AM
RE: Excel boffins - by Fulham Fallout - 11-23-2020, 09:03 AM
RE: Excel boffins - by waffle - 11-23-2020, 10:18 AM
RE: Excel boffins - by HawkingsHalfpint - 11-23-2020, 02:22 PM
RE: Excel boffins - by hudds - 11-23-2020, 10:29 AM
RE: Excel boffins - by Fido - 11-23-2020, 10:47 AM
RE: Excel boffins - by Birdman1811 - 11-23-2020, 03:02 PM
RE: Excel boffins - by MassDebater - 11-23-2020, 04:17 PM

Forum Jump:


Users browsing this thread: