Summary Report from multiple files to one file.

**Linraen7** · 12-19-2012, 03:40 AM

Hiya...

Being a beginner with excel, I am no fan of VBA coz I can hardly get there.... hence I try to use simple formulas that I get from the F1 and link my files.

I have multiple sheets where I created a dashboard on the first sheet and the sheets reflects the count from the multiple sheets in the same workbook as per my requirement. It is as simple as ='Sheet4'!J3.

Now what I have done is made a New File "Dashboards" and renamed the sheets to the file name from which I want the data.

Simply added VLOOKUP and I got the data... as easy as that. (know it was a longer way though) but it still worked as I wanted.

Now all of sudden VLOOKUP is not responding!!! not sure why?? I'll have to redo all the formula's

All these files & the Dashboard file is on the domain server and used by my colleagues as well hence they are shared ... is that the reason the Vlookup was working yesterday & today it just stopped ...

I have heard that there are ways to merge excel data from several files to one without the VBA.. is that true?

Can any one suggest how do I get this result achieved and if VBA is the only thing than can anyone please guide how to do it.

Any help will be appreciated.
Lin

**dilipandey** · 12-21-2012, 03:34 AM

Hi Lin,

If VLOOKUP stopped working.. can you check the links (Alt + E + L) if they are still valid ? or did you change formula calculation to manual ? or I hope you are not on formula view mode (ctrl + ~)

As per my knowledge, you cannot merge several files without VBA.

Regards,
DILIPandey
<click on below * if this helps>

**Linraen7** · 12-26-2012, 07:56 AM

@dilipandey

Thank you for your suggestions I'd keep that in mind.

I rather now followed a simple solution of creating dashboard on each file and merging the dashboard in one sheet by RDB Merge. It gave me the desired results without having to use the VBA but it lacks formatting as I have to use the option to "paste as values" since my file has formulas in it. I guess I can do without the formatting until I can see the results I want

Thanks for your guidance.
Lin