Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
combining spreadsheets
Name: jimnarron Date: June 3, 2004 at 11:34:06 Pacific OS: Win XP pro CPU/Ram: P4/512
Comment:
Is there an easy way to combine 60 excel sheets without copying and pasting? I have a bunch of spreadsheets that are alphabetical but the same number of columns etc. I want to combine it all into one spreadsheet without having to copy and paste.
Name: J A Dean Date: June 3, 2004 at 11:51:18 Pacific
Reply:
Hi
On the Tools menu, click Compare and Merge Workbooks (the workbooks to be merged need to be shared first (Tools>>Share Workbook)
HTH
In the land of the blind the one eyed man is king
0
Response Number 2
Name: jimnarron Date: June 3, 2004 at 11:58:16 Pacific
Reply:
I don't see that option on the tools menu. I'm using MS Office 2003.
0
Response Number 3
Name: Report_2 Date: June 3, 2004 at 14:03:10 Pacific
Reply:
I have Office 97 and find Tools, Merge Workbooks greyed out even with two workbooks open.
You might want to use the macro shown at this OzGrid thread. When I view the page I see that some of the code is overwritten with translated code by the browser. (I see smiley faces at the end of some lines of code that shouldn't be there) You may have to post to it in order to ask for the corrected code.
If you don't see any smiley faces then let me know so I will know that it is my problem and not the newly reformatted webpage.
Regards, Bryan
0
Response Number 4
Name: J A Dean Date: June 3, 2004 at 14:19:52 Pacific
Reply:
Bryco
For the option to not be greyed out the workbook has to be shared first.
HTH
In the land of the blind the one eyed man is king
0
Response Number 5
Name: Report_2 Date: June 4, 2004 at 02:24:33 Pacific
Reply:
J A Dean, Thank you. I figured there was a reason it was greyed out.
Jim, You say 60 spreadsheets...I do assume you are meaning 60 workbooks versus 60 sheets in a single workbook. Correct?
Summary: First, let's make sure we are talking about gridlines and not borders. Those are 2 very different things. I'll assume we are talking about gridlines and take a shot at this. re: In another attempt fr...
Summary: I have an access database with a linked table to and Excel spreadsheet. I have the problem that you can only access either the spreadsheet or the database form at any one time. Its used accross a netw...
Summary: Under Microsoft Office 2K I can't remember how to reorganize a spreadsheet. I know it's pretty straight forward, but my memory is slipping. I can alphabatize a single column, but I need that to affe...
0 
