I have several worksheets in a workbook. I'd like to pull all contents (from
all worksheets) into one worksheet, while leaving the other worksheets in
tact. Is there a way to do that. The other worksheets will change
periodically, so it has to be setup to allow for those changes/additions. I
have no idea how to approach this or what to look up to find help. Any
thoughts? Thanks.

Hi
better would be if you had only one master sheet. any way to change
your spreadsheet layout?

--
Regards
Frank Kabel
Frankfurt, Germany

"Cowtoon" schrieb im Newsbeitrag
...
I have several worksheets in a workbook. I'd like to pull all
contents (from
all worksheets) into one worksheet, while leaving the other
worksheets in
tact. Is there a way to do that. The other worksheets will change
periodically, so it has to be setup to allow for those
changes/additions. I
have no idea how to approach this or what to look up to find help.
Any
thoughts? Thanks.

Frank, I'm not sure what you mean. Perhaps I confused you. I'll give you
more information.

The information contained in each of the worksheets needs to be kept
separate with periodic exceptions and I have one of those exceptions
happening, now. It's a contact list used for merges with Word.

The task at hand is to send Christmas cards out. Therefore, I want to merge
all of the lists at one time, but it would appear that the only way to do it
is to put them all into one list before I do the merge. Does that help you
or confuse you? Diana

"Frank Kabel" wrote:

Hi
better would be if you had only one master sheet. any way to change
your spreadsheet layout?

--
Regards
Frank Kabel
Frankfurt, Germany

"Cowtoon" schrieb im Newsbeitrag
...
I have several worksheets in a workbook. I'd like to pull all
contents (from
all worksheets) into one worksheet, while leaving the other
worksheets in
tact. Is there a way to do that. The other worksheets will change
periodically, so it has to be setup to allow for those
changes/additions. I
have no idea how to approach this or what to look up to find help.
Any
thoughts? Thanks.

Hi
yes this is the most common way: Just copy and paste them. Therefore my
suggestion would be for the future to have only one sINGLE sheet
containing all your addresses and adding an additional column for the
information you currently have through the sheet name.

Saying that: Personally I'd store address information in a 'real'
database :-)


--
Regards
Frank Kabel
Frankfurt, Germany


Cowtoon wrote:
Frank, I'm not sure what you mean. Perhaps I confused you. I'll
give you more information.

The information contained in each of the worksheets needs to be kept
separate with periodic exceptions and I have one of those exceptions
happening, now. It's a contact list used for merges with Word.

The task at hand is to send Christmas cards out. Therefore, I want
to merge all of the lists at one time, but it would appear that the
only way to do it is to put them all into one list before I do the
merge. Does that help you or confuse you? Diana

"Frank Kabel" wrote:

Hi
better would be if you had only one master sheet. any way to change
your spreadsheet layout?

--
Regards
Frank Kabel
Frankfurt, Germany

"Cowtoon" schrieb im Newsbeitrag
...
I have several worksheets in a workbook. I'd like to pull all
contents (from
all worksheets) into one worksheet, while leaving the other
worksheets in
tact. Is there a way to do that. The other worksheets will change
periodically, so it has to be setup to allow for those
changes/additions. I have no idea how to approach this or what to
look up to find help.
Any
thoughts? Thanks.

Hi Frank,
Unfortunately, this is "someone else's" spreadsheet, so I don't have much of
a choice - I'm a temporary replacement and don't want to mess with their
setup.

There are several fields in each record, so it's not quite as simple as just
adding a column to add more information.

I already considered the copy/paste method, but am holding out, in case a
more automated method presents itself, but it's what I might end up doing to
accomplish this task. Thanks for your time. Diana

"Frank Kabel" wrote:

Hi
yes this is the most common way: Just copy and paste them. Therefore my
suggestion would be for the future to have only one sINGLE sheet
containing all your addresses and adding an additional column for the
information you currently have through the sheet name.

Saying that: Personally I'd store address information in a 'real'
database :-)


--
Regards
Frank Kabel
Frankfurt, Germany


Cowtoon wrote:
Frank, I'm not sure what you mean. Perhaps I confused you. I'll
give you more information.

The information contained in each of the worksheets needs to be kept
separate with periodic exceptions and I have one of those exceptions
happening, now. It's a contact list used for merges with Word.

The task at hand is to send Christmas cards out. Therefore, I want
to merge all of the lists at one time, but it would appear that the
only way to do it is to put them all into one list before I do the
merge. Does that help you or confuse you? Diana

"Frank Kabel" wrote:

Hi
better would be if you had only one master sheet. any way to change
your spreadsheet layout?

--
Regards
Frank Kabel
Frankfurt, Germany

"Cowtoon" schrieb im Newsbeitrag
...
I have several worksheets in a workbook. I'd like to pull all
contents (from
all worksheets) into one worksheet, while leaving the other
worksheets in
tact. Is there a way to do that. The other worksheets will change
periodically, so it has to be setup to allow for those
changes/additions. I have no idea how to approach this or what to
look up to find help.
Any
thoughts? Thanks.

Hi
for some macro code see:
http://www.rondebruin.nl/copy2.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"Cowtoon" schrieb im Newsbeitrag
...
Hi Frank,
Unfortunately, this is "someone else's" spreadsheet, so I don't have
much of
a choice - I'm a temporary replacement and don't want to mess with
their
setup.

There are several fields in each record, so it's not quite as simple
as just
adding a column to add more information.

I already considered the copy/paste method, but am holding out, in
case a
more automated method presents itself, but it's what I might end up
doing to
accomplish this task. Thanks for your time. Diana

"Frank Kabel" wrote:

Hi
yes this is the most common way: Just copy and paste them.
Therefore my
suggestion would be for the future to have only one sINGLE sheet
containing all your addresses and adding an additional column for
the
information you currently have through the sheet name.

Saying that: Personally I'd store address information in a 'real'
database :-)


--
Regards
Frank Kabel
Frankfurt, Germany


Cowtoon wrote:
Frank, I'm not sure what you mean. Perhaps I confused you. I'll
give you more information.

The information contained in each of the worksheets needs to be
kept
separate with periodic exceptions and I have one of those
exceptions
happening, now. It's a contact list used for merges with Word.

The task at hand is to send Christmas cards out. Therefore, I
want
to merge all of the lists at one time, but it would appear that
the
only way to do it is to put them all into one list before I do
the
merge. Does that help you or confuse you? Diana

"Frank Kabel" wrote:

Hi
better would be if you had only one master sheet. any way to
change
your spreadsheet layout?

--
Regards
Frank Kabel
Frankfurt, Germany

"Cowtoon" schrieb im
Newsbeitrag
...
I have several worksheets in a workbook. I'd like to pull all
contents (from
all worksheets) into one worksheet, while leaving the other
worksheets in
tact. Is there a way to do that. The other worksheets will
change
periodically, so it has to be setup to allow for those
changes/additions. I have no idea how to approach this or what
to
look up to find help.
Any
thoughts? Thanks.