Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scanned files into Excel? | Excel Discussion (Misc queries) | |||
copying and pasting excel formulae | Excel Worksheet Functions | |||
Copying from Excel - pasting in Publisher | Excel Discussion (Misc queries) | |||
Copying from Excel - pasting in Publisher | Excel Worksheet Functions | |||
Copying from Excel - pasting in Publisher | Excel Discussion (Misc queries) |