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?
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.
Every time I change the artist, iTunes changes the way my albums are sorted. It always reverts to sorting by album, alphabetically. How can I have it sort by year as to give the albums chronologically? I use grid view.
By default, the mailboxes in Apple Mail are sorted by Date Received, Oldest first. I tried sorting a few of my folders to be 'Newest First' instead, but I would have to do it for all of my folders, and I have about 150 folders.
What is the fastest way to sort all my folders to the way I want it?
I've recently decided its time to sort all my tv shows into iTunes so that I can access them easily in FrontRow. I've imported two seasons of a tv show and all the episodes are named correctly, numbered right, season info set up right etc. If I click the "TV Shows" section in iTunes I get two entries for my show, one for Season 1, one for Season 2. If I use Front Row, it simply gives me two entries for the tv show but I don't know what season it is until I click through. Surely there must be a way to have TV Shows -> Series -> Season? Otherwise this whole TV Shows thing will be useless to me since I'll end up having to scroll through loads of seasons for all my shows in one place on Front Row i.e. if I put all of my seasons of Enterprise and Stargate SG-1 then Front Row would show this under the TV Shows option:
For several days I have been unable to sign in to Microsoft Messenger. I have the leaked 8.0 version. I thought maybe it was a problem with the leaked beta but I can't sign in using aMSN either. I can sign in to web based substitutes like eBuddy, but it's still very annoying. Whenever I try to sign in on the actual application it just tries for awhile and then says the service is not available or you may not be connected to the Internet.
I'm trying to import iPhoto Events into Aperture through Aperture's built-in function (File->Show iPhoto Browser). But the Events are sorted alphabetically instead of by date. I can't figure out how to fix this. On a couple of occasions I've opened the iPhoto Browser to find it sorted by date, so I know it's possible. Was it a fluke or is there a workaround?
1. Operate cross platform (my IT guy�s PC, I�m Mac) 2. Sort capabilities to five, ideally six, levels 3. Capable of using macros 4. Can convert spreadsheets for an html (online) environment
I founded a national grassroots movement thats gone viral. We list registered supporters on our site, using Google Apps forms, the copy the content into an Excel spreadsheet. A friend out of state (PC user) is able to work magic with macros that magically sorts, fixes, and converts the lists to appear in our online directory (you can see an example at http://www.the350project.net/states/states_a-d.html). I created the graphics; he somehow builds the page using those plus the spreadsheets.
This is something I really need to be able to do on my end, as the owner of the site, but MS took macros out of the Mac version of Office Excel....OpenOffice only sorts three levels, and he says we need at least five....
Since I have no intention of becoming a PC user, I need to find a software program that will work on a Mac and still be able to do all this. I realize many (most?) software programs are capable of opening and saving .xls files, but the multi-level sort, macros, and html are critical to any of this working, according to him.
How do I get Aperture's built-in iPhoto browser to sort iPhoto Events by date? Over the last year I've switched from iPhoto to Aperture. I prefer iPhoto Events as an organizational scheme, sorted by date, so I am re-creating a chronological scheme with Aperture -- as many do. I've been gradually and selectively importing hundreds of iPhoto Events into Aperture Projects by dragging them from Aperture's built-in 'iPhoto Browser'. Here's the problem: Aperture's iPhoto browser shows Events, but they are annoyingly sorted alphabetically, rather than by date. This makes it a real pain to transition chronologically.
I can't find any control to re-sort by date. Inexplicably, on a couple of occasions I have opened the Browser to find it sorted by date! Temporarily rejoicing, it soon reverts to alphabetical after one session. WTF? I have a hunch these couple times were flukes, possibly having to do with iPhoto being open at the same time, I dunno. Still, I now know it's possible; and if it involves some weird workaround to re-create it, I'll do it. I'm running Leopard 10.5.8, Aperture 2.1.4, iPhoto 7.1.5.
I am using FCP 6.06, I imported video from two different video camcorders: Canon GL-2 mini-dv and a Sony Digital 8 TRV340. Importing from both of these cameras went pretty well, i had some dropped frames while importing, nonetheless it went pretty well. However, when i drop any of the footage into the timeline and I press play, it will play for a few seconds, hang up (spinning wheel) and then gives me a window that says: RT extreme has determined that these were caused by slow disks, please try: Increasing the speed of your disks, Decreasing the number of RT layers, Limiting your RT bandwith. AS of now i currently use a 1 TB Western Digital "My Book" for my scratch disk. I have tried everything I can think of and I am working on a Wedding video.
I've only recently added release years to all my albums and now I sort by album by year, which is great. However, I'd like to make some smart playlists based on decades, and this is a problem for anything on some sort of anthology or greatest hits collection. For example, the Barenaked Ladies greatest hits CD was released in 2001.
If I tag the whole album as 2001, it sorts correctly, but the individual tracks from the 90's won't show up in the 90's smart playlist. The other option I can think of is to tag each individual track with the correct year, but then the album stops appearing in the right place chronologically within the BNL albums, since iTunes no longer knows it was released in 2001.
So my question is this: is there some way to do a sort of "Sort Year" or "Album Year" similar to "Sort Artist" or "Album Year"?
And while I'm at it, I'm sure there's no way, but it seems like it'd be cool to somehow tie a track to two different albums. Previously, if I had a greatest hits and some original albums, I would erase any duplicates from the greatest hits and only keep them on the original album. However, since the release of iTunes 8 I use a more album-based approach to my music. I use grid view with shuffle off by default, and often just click "Play Album". But if I do that for a greatest hits comp, it of course won't play the tracks that I've deleted from it. So I have to keep two copies of the same recording for two different albums. It'd be cool if there was some way to tie one track to both albums to avoid dupes. But again, I'm pretty sure this'll never happen.
I know it's kind of silly, but is it possible to use Apple Mail's icon and sort of drag'n'drop it to use it on Entourage? I prefer Entourage as my email app, but find Apple Mail's ICON nicer, so would it be possible for my Entourage to use Apple Mail's icon in the dock?
I tried using Quicken for keeping a very basic digital copy of my check register, but I found Quicken's tendency of throwing all sorts of advanced options that I didn't want to use at me kind of unnerving. So, can anyone reccomend a check register-only finance app?
I work a lot in Excel for Mac and I have noticed an annoying feature that I can't seem to change. No matter how many times I save a document in "landscape" it keeps on reverting back to "portrait" every time I open it. I have tried to default to landscape but it has not worked.
There are absolutely no add-ins for Excel 2008 for mac! I really need the data analysis toolpak for school and work. Does anybody know if it's possible to download this toolpak from somewhere and install it? I've tried looking and have come up with nothing so far.
What I'd like is for a function that can sort the categories into individual columns for the categories. So that this big list of purchases I have is sorted out into their own column that matches the category and then sums it too. Does this make sense? I was sort of avoiding any VBA for this but if thats how it has to be done then thats cool
Most of my company is PC based, but we artists are Mac based. We all work on the same Excel file, updating, saving, replacing. When we open the PC excel file on our Macs, none of the hyperlinks work ... then if we save something to the file, when the PC guys open the file, none of the hyperlinks work for them anymore either. We really want to be able to use Excel and not have to use VMware in order to update our file on the Mac. Any thoughts??