Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Any utility for joining two or more Excel or CVS files
Hi
i am relatively new to Excel, but i was wondering if there was a utility, macro or whatever to join two or more Excel files (of exactly same structure). I am currently cutting and pasting them together, but it is oh, so tedious! |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Any utility for joining two or more Excel or CVS files
If you have both workbooks open and visible in the same Excel window,
you can drag a sheet from one book into the window of the other book, effectively moving it in its entirety from one file to the other. Is this what you mean by joining the files together? Hope this helps. Pete |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
Any utility for joining two or more Excel or CVS files
Pete wrote: If you have both workbooks open and visible in the same Excel window, you can drag a sheet from one book into the window of the other book, effectively moving it in its entirety from one file to the other. Is this what you mean by joining the files together? Hope this helps. Pete Here's another question? We have a worksheet with data like a check book register. We would like to be able to merge data into it. We download the second bit of data from online into a CSV file. Is there a way to combine the two, thereby deleting the first entry and keeping the second one? Thanks Noreen |
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
Any utility for joining two or more Excel or CVS files
Could you give a few examples of what the data looks like in both
sheets, and exactly how you want to combine them (add, subtract, replace?)? Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get cell data in multiple Excel files into one summary fi | Excel Worksheet Functions | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Import data from files with different names to EXCEL D'base. | Excel Discussion (Misc queries) | |||
Excel Files Acting Weird | Excel Discussion (Misc queries) | |||
Excel Files Won't Open From Shortcut | Excel Discussion (Misc queries) |