Forum Discussion
Excel for Dummies...namely me...LOL
Hello all and thank you in advance for your help. I have an excel form that has multiple page/tabs with the same information on each tab. How do I create a formula that will allow me to link those f...
Hello,
Instead of having multiple sheet tabs, the good practice is to put all the information into a single sheet. Then,you can use PivotTavble to analyze the data or SUMIFS function depending on what you're trying to achieve.
Instead of having multiple sheet tabs, the good practice is to put all the information into a single sheet. Then,you can use PivotTavble to analyze the data or SUMIFS function depending on what you're trying to achieve.
Abiola1,
Thank you for replying. I looked around for "PivotTable" and could not find it. But that's my problem. I don't have enough experience working with Excel. I do know it is possible too enter information say on the first tab and have that information show up on multiple tabs. I've seen it on a excel form I just don't know how to recreate it.
For ex: site name is at the top of the form in cell A7 on different tabs. I want to change it on tab 1 so any information I add or change in that cell also changes on the other tabs A7.
Hope that helps you help me....LOL.
Thank you for replying. I looked around for "PivotTable" and could not find it. But that's my problem. I don't have enough experience working with Excel. I do know it is possible too enter information say on the first tab and have that information show up on multiple tabs. I've seen it on a excel form I just don't know how to recreate it.
For ex: site name is at the top of the form in cell A7 on different tabs. I want to change it on tab 1 so any information I add or change in that cell also changes on the other tabs A7.
Hope that helps you help me....LOL.
Pivot Table can be found a number of places. Here's one
HOWEVER, that was just one suggestion, and may not be applicable. Please upload a sample of the kind of sheet you're dealing with.
Also see my suggestion about Named Range.
The simplest way to have whatever is in Cell A7 appear on each of the other sheets is to go to A7 in one of the other sheets, enter an equal sign, and then go to the first sheet and click on cell A7. It's easy to make that kind of cross reference.
I don't recommend that as a solution though. It's a band aid, covering over a deeper problem. That you are asking that question is a clue that we could offer a lot more help and make your sheet far more effective...so please upload a copy.
