Month and Numbered Sequence Columns in a Table


W

wolf_tracks

I'd like to have two columns in a table. One should start at a date like
Sept. 17, 2009 and continue to the end of the column. The other should
start the first cell with 1, second cell with 2, etc. to the end. How
does one do that?
--
Wayne Watson (Watson Adventures, Prop., Nevada City, CA)

(121.015 Deg. W, 39.262 Deg. N) GMT-8 hr std. time)
Obz Site: 39° 15' 7" N, 121° 2' 32" W, 2700 feet

Solid waste produced to generate electricity per person
over a lifetime:
Nuclear power -- 2 pounds in a coke can
Fossil (coal) fuel -- 68.5 tons in six 12-ton RR cars

-- Power to Save the World, Gwyneth Cravens

Web Page: <www.speckledwithstars.net/>
 
Ad

Advertisements

T

Terry Farrell

One does this in Excel and then copies the resultant table into Word. Excel
has AutoFill tools that will create the Date sequence. Both Word and Excel
are capable of numbering.
 
H

Herb Tyson [MVP]

I'm not sure what you want. Do you want something like this:

Sept. 17, 2009 1
Sept. 18, 2009 2
Sept. 19, 2009 3

or do you want something like this:

Sept. 17, 2009 1
2
3

?

For the former, click the table tool and drag it down so that you have a 2
by x table, where x is the number of rows.

For the latter, do the same thing, but then select all of the cells in the
first column and merge them. You would want to set the vertical alignment
for the first column to top. (To merge: Select the cells, right-click the
selection, then click Merge Cells.)

If you want a hybrid--where date changes, but less often than the cells in
the 2nd column, then group cells in the left column as desired, and merge
each group.

--

Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com
 
W

wolf_tracks

Herb said:
I'm not sure what you want. Do you want something like this:

Sept. 17, 2009 1
Sept. 18, 2009 2
Sept. 19, 2009 3

or do you want something like this:

Sept. 17, 2009 1
2
3

?

For the former, click the table tool and drag it down so that you have a
2 by x table, where x is the number of rows.

For the latter, do the same thing, but then select all of the cells in
the first column and merge them. You would want to set the vertical
alignment for the first column to top. (To merge: Select the cells,
right-click the selection, then click Merge Cells.)

If you want a hybrid--where date changes, but less often than the cells
in the 2nd column, then group cells in the left column as desired, and
merge each group.
The first one, but like:
Sept. 17, 2009 1
18 2
19 3

That's probably a bit difficult, so I'd settle for it as it is; however,
I don't see above the manner in which you fill the cells in a column. In
Excel it's something like grabbing a corner of the first cell, then
dragging it down. I couldn't a find a way to do that in Word's tables.
--
Wayne Watson (Watson Adventures, Prop., Nevada City, CA)

(121.015 Deg. W, 39.262 Deg. N) GMT-8 hr std. time)
Obz Site: 39° 15' 7" N, 121° 2' 32" W, 2700 feet

Solid waste produced to generate electricity per person
over a lifetime:
Nuclear power -- 2 pounds in a coke can
Fossil (coal) fuel -- 68.5 tons in six 12-ton RR cars

-- Power to Save the World, Gwyneth Cravens

Web Page: <www.speckledwithstars.net/>
 
D

Doug Robbins - Word MVP

Run a macro containing the following code when the selection is located
inside the table that you want populated in that manner.

Dim atable As Table, i As Long
Set atable = Selection.Tables(1)
StartDate = InputBox("Enter the Starting Date.")
If IsDate(StartDate) Then
For i = 0 To atable.Rows.Count
atable.Cell(i + 1, 1).Range.Text = Format(DateAdd("d", i,
StartDate), "MMM dd, yyyy")
atable.Cell(i + 1, 2).Range.Text = i + 1
Next i
End If


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
 
Ad

Advertisements

H

Herb Tyson [MVP]

As Doug indicates, you'd need a macro. Word does not autofill cells. I
didn't realize you wanted automatic filling--I thought you were looking for
how to create the table structure, not how to generate cell contents. For
what you want, I would start in Excel, then copy/paste the table into Word.

--

Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top