Hi all,
I am sorry if this is a repeated thread but i couldn't find an answer for the same.
i want to update values fon an excel sheet on a month by month basis.
So i have jan to dec folders and excel sheets under each folder , i want to update my monthly forecast sheet based on the numbers in the folder
I want to just change the cell in my monthly forecast sheet to Jan or Feb and the values should be pulled from the closed excel files in the monthly folders.
I tried concatenation but it gave me #REF .. Is there a way to do it other than using "pull" ??

Thanks