I am creating a master template for a work camp. Each member organization
has its own worksheet listing all of the attendees; they will complete these
forms at different times. I need a master list for all attendees.

How can I fill in the data from each identical sheet into a different sheet?
Can this be done automatically (for example when group 1 updates their sheet
on Monday & Group 2 updates on Tuesday, the data is filled in automatically
both times)?

Thanks in advance for your help.

Try using the Consolidate feature in Excel,
on the menu bar Data Consolidate
and follow the steps provided

Generally, if you need your Summary Sheet to be auto update when new data are
enter into the respective cells, you need to link them together

HTH

--
Your feedback is important and appreciate as it will help others to search
the archives better.
pls click on the Yes button below if this posting is helpful.

Thank You

cheers, francis









"kamartin" wrote:

I am creating a master template for a work camp. Each member organization
has its own worksheet listing all of the attendees; they will complete these
forms at different times. I need a master list for all attendees.

How can I fill in the data from each identical sheet into a different sheet?
Can this be done automatically (for example when group 1 updates their sheet
on Monday & Group 2 updates on Tuesday, the data is filled in automatically
both times)?

Thanks in advance for your help.

I think the Consolidate feature will be perfect, but all of the functions are
for numbers. I need to automatically copy a list of names from one roster to
a separate roster. Some of the columns are text, others are numbers.

Which function should I pick?

Thanks,
Kris Ann

"xlmate" wrote:

Try using the Consolidate feature in Excel,
on the menu bar Data Consolidate
and follow the steps provided

Generally, if you need your Summary Sheet to be auto update when new data are
enter into the respective cells, you need to link them together

HTH

--
Your feedback is important and appreciate as it will help others to search
the archives better.
pls click on the Yes button below if this posting is helpful.

Thank You

cheers, francis









"kamartin" wrote:

I am creating a master template for a work camp. Each member organization
has its own worksheet listing all of the attendees; they will complete these
forms at different times. I need a master list for all attendees.

How can I fill in the data from each identical sheet into a different sheet?
Can this be done automatically (for example when group 1 updates their sheet
on Monday & Group 2 updates on Tuesday, the data is filled in automatically
both times)?

Thanks in advance for your help.

I think the Consolidate feature may be perfect. It seems that all of the
functions available are for numbers only. However, I need list names from
each sheet into one. Some of the columns are text & others are numbers.

What function should I use?

Thanks,
Kris Ann

"xlmate" wrote:

Try using the Consolidate feature in Excel,
on the menu bar Data Consolidate
and follow the steps provided

Generally, if you need your Summary Sheet to be auto update when new data are
enter into the respective cells, you need to link them together

HTH

--
Your feedback is important and appreciate as it will help others to search
the archives better.
pls click on the Yes button below if this posting is helpful.

Thank You

cheers, francis









"kamartin" wrote:

I am creating a master template for a work camp. Each member organization
has its own worksheet listing all of the attendees; they will complete these
forms at different times. I need a master list for all attendees.

How can I fill in the data from each identical sheet into a different sheet?
Can this be done automatically (for example when group 1 updates their sheet
on Monday & Group 2 updates on Tuesday, the data is filled in automatically
both times)?

Thanks in advance for your help.

I think the Consolidate feature may be perfect. It seems that all of the
functions available are for numbers only. However, I need list names from
each sheet into one. Some of the columns are text & others are numbers.

What function should I use?

Thanks,
Kris Ann

"xlmate" wrote:

Try using the Consolidate feature in Excel,
on the menu bar Data Consolidate
and follow the steps provided

Generally, if you need your Summary Sheet to be auto update when new data are
enter into the respective cells, you need to link them together

HTH

--
Your feedback is important and appreciate as it will help others to search
the archives better.
pls click on the Yes button below if this posting is helpful.

Thank You

cheers, francis









"kamartin" wrote:

I am creating a master template for a work camp. Each member organization
has its own worksheet listing all of the attendees; they will complete these
forms at different times. I need a master list for all attendees.

How can I fill in the data from each identical sheet into a different sheet?
Can this be done automatically (for example when group 1 updates their sheet
on Monday & Group 2 updates on Tuesday, the data is filled in automatically
both times)?

Thanks in advance for your help.

I think the Consolidate feature may be perfect. It seems that all of the
functions available are for numbers only. However, I need list names from
each sheet into one. Some of the columns are text & others are numbers.

What function should I use?

Thanks,
Kris Ann

"xlmate" wrote:

Try using the Consolidate feature in Excel,
on the menu bar Data Consolidate
and follow the steps provided

Generally, if you need your Summary Sheet to be auto update when new data are
enter into the respective cells, you need to link them together

HTH

--
Your feedback is important and appreciate as it will help others to search
the archives better.
pls click on the Yes button below if this posting is helpful.

Thank You

cheers, francis









"kamartin" wrote:

I am creating a master template for a work camp. Each member organization
has its own worksheet listing all of the attendees; they will complete these
forms at different times. I need a master list for all attendees.

How can I fill in the data from each identical sheet into a different sheet?
Can this be done automatically (for example when group 1 updates their sheet
on Monday & Group 2 updates on Tuesday, the data is filled in automatically
both times)?

Thanks in advance for your help.