Applications :: Using Mac Excel - Merge/Filter/Extract Into A Single Excel File?
Feb 6, 2009
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?
Microsoft Word Mail Merge launches a file converter when using Excel files as the data source. Nothing new about that. However, when using Mail Merge in Word 2008 and an Excel xlsx file as data source under OS X 10.6, the file converter will not recognize the file unless the extension .xlsx is actually appended to the file name. The file converter used by Word 2008 still recognizes xls files with or without the extension appended, as did the file converter used by Word X.
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).
1. Turned the List Manager on by accident in Excel. Can't figure out how to turn it off now. I am using Excel 2004, and a MAC mouse - so no right-clicking for me...
2. How do I move columns in Excel? I select the column on top, but then try dragging it to a place I'd like it to move, but nothing happens. How do I do that?
3. General Mac Word/Excel question - how do I get to use "Home" and "End" buttons? When I hit them I simply jump somewhere, but not to the beginning or end of the paragraph. I have a MAC keyboard with the "Home" and "End" buttons along with the "Help", "Delete", "Pg Up" and "Pg Dwn" keys - basically it looks a lot like a PC keyboard...
I have been asked to do a project at work in Excel. I am keeping track of around 7,000 properties all over the United States. My boss wants to know a lot about each one. I am really struggling with the weather part!! I need to somehow pull the temp and if its snowing or raining from the internet into excel. I have all the addresses and zip codes for each property. I was thinking i could write a formula that looks at an RSS feed or website (like yahoo or Google weather) based on the zip code of the address. I could also write the formula that pulls the weather to excel then VLOOKUP the zip. Does anyone have any ideas about this?? I am not sure what to do!!
I have been asked to do a project at work in Excel. I am keeping track of around 7,000 properties all over the United States. My boss wants to know a lot about each one. I am really struggling with the weather part!! I need to somehow pull the temp and if its snowing or raining from the internet into excel. I have all the addresses and zip codes for each property. I was thinking i could write a formula that looks at an RSS feed or website (like yahoo or Google weather) based on the zip code of the address. I could also write the formula that pulls the weather to excel then VLOOKUP the zip. Does anyone have any ideas about this?? I am not sure what to do
I recently purchased my first MAC with Excel for Mac 2008. I am unable to open any files created in it on my PC which has Excel 2003. Apple is of no help. They had assured me of compatibility at purchase citing the new open format. The MAC Excel 08 file won't open on the MAC on which is was created with their Numbers program either.
When I send my .xls files from my Mac (Office 2008) to my boss's Windows machine (Office 2003), he gets an error message when he attempts to open the excel spreadsheet: Excel has encountered an error and must shut down. I've sent files to other computers and not had a problem, and my boss has received other excel files and been able to open them. So it must be something between these two machines/softwares that is affecting it. Any suggestions or ideas? I can add any additional info you need.
I'm running an experiment that will give me a spreadsheet in Excel with 20 participants names, addresses, email addresses, and profits (from the experiment). My goal is to take this data and create individual receipts in Word that have all the above information and can be printed out and handed to the individuals (20 receipts). I have access to Office 2004 (Mac) or 2007 (Windows).
i am a new mac user and am slowly starting to get to grips with everything mymcbook can do. I used to have a hotmail account but now i want to use MAC's MAIL. I already managed to get my mails delivered but now i'm struggling with the email addresses. I have managed to export these from my hotmail account to Excel for Mac but would like to get them, nicely ordened in Apple's address book so that i can directly use then in MAIL.
I have some .numbers files that I need a friend to look at on her pc with Excel 2003 SP3, but it's not working for her. I have changed the extension to .xls but it's no good, as when she tries to open them they are all gobbledegook.
Here's a snapshot of the various files I have, but notice how the icons for each is different, or rather that there are two distinct designs? Some of them DO open in Excel, but some do not.
Is there a size limit for importing an Excel File into Numbers? The error message says the file is too large. Has this been changed in i-work 09? The file has multiple sheets that refer to each other, but i can't even open at this point. It is 3.1 MB.
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.
Recently switched from PC to Mac, I really miss the F2 functionality in Excel for Mac
Or, more specifically , I am missing the possibility to place the cursor in a cell and hit F2 to edit the formula as well as Excel color-coding all cells that are referred to from the current cell.
I know I can do the same by clicking in the "formula builder toolbar" but I don't wan't to have to reach for the mouse each time... does anyone know if Excel for Mac has a similar feature / keystroke to use
I have an excel file that I can't delete - any suggestions on how to get rid of it? I can't move to trash, can't open, can't do anything to do. The message I get is "the item B4D19F00 can't be moved to trash because it can't be deleted".
I just used software updater this morning (Oct. 22,2010). Now when I go to open an excel file, it appears to open but doesn't. I can open up other excel files. Other people can open up this same file. I even had someone re-save file with new name, and it still won't open. If I open it directly from Entourage, it will open excel, but not the workbook. The workbook isn't hidden, as I've tried to print and unhide workbook, but it's acting as if there's no workbook open. I think this has something to do with the updated software from this week.
Will my Excel & Word Files work on the newest OS for MAC? I know MAC has Microsoft Word and Excel but if I save all my files to a flash drive will I be able to transfer them to the MAC and will they work? This is why Im nervous about getting a mac.... All my Excel and Word files are the older version of MS OFFICE 97-2003 format.
I have got an email with an attached zip file. When I downloaded it to my computer it became a text ed file. This file contacts lots of names and addresses that I would like to make mailing labels for. To do that, I must merge it to excel.
I have been working on an Excel file for the last month continuously saving at every moment.Â At some point something happened and the file name now included a (version 1) after the original file name.Â I didn't worry about that because I was able to work on the file and keep on saving my work.Â I did some changes yesterday and saved it.Â All of a sudden I got a message that there was an upgrade ready to be installed at night.Â So I saved the file and did the upgrade. my file was nowhere to be found.Â I keep looking at Finder and I can only find a file with a similar name not the one with the (version 1) on it.Â I opened that file but it doesn't include any of the changes and updates I have done in the last month.Â I never deleted the file and I have double checked on the Trash and its not there.Â Is there a way to recover my file?Â The only thing that I did differently was that I completely powered of my mac as opposed to just closing it.Â
I work on Excel files through my Office Mac program. On two occasions, a large Excel file, (about 1.5 MB) will not save and is not recoverable. It gives me an error code -43. I work on many such files without problem, but this has now happened on two occasions with important files.
Why can't I attach a file to an email unless I export it to Word or Excel?Â
If I create a file in Pages, Numbers, or Keynote and save it to my documents, I can't attach that file to an email. It says the file cannot be attached. If I go back to the file and export to Word or Excel, It will attach to the email. How can I fix this?