Is 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
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!!
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 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
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 Replies View RelatedI 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 opened a new file in textedit, put in a basic html code, <html> and </html> saved it as an html file then when I opened it in safari i see exactly what I'd typed in.
View 3 Replies View RelatedIs there any better way of exporting a Pages document to HTML, other than exporting to RTF then exporting again to HTML? This approach works, but it produces odd-looking output that needs some manual editing.
View 1 Replies View RelatedI am trying to figure out how to embed a pdf file into an excel spreadsheet for work. I keep having to wait for someone with a pc to do it for me and its driving me crazy.
Info:
Microsoft Office, Mac OS X (10.7.2)
I'm not familiar with how to use Automator, Here's what I want to do: How can I open a specific Microsoft Excel document just by pressing a function key or some combination of keys? I'd like to be able to do this from any program.
View 3 Replies View RelatedHow do I do it? I want the document to require a password to open. I did the tools-->protection--protect workbook/sheet thing but that didn't do it, the document could still be opened, just not edited. I have a budget sheet with all of my online account passwords I don't want accessible if the computer gets stolen.
View 3 Replies View RelatedSince the last OS X update (yesterday), I am unable to print any document in Excel or Word (2004 or v11.6.2). The print window does not open. It opens in Excel (2011 or v14.0) or any other app.
View 3 Replies View Related1. In MS Word on PC you can get to the top of a document using a shortcut ctrl+pgup. How can can this be achieved in Word under Mac?
2. In Excel on PC you get to the contents of a cell pressing F2. What is the method in Excel under Mac?
Info:
MacBook Pro
Since updating to Lion, Word and Excel open the last opened document when I start the program. How do I disable this?
Info:
MacBook Pro, Mac OS X (10.7.2)
Can contacts from your address book be exported into an excel document.
Info:
MacBook Pro (13-inch Late 2011)
Error: Cannot open document created in Microsoft Excel for the Macintosh version 1.x Solution Found: [URL]
Problem: I don't have my old Excel (or at least I can't find it). I do still have my old copies of Office 95 for PC but that doesn't seem to open it either. Probably because back in the day, it wasn't directly compatible. What I need is to be able to open this file in something and get it converted to OpenOffice, Office X or Office 2003.
How do I move a document from my MacBook Pro to my iPad?
Info:macbook pro, Mac OS X (10.4.5)
I just got a Mac Pro with a 250GB SSD drive and 2 1TB drives. I planned to use the 250GB drive for the OS and the other two drives for all my data. How do I move the location of Documents, Music, Pictures...? In Windows, you can move the folder location, but I'm not sure if you can do this w OSX.
If this isn't possible, what's the best way to keep my data off the 250GB drive?
When using Excel "microsoft Office" I find on my desktop files that I am unable to task, move or relocate. How can I clear my desktop?
Info:
iMac, Mac OS X (10.7.3), Microsoft Office
Why doesn't the original document I'm dragging and dropping from one folder to another move? What's happening is the computer is creating a duplicte of the document and placing it in the new location with a new creation date. The original document I wanted to drag and drop into a new location remains where it started as the "original" document and the new copy has this little arrow protruding up from the lower left of its icon. At first I thought it was an alias, but it's a copy of the document I thought I was dragging and dropping.
Info:
MacBook Pro, Mac OS X (10.7.2), 20" Apple Cinema Screen, Safari 5.Mail, Address Book 5.
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...
how to embed an image with a link, or embed a Microsoft Word document with a hyperlink built within the document -- not as an attachment into my email -- but where it shows as the email content when opened! Does ANYONE know the secret? Can it be done, or not? My PC clients do it all the time easily. Then I want to be able to send the embedded image/document (not as an attachment, but visable within the email when opened) to many email contacts at once, BUT the individuals receiving them DO NOT SEE the other email contacts.
Info:
MacBook Pro, Mac OS X (10.7.2)
