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. |
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. |
All times are GMT +1. The time now is 12:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com