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.

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.

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.

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.)

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.