make large worksheet from workbook

C

Cowtoon

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.
 
F

Frank Kabel

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

Cowtoon

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
 
F

Frank Kabel

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 :)
 
C

Cowtoon

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
 
Top