The definition of insanity...

[deathpixie]

Remember months ago when I was venting about the high density filing project and my co-worker who couldn't understand the need for central record keeping? And how B and I wound up going through the whole thing by hand since H's 'records' were out of date and crap and done on Word instead of the Excel spreadsheet provided to her

Comments

[chandri]

*sigh* Some people just don't understand the beauty of spreadsheets.

[acetal]

I *love* spreadsheets.

You have my sympathies, Rossi (and my axe!).

Having to reconcile things over and over again and is a real pain in the ass. It's also demoralising and frustrating to spend a lot of time keeping on explaining simple things that people should be familiar with and trying to find new ways to explain as they look at you blankly and continue not to get it.

If she at least put things in columns in Word or separated things with tabs or spaces, it may be possible to transfer it across into a spreadsheet without reentering all the information. Depending on which version of Word you're using, it'd be under something like Insert -> Table -> Convert Text To Table
Highlight the data you want to convert into a table, select Convert Text To Table as per above, make sure the number of columns and rows is correct and what it uses to pick what to separate data into cells by. If it's spaces, then select Other and do a space. Once you've got your table set up, copy and paste it into Excel.

Might not help, but is useful to know

[deathpixie]

I finally got to see what format she has and it's just a Word document. Without half the information needed (like shelf location, year, that sort of thing). Fortunately, it's only one file on the shelf, so she's added it to the spreadsheet now and hopefully she'll know better once her lawyer retires and we clear out his office.