LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 1
Default Setting up a word-count inventory for my novel

Hi, as per the title, I'm halfway though my first novel and I would like to automate the process of tracking my cumulative word count.

I have a manual spreadsheet that works for me, but ideally I would like the data to fly from Word straight into Excel as follows:

1. Enter shortened title into Column A (usually the first line of a chapter or section)
2. Enter the word count of that file into Column C

The total will be calculated by the formula sum(c:c).

I'm using Office Starter, so perhaps I need a third party work-around, I don't know. Appreciate some pointing in the right direction.

I should add, in case it's unclear, I'm referring to the word-counts of individual files. I can't seem to make Windows 7 list the word-counts in Windows Explorer, even though there is a Details column for this purpose. So I'd like Excel to peak inside the document file, read the word-count and the title and add them to the spreadsheet as described above.

Last edited by FretLess : July 6th 13 at 11:35 AM Reason: Clarity, I hope.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting up Inventory S.H.C New Users to Excel 3 September 24th 08 07:27 AM
INVENTORY CYCLE COUNT IN EXCEL SSJ New Users to Excel 3 March 21st 07 06:16 PM
INVENTORY STOCK COUNT vandy Excel Worksheet Functions 7 December 15th 06 12:20 AM
Folder Inventory & Count for like named files theDude[_19_] Excel Programming 0 August 2nd 05 01:23 AM
add an inventory item to a word doc if there is a Y in column C fitful_thought Excel Programming 2 July 19th 04 01:59 AM


All times are GMT +1. The time now is 02:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"