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...
Hi i've got this Marco/Function
Extension = "*.CSV"
Folder = "C:\Documents and Settings\User\My Documents
First = True
RowCount = 1
If First = True Then
FName = Dir(Folder & "\" & Extension)
First = False
FName = Dir()
If FName <> "" Then
Range("A" & RowCount) =...