Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]() 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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |