View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default importing specific cells from multiple workbooks into 1 workbo

Anyone ever tell you that YOU ARE THE MAN

I hope my wife will say this tonight <g


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Walter Davis" wrote in message ...
Anyone ever tell you that YOU ARE THE MAN!? Thanks. You just saved a whole
days work...

"Ron de Bruin" wrote:

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Walter Davis" <Walter wrote in message
...
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?