Author |
Message |
   
Cynicalgirl
Citizen Username: Cynicalgirl
Post Number: 2257 Registered: 9-2003

| Posted on Wednesday, January 25, 2006 - 9:04 pm: |    |
I'm trying to make an excel sheet showing our extensive family medical expenses. I have a nice printout from the pharmacy of all expenditures, but it would be helpful if I could copy/paste to excel (or similar) all of the claims we have in Aetna's Navigator thing. Then I could more easily sort and run totals. To me, it looks a lot like my online banking statement, but doesn't immediately offer an export to excel or Quicken. Is there an easy way to do this? I tried a save as, but all of the options seemed web oriented or unicode or ?? and I feared getting a mess of formatting code I didn't want. Thanks a bunch. |
   
kdm
Citizen Username: Kdm
Post Number: 76 Registered: 10-2002
| Posted on Friday, January 27, 2006 - 1:13 pm: |    |
If you are viewing the Aetna data in a browser window you should be able to Select All (ctl-a) and then Copy (ctl-c) and Paste (ctl-v) into an Excel file. You might have to clean things up a bit but it sure beats re-typing. Also, sometimes it is better to first paste into Word and clean the data up. Then copy from Word to Excel. |
|