Hi All,
New to here so hopefully i have added all the info needed if not then shout.
I currently use excel for a template calculator where i fill in values throughout the sheet and it returns a quote for me.
What i need to do is create a basic sheet that will lookup certain cell values in every file in a set folder.
So basically everytime i do a quote i save it as customer name then an ascending number eg customer 9-1233 next one is customer 9-1234.
Is a function possible where it will pull values from every file within a set folder then pluck out certain cell contents?
Any info would be appreciated.
Regards
Darren
Bookmarks