Software :: Merge Excel Files / Cutting And Pasting All Files In One?
Jan 13, 2010
I need to merge about 17 excel files. All have the same headers and are data from different individuals on the same topics.How can I merge into 1 master file without cutting and pasting all 17 files into a master. Also would be great to be able to break out new spreadsheets by individual columns. ( i.e. Location, Part Number , ect ). A friend wrote a little program for me that worked when I was using a windows based machine, but will not work in the Mac environment.
I still DO NOT understand why apple does not have a cut functionality in the mac. It is really frustrating, as having the cut capability is very useful when moving multiple files through different directories. So is there a way to get this functionality?
Hope someone might be able to help. I am attempting to copy files from a USB attached to my iMac external hard drive to my new NAS drive system, which is connected through my Airport Extreme by gigabit ethernet.I know the NAS is using a file system that I do not recognize (its a WD ShareSpace, 4TB/3TB Raid 5 NAS), which could be causing the problem. Basically I am attempting to transfer all the files stored on the USB external to the NAS. When I copy all the files and paste them to the NAS through Finder, I get an error saying it could not be completed cause I have Insufficient Privileges to do so. There are thousands of files to go through, but I have pinpointed two folders that are causing the problem, which themselves have thousand of files.
I am searching for a plugin, software or a solution for a situation I have with an Excel/Word Mail Merge.
It's a law firm we specialize in DUI/DWI and Reckless Driving defense. We subscribe to a data collection service that pulls data from various court systems around the state. We are then given this data by jurisdiction. The Excel files we receive come with 2 workbooks in one file for Traffic and Criminal arrests data with name, address, reason for arrest, etc, etc.
What I have been doing is opening each Excel file and copying and pasting into a new worksheet only grabbing the DUI and Reckless driving arrests because tis is all I am needing from the various files. I then save the new workbook and do a mail merge with Word from this newly created workbook.
Now my question is there such a plugin or software that will combine all the Excel files I receive from the Data collection house and then be able to filter out only the DUI and Reckless Driving arrests to a single Excel Workbook?
I've got 20 MP4 files I'm trying to merge into a single MP4. When I drag any one of the MP4 files into MKV Tools it comes up with an error that says: "The variable theTrackData is not defined. (-2753)". Can someone either help with a solution to the MKV Tools problem or suggest another program to merge MP4 files without losing any video quality.
I have 29 small 200mb ISO files. When I had a pc I used winiso to merge these files into one iso file. I cannot seem to figure out how to do this on a mac, however. Any program out there that does this?
I must be missing something. I've read the instructions for merging pdf documents in Preview, but it's just not working. Wants me to "duplicate" a file or something. This seems very un-Mac-like. I get 2 documents open, drag the thumbnails from one into another, one at a time, and then try to "Save As".
I am trying to make a backup copy of a DVD I own so that I can watch the movie in iTunes or on my iPhone when I'm on the go. The movie is on a two-part DVD; how can I combine the resulting rip so that I have one movie file in iTunes (rather than a "Part A" and "Part B" file)?
I'd like to announce moveAddict, a Snow Leopard-only application that provides a functionality the Finder was missing, the ability to move files using the keyboard. It�s meant to replace dragging and dropping for anyone that would rather use the keyboard instead of the mouse.
In a nutshell, you can use it to cut files or folders and then paste them where you want.
As a bonus, you can also use it to merge folders instead of completely replacing them, another functionality that the Finder was missing.
For anyone that hasn't used cut and paste for files before, here's a short description:Cut - when you cut files the only thing that happens is that moveAddict remembers the location of the files, it does not change the files in any way Paste - when you paste, moveAddict moves the files from their original locations to the new one If you cut a file and forget to paste it, nothing happens!
moveAddict does not change the system or the Finder in any way, it's just a regular application which you can uninstall by deleting it.
I am the developer of moveAddict, for any questions/suggestions/bugs please reply to this thread or contact me personally.
I handle a bit of finances at a small business. Each week I pull out a report from a web-based economy system. That then opens in Excel. What I'd like to do is simple:
1. The first week I pull the report and mark some stuff on the Excel page (for example highlighting certain debitors, making comments, color fills etc.) 2. The following week I pull the report again, and now I'd like to merge the two together. That is, keep the data from week 1 (or replace parts of it, if that's relevant) and simply add the data from week 2 onto that same sheet, so all information is right there.
I thought that would be a no-brainer. Now I've tried to merge workbooks, consolidate data, looked at tutorials on youtube, read forum posts - the lot, and I still can't get it to work. (Brain possibly smaller than I thought).
I have five different excel files on the dock (they appear below the line, along with the trash icon). When I click on them a question mark appears on top of the excel symbol, and "help" says this means they have been deleted. None of them were saved anywhere but on the dock. But I have not opened three of them for weeks, and cannot find any of them with "finder". I always save when prompted before closing the Excel application, and would never knowingly delete them, as they represent hundreds of hours of work.
My MBP blew up so am on a temporary Blackbook and luckily all my important day to day docs are on my iDisk, no problem I thought... But something really odd is happening, when I try to open a spreadsheet with Excel (tried 04 and 08) it says "the file may be read only or you may be trying to access a read only location or the server the document on may not be responding".
I can open the file with open office and ALL other file types open fine from iDisk (including Word and PPT).
At the moment I am having to drag the files to my desktop edit them and drag them back to iDisk so all is up to date when I get my computer back.
Has anyone had anything similar? Any tips gratefully received (apart from the obvious; ditch MS Office!).
After first noticing the problem I set iDisk to keep a local copy on the temp machine but this made no difference.
Excel is opening closed files from prior sessions when I log into my Mac Pro on Lion. I want excel to launch at log in, but I don't want it opening a lot of files that I have no interest in and since they are big, they take a lot of time to open. I haven't been able to find the setting that will eliminate this problem. Does anyone have any information about whether there is a setting or whether this is "a Feature"?
I record my activity for my job in an excel file on my MacBook Pro, and for some reason, the last few files that I have saved have somehow disappeared. They are simply not there when I go to open them. Is there any way I can track them down in my computer?
I cannot access or save exel or Powerpoint Files. I did restart the machine after every install. I also repaired the disc permissions but I had two messages come up: 1. SUID file " system/library/CoreS...as been modified and will not be repaired 2. SUID file " system/library/Private...as been modified and will not be repaired When I try and open an excel or PowerPoint file that already exists, a message pops up and says that "the file cannot be accessed".When I try and save a new file it says that several things could be wrong such as:I have installed and uninstalled so many times. I have called apple and they said its a Microsoft problem so they wouldn't help. I then called Microsoft and they wont help unless I purchase another copy. The copy I originally had got deleted during my reboot. I have no idea how to solve this problem. I need excel in order to do my schoolwork.
I have these Numbers files but need to send them to someone who is using a pc with MS Excel. She won't be able to read the files if they are left as .numbers. The odd thing is that I have successfully saved some of the files as .xls and .xls.xls and even some as .xls.numbers.
However, I have lost data when doing some of these savings - I have been taking the .numbers file and trying to save it as .xls but when I open the newly-saved file there's nothing there. Please look at the attached snapshot of my folder structure. Can you anything in there that might be causing my problem? The red arrows are just to highlight the ones I'm particularly interested in.
I'm downloading different files into excel (some tab delimited, some csv, some xls) from different places and they all open in excel with incredibly weird formatting. Basically the separation of each column makes no sense. When other people download the same exact files, their files appear normally, with each category in a different column. So there's something going on with my excel.
When I download a credit card statement, for example, it comes out like this:
"02/03/2010$18""82USPS 35960795520803QPS NEW YORK XXXXXXXXXXXXXX48(Standard Purch)"
With the quotes showing the columns... so the date and half of the price are in one column and the cents from the price and the vendor and the last four digits in the second column.
This is the first time I have created an Excel file on my own MacBook Air, and while doing so, I noticed that five Excel files were created somehow on my desktop, with file names such as "B958D530." I cannot move them, open them, get info about them, or delete them. What are these and how do I get rid of them?