| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
updating multiple worksheets
I have 2 worksheets for attendance. 1-15th and 16-31st. I want to be able to
make a change to EITHER sheet which will update BOTH sheets. Is this possible? -- Thanks, Pat |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
updating multiple worksheets
If you group the worksheets, any change made to one will be made
to the other. Select the first worksheet tab, hold down the CTRL key and click the second worksheet. The word 'Group' will be displayed in the Application Caption. Be sure to ungroup the sheets when you're done. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Pat" wrote in message ... I have 2 worksheets for attendance. 1-15th and 16-31st. I want to be able to make a change to EITHER sheet which will update BOTH sheets. Is this possible? -- Thanks, Pat |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
updating multiple worksheets
Thank you for your reply. You suggest UNgrouping when done but can I leave
the grouping on permanently as these two worksheets must always match each other. -- Thanks, Pat "Chip Pearson" wrote: If you group the worksheets, any change made to one will be made to the other. Select the first worksheet tab, hold down the CTRL key and click the second worksheet. The word 'Group' will be displayed in the Application Caption. Be sure to ungroup the sheets when you're done. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Pat" wrote in message ... I have 2 worksheets for attendance. 1-15th and 16-31st. I want to be able to make a change to EITHER sheet which will update BOTH sheets. Is this possible? -- Thanks, Pat |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
updating multiple worksheets
In attempting your method it definitely works but not for my purpose. I only
want the first 3 columns of information to update when a change is made the remainder of the worksheet will have varying information as it is tracking attendance/hours worked on a daily basis. Can this be done? -- Thanks, Pat "Chip Pearson" wrote: If you group the worksheets, any change made to one will be made to the other. Select the first worksheet tab, hold down the CTRL key and click the second worksheet. The word 'Group' will be displayed in the Application Caption. Be sure to ungroup the sheets when you're done. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Pat" wrote in message ... I have 2 worksheets for attendance. 1-15th and 16-31st. I want to be able to make a change to EITHER sheet which will update BOTH sheets. Is this possible? -- Thanks, Pat |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
updating multiple worksheets
Technically, it's possible with event macros. But it's fraught with
problems--if macros are disabled or events are disabled or just stuff the user does that you didn't program against. If I were you, I'd really try my best to keep all the data on one worksheet. Pat wrote: In attempting your method it definitely works but not for my purpose. I only want the first 3 columns of information to update when a change is made the remainder of the worksheet will have varying information as it is tracking attendance/hours worked on a daily basis. Can this be done? -- Thanks, Pat "Chip Pearson" wrote: If you group the worksheets, any change made to one will be made to the other. Select the first worksheet tab, hold down the CTRL key and click the second worksheet. The word 'Group' will be displayed in the Application Caption. Be sure to ungroup the sheets when you're done. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Pat" wrote in message ... I have 2 worksheets for attendance. 1-15th and 16-31st. I want to be able to make a change to EITHER sheet which will update BOTH sheets. Is this possible? -- Thanks, Pat -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort data on multiple worksheets | Excel Discussion (Misc queries) | |||
| SUMif or SUMproduct across multiple worksheets? | Excel Worksheet Functions | |||
| Functions across multiple worksheets | Excel Worksheet Functions | |||
| Adding multiple worksheets | Excel Worksheet Functions | |||
| Updating multiple worksheets in a large workbook | Excel Discussion (Misc queries) | |||
Linear Mode
