importing specific cells from multiple workbooks into 1 workbook

[Walter Davis]

I need to compile data from 6 cells in the 2nd tab in over 300 workbooks that
are in the same folder into 1 spreadsheet in a separate workbook.I want to
insert a new row for the data from every workbook. All of the workbooks have
the exact same format. Anyone know the easiest way to get this info compiled?

 

[Ron de Bruin]

Hi Water

Try the add-in or the code on this page
http://www.rondebruin.nl/merge.htm

http://www.rondebruin.nl/copy3.htm

If you want to create formula links see
http://www.rondebruin.nl/summary2.htm

 

[Walter Davis]

Anyone ever tell you that YOU ARE THE MAN!? Thanks. You just saved a whole
days work...

 

[Ron de Bruin]

Anyone ever tell you that YOU ARE THE MAN

I hope my wife will say this tonight <g>

 

[Dave Peterson]

I just hope you're the guy in the room with her!!!!!!

<gd&r>

 

[Ron de Bruin]

LOL