Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving primary data from master sheet to individual sheets w/in wo
I think this question was already addressed, but you're dealing with the
village idiot here . . . the answers didn't make sense to me. What I have is a workbook with 7 spread sheets. It is a database for an insurance program. On each sheet I need the named insured, the policy term, policy number, retro date etc. Is there a way that I can set up a basic info spreadsheet and copy the info from it to each of the other spreadsheets based on what that particular spreadsheet requires. So, that I can fill in the primary info and when I change it have it automatically change on all of the sheets within the workbook. Please remember I need step by step directions for a person who is not into computer jargon and needs everything very basic. My thanks to anyone who can help me. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving primary data from master sheet to individual sheets w/in wo
From one village idiot to another (I'm offering a virtual high five). If I
understand your question, you want to type in, say a policy number, in "Sheet 1" and have that entry reflected in "Sheet 2", "Sheet 3", etc. in which ever cell you choose in each sheet. Go ahead and type in the policy number in "Sheet 1" and then go to "Sheet 2" and select the cell where you want the policy number to appear. Now press the equal sign(=). Next, with your mouse, left click the "Sheet 1" tab and find the policy number. Left click it and press the "Enter" key. That's it. If you change the policy number on "Sheet 1" the change will be reflected everywhere you linked it in this fashion. -- Y "willie091028" wrote: I think this question was already addressed, but you're dealing with the village idiot here . . . the answers didn't make sense to me. What I have is a workbook with 7 spread sheets. It is a database for an insurance program. On each sheet I need the named insured, the policy term, policy number, retro date etc. Is there a way that I can set up a basic info spreadsheet and copy the info from it to each of the other spreadsheets based on what that particular spreadsheet requires. So, that I can fill in the primary info and when I change it have it automatically change on all of the sheets within the workbook. Please remember I need step by step directions for a person who is not into computer jargon and needs everything very basic. My thanks to anyone who can help me. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
Auto "copy and paste" individual cells from various sheets into one sheet ?? | Excel Discussion (Misc queries) | |||
Multiple sheets as data for a single sheet | Excel Worksheet Functions | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |