A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Adding dates in a serial fashion



 
 
Thread Tools Display Modes
  #1  
Old November 16th, 2005, 08:19 PM posted to microsoft.public.word.tables
external usenet poster
 
Posts: n/a
Default Adding dates in a serial fashion

I'm working with a table that spans several pages in Word 2003 in which I
want to insert dates much like a numbered list. Also, this table will have
data that will be moved around within the table. I'm looking to be able to
have the dates update automatically if they are moved around. To help
explain, here's a before-and-after example:
1 11/16/05 1
11/16/05
2 11/17/05 - if I delete this row I want - 2
11/17/05
3 11/18/05

- A two-column three-row table, as shown above; first column has a number
list 1, 2, & 3 using the autonumbering function (if that's the term for it...
it's the toolbar button)
- Second column has dates mm/dd/yy from say 11/16/05 - 11/18/05
Typically, what would happen to the number list if I were to delete row 2,
is row three would shift upwards and the list number would then become "2"
instead of "3". I'm looking for this same functionality with the dates I put
in the cells, so if I were to delete row 2 from the table, the number, date,
and contents of any other cells on that row would stay together and move up.
I hope I made my problem clear.

I've searched through all 21 pages of this forum and could not find anything
posted about this. Any ideas?

Thanks much,
Russ
  #2  
Old November 16th, 2005, 08:27 PM posted to microsoft.public.word.tables
external usenet poster
 
Posts: n/a
Default Adding dates in a serial fashion

Hi Russ,

You could spend a completely ridiculous amount of time forcing this to work
in Word with macros, and it probably would never work right anyway.

Instead, do it in Excel, which has the necessary cell formulas and
formatting controls. If you need to make it part of a Word document, copy
the Excel spreadsheet and paste-link it into Word. The hardest part is that
you'll probably have to link one page worth at a time, since Word can't
spread inserted objects across page breaks.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org

Russ wrote:
I'm working with a table that spans several pages in Word 2003 in
which I want to insert dates much like a numbered list. Also, this
table will have data that will be moved around within the table. I'm
looking to be able to have the dates update automatically if they are
moved around. To help explain, here's a before-and-after example:
1 11/16/05
1 11/16/05
2 11/17/05 - if I delete this row I want - 2
11/17/05
3 11/18/05

- A two-column three-row table, as shown above; first column has a
number list 1, 2, & 3 using the autonumbering function (if that's the
term for it... it's the toolbar button)
- Second column has dates mm/dd/yy from say 11/16/05 - 11/18/05
Typically, what would happen to the number list if I were to delete
row 2, is row three would shift upwards and the list number would
then become "2" instead of "3". I'm looking for this same
functionality with the dates I put in the cells, so if I were to
delete row 2 from the table, the number, date, and contents of any
other cells on that row would stay together and move up. I hope I
made my problem clear.

I've searched through all 21 pages of this forum and could not find
anything posted about this. Any ideas?

Thanks much,
Russ



  #3  
Old November 16th, 2005, 08:38 PM posted to microsoft.public.word.tables
external usenet poster
 
Posts: n/a
Default Adding dates in a serial fashion

Russ,

No promises as I didn't test with your specific requirements. You
might be able to use my Date Sequencer Add-in for this purpose. See:

http://gregmaxey.mvps.org/Date_Sequencer.htm

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Averaging a Value between Two Serial Dates ChrisM New Users 1 November 16th, 2005 04:09 AM
Averaging Value between Two Serial Dates ChrisM Links and Linking 1 November 16th, 2005 01:25 AM
Calculating number of days between two dates that fall between two other dates [email protected] General Discussion 5 October 26th, 2005 06:18 PM
I can't remove the dates from Visio Tom Rippert Visio 0 March 25th, 2005 07:02 PM
Adding dates Natalie Worksheet Functions 1 March 18th, 2005 10:54 AM


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


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.