Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
plittle
 
Posts: n/a
Default How do I use excel information for a second excel worksheet

I am trying to transfer excel worksheet information, also used as a merge for
a word document, into another excel worksheet then I will be adding
additional information to that second worksheet
  #2   Report Post  
Posted to microsoft.public.excel.misc
robert111
 
Posts: n/a
Default How do I use excel information for a second excel worksheet


in cell A1 of spreadsheet2 type =

then go to spreadsheet1 cell A1 and press return

spreadsheet 2 is now a copy of spreadsheet 1 after you have dragged the
formula down and across as required.

Add new info and get merging....


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=538207

  #3   Report Post  
Posted to microsoft.public.excel.misc
plittle
 
Posts: n/a
Default How do I use excel information for a second excel worksheet

Thank your for the advise. I did what you said in the spreadsheets and it
worked great but I do not know how to merge them together. I am totally new
to Excel. Could you please explain the "add new info and get merging . . .
" comment.



"robert111" wrote:


in cell A1 of spreadsheet2 type =

then go to spreadsheet1 cell A1 and press return

spreadsheet 2 is now a copy of spreadsheet 1 after you have dragged the
formula down and across as required.

Add new info and get merging....


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=538207


  #4   Report Post  
Posted to microsoft.public.excel.misc
plittle
 
Posts: n/a
Default How do I use excel information for a second excel worksheet

Can you please explain the "add new info and get merging . . ." comment.
The cell A1 thing worked but now I do not know how to "merge". I have not
used Excel before so all this is new

"plittle" wrote:

Thank your for the advise. I did what you said in the spreadsheets and it
worked great but I do not know how to merge them together. I am totally new
to Excel. Could you please explain the "add new info and get merging . . .
" comment.



"robert111" wrote:


in cell A1 of spreadsheet2 type =

then go to spreadsheet1 cell A1 and press return

spreadsheet 2 is now a copy of spreadsheet 1 after you have dragged the
formula down and across as required.

Add new info and get merging....


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=538207


  #5   Report Post  
Posted to microsoft.public.excel.misc
robert111
 
Posts: n/a
Default How do I use excel information for a second excel worksheet


your original question said you would be adding new info before doing
the mail merge


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=538207

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
Cannot use Data Analysis tools on Excel worksheet embedded in PwrP SRG Excel Worksheet Functions 1 January 31st 06 08:01 AM
Excel 2003, Convert EXISTING Worksheet Data to XML? [email protected] Excel Discussion (Misc queries) 4 November 16th 05 04:45 AM
How do can I create a Excel worksheet from information on a templa Genesis Excel Discussion (Misc queries) 0 April 15th 05 07:27 PM
Create New Microsoft Excel Worksheet Has 3 Sheets Bassam Setting up and Configuration of Excel 0 February 9th 05 08:51 PM
Need to remove a password that noone placed on Excel worksheet. tuffy1104 Excel Worksheet Functions 2 January 2nd 05 07:12 PM


All times are GMT +1. The time now is 06:47 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"