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

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

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

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

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