View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] Jessica@aol.com is offline
external usenet poster
 
Posts: 12
Default Merging Workbooksheets in to just one data source

I have created a data source within Excel. In this spreadsheet I have
serveral different worksheet names and I need to merge them all into 1
worksheet says, the Publisher tech an order to merge my data into one. Please
advise

Question Posted via Publisher:

I have created a data source in excel that has several worksheets. When I do
the merge it only merges one of the worksheets and all the others I have to
merge idividually. Is that normal or is there something that I have done
incorrectly. Please Advise

Response from the Publisher Tech
Might try Word. It is far more powerful than Publisher. May have more
choices.
When I setup a list it usually is a simple name, address type. I think you
can
merge databases together but you will have to ask in an Excel group to find
out
how or read the help entry.

--
astro44