Extracting all the data from multi spread sheets

[go2review]

I have 84 spread sheets and i want to extract all the information without opening each one and pasting into a master spread sheet

[broro183]

hi,

Have a look at Ron's code examples: http://www.rondebruin.nl/copy3.htm

If you need any more guidance can you please post more details eg:
- are all files in the same folder?
- are they the only files in the folder?
- are the files named with a standard convention?
- is there only a single sheet in each file?
- What's the sheet called in each file?
...

Also, try searching this forum for "merge workbooks" which brings up a few threads including:
http://www.excelforum.com/excel-gene...ks-to-one.html
(I don't think this is exactly what you want - based on my interpretation of your first post)

hth
Rob