Hi Andy
Just for future reference, the terminology is that you have 30 WORKBOOKSs,
each of which contains only 1 sheet, which you want to combine into 1
WORKBOOK with 30 WORKSHEETS.
If this is a one off task, I think I would just do it manually.
Choose one of the workbooks to be your final Workbook which will have the 30
sheets.
Next, open each other workbook in turn
Right click on the tab of the sheet with Data>Move or Copy>select
Copy>Choose the Name of your final Workbook>Insert at End>OK
Close that workbook
You will probably end up with the final workbook having sheets called
Sheet1, Sheet1 (2), Sheet1 (3) etc.
Right click on the tabs>Rename>Choose a suitable name
If you want to do it programmatically, take a look at Ron de Bruin's code
for doing this.
http://msdn.microsoft.com/en-us/library/cc837974.aspx
--
Regards
Roger Govier
"AndyN" <(E-Mail Removed)> wrote in message
news:AD2A307B-B9CC-4759-963D-(E-Mail Removed)...
> Hi
>
> Hopefully someone can help me with a query. I have around 30 spreadsheets,
> each of which has only 1 sheet. I would like to combine them to produce 1
> spreadsheet with 30 sheets.
>
> These are all audit questions, so whilst they do look similar the question
> sets do vary as do the number of questions within each spreadsheet.
>
> I'm not trying to combine data or anything like that, just produce a
> single
> document. For ease of usage.
>
>
> Thanks in advance, any pointers gratefully received.
>
>
> Andy
>
>
> __________ Information from ESET Smart Security, version of virus
> signature database 4751 (20100107) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>
__________ Information from ESET Smart Security, version of virus signature database 4751 (20100107) __________
The message was checked by ESET Smart Security.
http://www.eset.com
Similar Threads
