CAN I CLUB SIMILAR EXCEL FILES WITHOUT COPYING AND PASTING

G

Guest

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

Guest

NAINAN

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

Mike Rogers
 
S

SAM SEBAIHI

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge Like Files into 1 File 1
Copying and pasting ??? 3
Some charts won't copy properly from Excel 2007 6
Excel Paste Formating 3
Remove leading zeros 9
How to open two Excel files in separate windows? 4
How to create a list of media files names in excel. 2
How do I print column on left of page then break & go to right 2

Top