How do I populate Worksheets using information entirely from another Worksheet in the same Workbook?

macropod · #1 06-18-2016, 10:50 AM

See, for example, either of:

http://windowssecrets.com/forums/sho...l=1#post734296
http://www.techsupportforum.com/foru...ml#post2567119
(same workbook in both). For what you're trying to do it would be best to keep the checkboxes on the master sheet. That way, things won't get out of synch on the recipient sheets if the master sheet gets re-arranged.

An alternative would be to ditch the recipient sheets and use a Word mailmerge to list the items by recipient.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Summing data from multiple worksheets in a workbook and placing into another worksheet	safrac	Excel	17	10-04-2022 12:21 PM
vba code for integrating particular information from different workbook to one workbook	klpw	Excel Programming	1	12-28-2015 09:48 AM
Add worksheets to workbook	boboles	Excel	2	01-26-2015 07:42 AM
I need an index file containing the names of all the worksheets in a workbook.	retiredstuart	Excel	3	09-12-2014 06:26 AM
Cells from other worksheets apear on current worksheet	Equilar	Excel	3	05-03-2010 01:40 AM