Parts Catalog Accessories Catalog How To Articles Tech Forums
Call Pelican Parts at 888-280-7799
Shopping Cart Cart | Project List | Order Status | Help




Go Back   PeachParts Mercedes-Benz Forum > General Discussions > Off-Topic Discussion

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 12-02-2005, 04:18 PM
MedMech
Guest
 
Posts: n/a
Excel gurus may I axe you something.

I have a but load of separate spreadsheets that I would like in one spreadsheet in separate tabs. Is is possible to migrate them into one workbook but separate tabs?
Reply With Quote
  #2  
Old 12-02-2005, 04:29 PM
Chris Bell's Avatar
Registered User
 
Join Date: Oct 2003
Location: Santa Clara, CA.
Posts: 747
Open the excel file that has the spreadsheets that you want to migrate.
Open the file that you want to migrate the files to.
In the excel file that you want to migrate the files to..click on insert, click on worksheet. this wil create new worksheets (tabs as you call them)
Insert as many new worksheets (tabs)as you need.
Cut and Paste the old tabs into the new worksheets you just created.
If you want to get fancy you can right click on the individual tabs at the bottom and rename them and give each tab its individual color.

Now...does anybody out there know anyhting about macros
__________________
I'm sick of .sig files
Reply With Quote
  #3  
Old 12-02-2005, 04:51 PM
LaughingGravy's Avatar
Mmm.... Diesel.
 
Join Date: Oct 2003
Location: N. NJ
Posts: 434
Make sure the file you want to copy or transfer the sheets from is open as well as the intended destination. The intended destination Excel workbook should also already have it's own name, and not be just a new unnamed workbook.

Right click the sheet tab name that you want to move. You'll see an option to move...
Be sure whether you want a copy to the other named file or a move,deleting the sheet from its origin, before you complete the task.
Also, remember you can't have sheets with the same namein the same workbook. If you have macros that depend on formulas or values on other sheet tabs, depending on what you're doing, you may need to rename some sheet tabs, or edit the macros.

And while you're at it with the axe, chop me down a nice Christmas tree, OK?
Have fun.
__________________
'83 300TD, 234K with Euros and antique plates. No inspection, No registration fees, Cheap insurance
"If my calculations are correct, when this baby hits 88 miles per hour, you're going to see some serious %$&^."
Reply With Quote
  #4  
Old 12-02-2005, 05:24 PM
H2O2's Avatar
Empty Vessel
 
Join Date: Jan 2005
Location: Ladeluftkühlerstadt
Posts: 1,429
RED ALERT: Hijack in progress!


Does anyone know of a good source that explains how to work with pivot tables in Excel?

TIA
Reply With Quote
  #5  
Old 12-02-2005, 07:28 PM
MedMech
Guest
 
Posts: n/a
Thanks guys I managed by opening the multiple windows and dragging the sheets I wanted to the other windows.

The part that bugs me is why do people need pictures and fancy presentations to "get it".

I from the school of stuff written on a sticky note pad and they take my word for it.

and the meetings to schedule meetings what a concept.

nice to see you Z. Did you see my new P-Book post? Whatta deal eh?
Reply With Quote
  #6  
Old 12-02-2005, 07:29 PM
MedMech
Guest
 
Posts: n/a
Quote:
Originally Posted by H2O2

Does anyone know of a good source that explains how to work with pivot tables in Excel?

TIA

Please hijack thats what threads are for
Reply With Quote
  #7  
Old 12-02-2005, 07:30 PM
MedMech
Guest
 
Posts: n/a
http://www.mrexcel.com/archive/Pivot/
Reply With Quote
  #8  
Old 12-02-2005, 09:13 PM
H2O2's Avatar
Empty Vessel
 
Join Date: Jan 2005
Location: Ladeluftkühlerstadt
Posts: 1,429
Hey thanks, that link has tons of info. Yet another bookmark.
Reply With Quote
  #9  
Old 12-02-2005, 09:21 PM
MedMech
Guest
 
Posts: n/a
Quote:
Originally Posted by H2O2
Hey thanks, that link has tons of info. Yet another bookmark.
No problem, excel is a blast isn't it? Too be honest its sort of becoming a new hobby.
Reply With Quote
  #10  
Old 12-02-2005, 09:24 PM
MedMech
Guest
 
Posts: n/a
check this one out ......Neoofficej
Reply With Quote
  #11  
Old 12-02-2005, 10:48 PM
iwrock's Avatar
roflmonster
 
Join Date: Nov 2003
Location: Hella NorCal
Posts: 3,312
Yes, those meeting to schedule meeting are a hoot.

I tried that whole write down a memo thing, and I started losing my mind, as I couldn't identify the location of the memo's. Its cool though. I have resorted to the old stand by. I have my palm pilot with my schedule in it, so I will always know what to do and when to do it.
__________________
-Justin

01 Honda S2000 - dogs dd
07 MB ML320 CDI - dd
16 Lexus IS250 - wifes dd

it's automatic.
Reply With Quote
  #12  
Old 12-02-2005, 10:54 PM
MedMech
Guest
 
Posts: n/a
Quote:
Originally Posted by justinwrock
Yes, those meeting to schedule meeting are a hoot.

I tried that whole write down a memo thing, and I started losing my mind, as I couldn't identify the location of the memo's. Its cool though. I have resorted to the old stand by. I have my palm pilot with my schedule in it, so I will always know what to do and when to do it.
I use my Treo and MS Entourage, as much as I hate winders the MS office stuff is awesome. I guess a new office for Mac is coming out soon, with Access.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On




All times are GMT -4. The time now is 05:24 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Search Engine Optimization by vBSEO 3.6.0
Copyright 2018 Pelican Parts, LLC - Posts may be archived for display on the Peach Parts or Pelican Parts Website -    DMCA Registered Agent Contact Page