Microsoft Office Forums How do I merge data from one sheet in a workbook out into multiple sheets

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-04-2010, 04:37 PM
nolesca nolesca is offline How do I merge data from one sheet in a workbook out into multiple sheets Windows XP How do I merge data from one sheet in a workbook out into multiple sheets Office 2007
Novice
How do I merge data from one sheet in a workbook out into multiple sheets
 
Join Date: Jun 2010
Posts: 5
nolesca is on a distinguished road
Default How do I merge data from one sheet in a workbook out into multiple sheets

I am using a workbook with data that changes monthly. I can easily create a spreadsheet that has my new monthly info in a list format on one sheet. My question is, can I somehow disseminate that information into the other 90 sheets.



For example, I would want the data in my first sheet A2 and B2 to go to certain cells in sheet 2. Then the data in A3 and B3 would go to designated cells in sheet 3, and so on for 90 different sheets?

Is this possible?

Thank you so much.
Reply With Quote
  #2  
Old 06-05-2010, 06:03 AM
Kimberly Kimberly is offline How do I merge data from one sheet in a workbook out into multiple sheets Windows 7 How do I merge data from one sheet in a workbook out into multiple sheets Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

90 sheets? Surely there is an easier to accomplish your ultimate goal. Perhaps if we knew the reason for the 90 sheets it would help.

Also, it is unclear from your question if you are asking how to create formulas or if you are asking how to avoid creating 90 formulas.
Reply With Quote
  #3  
Old 06-05-2010, 07:50 PM
nolesca nolesca is offline How do I merge data from one sheet in a workbook out into multiple sheets Windows XP How do I merge data from one sheet in a workbook out into multiple sheets Office 2007
Novice
How do I merge data from one sheet in a workbook out into multiple sheets
 
Join Date: Jun 2010
Posts: 5
nolesca is on a distinguished road
Default

Thanks for your reply. The reason for 90 separate sheets is that the workbook is a report consolidating monthly course evaluations. There is one sheet that gives an overview of each course by program. Then each course (the college I work at offers approx. 90 per month) requires its own sheet to provide more detailed data for that particular course. While 90 sounds like a lot, it is actually a consolidation of the data from over 2000 course-takers.

So to be more specific on the question, if I can avoid creating 90 formulas, that would be ideal. However, because these courses and instructors change each month, thus requiring every sheet to be updated every month, even writing 90+ formulas would be worth my time. I just don't know how to designate that the data from a cell in one sheet appear in the cell of another sheet.

Essentially, I am taking a list of the courses and the correlating instructor and creating a sheet for each one.

Does this clarification help? Thanks, again for the input.
Reply With Quote
  #4  
Old 06-06-2010, 06:21 AM
Kimberly Kimberly is offline How do I merge data from one sheet in a workbook out into multiple sheets Windows 7 How do I merge data from one sheet in a workbook out into multiple sheets Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

I strongly recommend trying to use fewer sheets but use tools lke filtering and pivot tables to display the data different ways.

But to create a formula:
  1. Click in the cell that you wish displayed a value from the original sheet.
  2. Type an equal sign
  3. Navigate to and click on the cell that contains the value
  4. Press enter
Alternatively:
  1. Select the cell that contains the value
  2. Copy
  3. Navigate to and click on the cell that should display this value
  4. Use the drop-down on the Paste button to choose Paste Link
Pay close attention to the Formula bar. (the long white box just below the Ribbon). It will show you the true contents of the active cell. (You will be able to view formulas, not just results.)
Reply With Quote
  #5  
Old 06-07-2010, 08:13 AM
nolesca nolesca is offline How do I merge data from one sheet in a workbook out into multiple sheets Windows XP How do I merge data from one sheet in a workbook out into multiple sheets Office 2007
Novice
How do I merge data from one sheet in a workbook out into multiple sheets
 
Join Date: Jun 2010
Posts: 5
nolesca is on a distinguished road
Default

Thank you! I figured out the formula yesterday, but was completely unaware of the shortcuts. Now, just one more piece. Can I use a formula to actually name the sheet. For example, the course I am giving detailed data about would have a name such as RES 195. The name RES 195 would be located in a particular cell, such as B2. Can I use the contents of B2 to actually name the sheet. I don't want to just copy and paste b/c these change monthly, thus the sheet names change monthly. So can I use a formula in giving a worksheet name?

I will investigate pivot tables further. I am inexperienced with them, but will see if they would better serve our purposes. Thanks, again.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Print Multiple Sheets Double-Sided flambe99 Excel 1 03-12-2010 01:15 PM
How do I merge data from one sheet in a workbook out into multiple sheets Select a range in one one workbook while working in other workbook Slow&Steady Excel 1 02-21-2010 03:34 AM
Share Workbook cannot merge Ichigo Excel 3 01-19-2010 03:05 AM
Excel 2007 doesn't print color graphics on multiple sheets mwoolf Excel 1 06-19-2009 02:34 AM
How do I merge data from one sheet in a workbook out into multiple sheets Compare data in different columns in an Excel sheet kgfendi Excel 5 05-16-2009 05:42 PM


All times are GMT -7. The time now is 04:08 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft