excel lookup folders

  1. H

    Excel vlookup with variable information

    Helloooo, Is there a way please to lookup information from other spreadsheets based on variable information? This is quite hard to explain so I’m just going to list out what I have below and hope that someone can make sense of what I am trying to ask! So this is a little mock up of my scenario...
  2. G

    Get Files Macro Need more

    Hi i've got this Marco/Function Sub get_files() Extension = "*.CSV" Folder = "C:\Documents and Settings\User\My Documents First = True RowCount = 1 Do If First = True Then FName = Dir(Folder & "\" & Extension) First = False Else FName = Dir() End If If FName <> "" Then Range("A" & RowCount) =...

Some videos you may like

This Week's Hot Topics