Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merging multiple columns of data into one column of data Archangel Excel Discussion (Misc queries) 7 February 24th 07 10:02 AM
Hold format from excel to data source for mail merging Frank3 Excel Worksheet Functions 2 October 5th 05 05:55 PM
Pivot Table data source "data source contains no visible tables" Jane Excel Worksheet Functions 0 September 29th 05 08:28 PM
How can i set the source-data-range of pivottable2 to the source . Piet Excel Discussion (Misc queries) 0 March 5th 05 09:31 PM
Should Merging workbooks pick up new data or only edited data? Peggy L. Excel Worksheet Functions 0 January 13th 05 05:31 PM


All times are GMT +1. The time now is 03:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"