Im currently using an Excel spreadsheet, but my business is expanding so I need to use something more functional. I have tried Sage and Quickbooks but didnt really like them, not to mention the price was ridiculous.
View 9 RepliesI 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!!
View 3 Replies View RelatedI 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
View 1 Replies View Relatedjsut bought an imac and am having problems converting old pc excel files to pdf's. the last column keeps getting cut off.
Info:
hp, Windows Vista
I have an excel spreadsheet that I can't delete. It says that it is being used and I can't delete it.
View 7 Replies View RelatedIs there an affordable app that will move an Excel spreadsheet into an html document without losing the format? Or a method of doing it? I've done it before but can't remember how I did it.
View 1 Replies View RelatedHow do i convert a excel spreadsheet to be compatible with a mac?
View 1 Replies View RelatedWhy is my mac running slow, especially with excel spreadsheet?
Info:
MacBook Pro
I have spent the last few hours trying every solution that is supposedly available for converting VCF files to an xls file. WHY can't this be an option in the Contacts program? I need to upload some contacts to Constant Contact. Come on! Really! There must be an answer that doesn't require me to convert two - three times before I can use the files.
Info:
Contacts
I would like to transfer my contacts from address book to an excel spreadsheet. Is this possible.
Info:
iMac (27-inch Mid 2011)
How can I resize my spreadsheet so that it fits in the office for Mac excel spreadsheet when opening an existing windows file? Last column goes to another page.
Info:
MacBook Air, Mac OS X (10.7.4)
I transferred excell spreadsheet from my old pc to my new mac. I used it last fortnight but now cannot find it.
I have tried Spotlight but to no avail I have an Imac.
Info:
iMac, OS X Mavericks (10.9.4)
My father owns one of the original G5s, so its power pc not intel. Today while browsing an excel spreadsheet he says part of the screen turned black, then the monitor shut off, then the monitor came back on but not video. Mean while the fans started spinning out of control. Now when he tries to turn it on, he gets power, but all that happens is the fans spinning faster and faster and faster until he turns it off. No video or anything. Just speeding fans. He fears the CPUs died since they control the fans. Any suggestions? He also says the fans were spinning unusually fast these last few days.
View 6 Replies View RelatedI am searching for template(s) for Mac Office Excel or Word for invoice(s)? Are templates available for iWork - Numbers that are easy and functional? I send some electronically and receivers do not have Apple. Can Numbers templates be viewed by them?
View 3 Replies View RelatedI just introduced my mother to the world of Mac and she is looking for a personal accounting software program. She has been using Quicken for YEARS but is ready to change to something.
View 5 Replies View Relatedvery small business. He is an artist and I have offered to help him manage his expenses, billing, invoices etc.
View 5 Replies View RelatedI've just got a new iMac, run a small limited company and am VAT registered, based in the UK...just wondering which accounting software is best? There doesn't seem to be many reviews on the web so thought
View 2 Replies View Relatedstarting a new small business and need some first hand advice. have seen bad write-ups on quickbooks 2009 for mac and so-so opinions for myob. what about quickbooks 2010 coming out soon?
View 4 Replies View RelatedWe've been running Clients & Profits for the longest time in our Mac-only office. Frankly it sucks, and we are looking toward something with less of a learning curve for potential accounting employees whose experience mostly seems to center around Quickbooks. Looking at Quickbooks for Mac, it is clearly not the same thing and I don't think it suits our needs. We need something where all users can access the database and add time, create POs and invoices, etc, but at the same time isn't foreign to someone trained in Quickbooks. Does this exist??
View 3 Replies View RelatedI 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 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.
View 4 Replies View RelatedI've created a spreadsheet for budgeting purposes and to keep track of my money (student). I know that on certain days (like Payday) the amount I will be paid and obviously the date. I want to be able to put this in my table but not to be added to the formula until that date is passed or met.
For Instance, If I get paid on 01/09/10 and put this in my table, the formula will add this amount to the total income for the month of September. The funds have not actually been paid to me however, so they need to be excluded until they are paid i.e on the 01/09/10.
I spend my working life in Excel 2007 and I just can't bring myself to replace my home budget spreadsheet to a true numbers format.
View 5 Replies View RelatedWould anyone have one of these or be able to point me in the right direction for one? I don't mind having to pay for it.
View 3 Replies View RelatedI need a spreadsheet program that can:
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.
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.
View 2 Replies View RelatedWe have a couple of systems running 10.6.4. While the Cut function (Cmd+X) works in the applications, it's nonfunctional (grayed out) while in Finder. I'd really like to use Cut/Paste rather than dragging when moving files, as there's less chance for accidentally dropping them where they don't belong. Anyway, I can't seem to find how to make Cut functional.
View 3 Replies View RelatedI'm new to mac and I heard somewhere that if you have another mac computer then you can transfer you programs to your new one. My church has an iMac with Pro-Presenter, and Final cut on it. Could I get those on my computer but the program still be functional on the other one as well?
View 5 Replies View RelatedI have a new MacBook Pro (100% up to date) and when i click links for PDFs, Safari opens up a new tab and the whole tab is a darker grey color and the PDF never displays. I have followed many suggestions of deleting this AdobePDFViewer file but unfortunately I do not possess it. So I downloaded Adobe Reader and installed it. I set it to not be the default and to not open PDFs from Internet. I deleted Adobe Reader and then I found the AdobePDFViewer file and I also deleted that. But I still can not view PDFs in Safari.
View 2 Replies View Related