Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
headley sappleton
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.setup
Pete
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.setup
bunbarn
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.setup
Pete_UK
 
Posts: n/a
Default 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
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
How do I get cell data in multiple Excel files into one summary fi 78degreesinHI Excel Worksheet Functions 4 August 29th 06 02:05 AM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Import data from files with different names to EXCEL D'base. thunderfoot Excel Discussion (Misc queries) 2 June 10th 05 11:05 AM
Excel Files Acting Weird Anat Excel Discussion (Misc queries) 0 March 29th 05 03:07 AM
Excel Files Won't Open From Shortcut ConfusedNHouston Excel Discussion (Misc queries) 5 December 31st 04 06:25 PM


All times are GMT +1. The time now is 04:21 PM.

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

About Us

"It's about Microsoft Excel"