Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 10th 06, 07:07 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 1
Default CAN I CLUB SIMILAR EXCEL FILES WITHOUT COPYING AND PASTING

suppose i want to club or add similar excel files;for example two files
containing 2 columns like name and telephone no.can this be clubbed into a
single file by a command or formula without the normal procedure of opening
one file copying and then pasting into the other file.

  #2   Report Post  
Old November 10th 06, 07:47 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 194
Default CAN I CLUB SIMILAR EXCEL FILES WITHOUT COPYING AND PASTING

NAINAN

Could you please explain what you mean by "club"? Is this sdomething you
are trying to "force" to happen?

Mike Rogers

"NAINAN JOSEPH" wrote:

suppose i want to club or add similar excel files;for example two files
containing 2 columns like name and telephone no.can this be clubbed into a
single file by a command or formula without the normal procedure of opening
one file copying and then pasting into the other file.

  #3   Report Post  
Old November 11th 06, 06:56 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 58
Default CAN I CLUB SIMILAR EXCEL FILES WITHOUT COPYING AND PASTING

Yes you can, you can actually go to the first sheet, place a "+" sign in
the first sheet cell A2 for example, and then open the second sheet and go
to the cell that you want to add then press enter. It will then automaticall
update the cell in the first sheet from the second sheet.
I hope this helps
--------------------------------------------------------------------------------
Sam Sebaihi Faculty Western International University Associate Programs
(alternate email) Phone #:
(405)315-8223 Time zone: Pacific Time
"NAINAN JOSEPH" <NAINAN
wrote in message
...
suppose i want to club or add similar excel files;for example two files
containing 2 columns like name and telephone no.can this be clubbed into a
single file by a command or formula without the normal procedure of
opening
one file copying and then pasting into the other file.





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
Scanned files into Excel? bbkasking Excel Discussion (Misc queries) 0 July 13th 06 04:30 PM
copying and pasting excel formulae bennyrub Excel Worksheet Functions 2 May 6th 06 07:35 PM
Copying from Excel - pasting in Publisher Vman Excel Discussion (Misc queries) 0 March 20th 06 02:45 AM
Copying from Excel - pasting in Publisher vman252 Excel Worksheet Functions 0 March 20th 06 12:03 AM
Copying from Excel - pasting in Publisher vman252 Excel Discussion (Misc queries) 0 March 20th 06 12:01 AM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017