473,395 Members | 1,702 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

MS-Word: Special auto-numbering using vba

2
I have a word document that contains a table. The table has 2 columns and hundreds of rows.
I want to number the items in the table in the following way:
In the first column, each cell will contain one item that will be numbered as the regular ms-word auto-numbering goes.
In the second column, each item will be outline numbered sequentially, with the number in the column from left leading to it.
For example, in the left column the single item in the cell is numbered as "1." - in the next cell to this cell from right, I want each item\row to be auto-numbered as: "1.1", "1.2", "1.3", "1.4" etc. in the next row, the left cell is numbered as "2.", and in the right cell, the items will be numbered as: "2.1", "2.2", "2.3", "2.4", "2.5" etc.

How to do this?

Thanks
Dec 11 '06 #1
6 3915
Coldfire
289 100+
I have a word document that contains a table. The table has 2 columns and hundreds of rows.
I want to number the items in the table in the following way:
In the first column, each cell will contain one item that will be numbered as the regular ms-word auto-numbering goes.
In the second column, each item will be outline numbered sequentially, with the number in the column from left leading to it.
For example, in the left column the single item in the cell is numbered as "1." - in the next cell to this cell from right, I want each item\row to be auto-numbered as: "1.1", "1.2", "1.3", "1.4" etc. in the next row, the left cell is numbered as "2.", and in the right cell, the items will be numbered as: "2.1", "2.2", "2.3", "2.4", "2.5" etc.

How to do this?

Thanks
there exists a solution but still u have to work through it.....well i will tell u wht i have tried:
i made the two columns as

col1 | col2
-------------------------------------------
1 a | a
| b
| c
| d
| c
-------------------------------------------
2 b | a
| b
........
........

Now what i have done is selected the whole cell 1 and col 2's enteries
as
"a
b
c
d
c"
Numbered them > double click the first number (to modify the numbering scheme) > Goto Tab "Outlined Number" and Click Any scheme > press Customize > Delete everything on "Number Format" and then choose "Number Style" as 1,2,3 .....atonce the "Number Format" will display 1 in a gray shade > Now goto "Number Format" and press Home and type 1. (1 dot) that will become 1.1(with the second 1 shaded) >
Select Level as 2 on the left > Delete everything on "Number Format" and then choose "Number Style" as 1,2,3 .....atonce the "Number Format" will display 1 in a gray shade > Now goto "Number Format" and press Home and type 1. (1 dot) that will become 1.1(with the second 1 shaded)

Select Level as 3 on the left > Delete everything on "Number Format" and then choose "Number Style" as 1,2,3 .....atonce the "Number Format" will display 1 in a gray shade > Now goto "Number Format" and press Home and type 1. (1 dot) that will become 1.1(with the second 1 shaded)
well this is enough now press OK and see the result


To apply on further cells u have to do the same above steps


hope that helps
Dec 11 '06 #2
Coldfire
289 100+


To apply on further cells u have to do the same above steps


hope that helps
to apply further ....u can just copy the numbering properties and paste on the next cell enteries.....and make some changes as per required (by changing the numbering index "Start at" by 1 and then periodically changing the first index by 2 i.e.
2.1 (Level 1)
2.1 (Level 2)
2.1 (Level 3)

....u get the point ;)
Dec 11 '06 #3
Killer42
8,435 Expert 8TB
Please ignore my post here. I just wanted to add this thread to my "subscribed" list so I can keep an eye on how it goes. I'm hoping to learn something myself about working with tables in VBA.
Dec 11 '06 #4
Coldfire
289 100+
I have a word document that contains a table. The table has 2 columns and hundreds of rows.
I want to number the items in the table in the following way:
In the first column, each cell will contain one item that will be numbered as the regular ms-word auto-numbering goes.
In the second column, each item will be outline numbered sequentially, with the number in the column from left leading to it.
For example, in the left column the single item in the cell is numbered as "1." - in the next cell to this cell from right, I want each item\row to be auto-numbered as: "1.1", "1.2", "1.3", "1.4" etc. in the next row, the left cell is numbered as "2.", and in the right cell, the items will be numbered as: "2.1", "2.2", "2.3", "2.4", "2.5" etc.

How to do this?

Thanks
well ...the solution i gave has nothing todo with vba..sorry !!!
Dec 12 '06 #5
Killer42
8,435 Expert 8TB
well ...the solution i gave has nothing todo with vba..sorry !!!
Oops! :) I hadn't gone through the messages in detail as yet.

I may still learn something about Word, anyway.
Dec 12 '06 #6
orit
2
Thanks a lot,
I would like to make sure that I understand, In your example, the auto-numbering is only on the second column (col 2) - the numbering in col 1 are entered manually?
If yes - Is there a way that both columns will be auto-numbered separately?
If no (In your example both columns are auto-numbered) - can you please clarify how?

Thanks
Dec 18 '06 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Christian McArdle | last post by:
REQUEST FOR DISCUSSION (RFD) unmoderated group comp.os.ms-windows.programmer.win64 This is a formal Request For Discussion (RFD) to create comp.os.ms-windows.programmer.win64 as an unmoderated...
0
by: Christian McArdle | last post by:
REQUEST FOR DISCUSSION (RFD) unmoderated group comp.os.ms-windows.programmer.win64 This is a formal Request For Discussion (RFD) to create comp.os.ms-windows.programmer.win64 as an unmoderated...
3
by: Christian McArdle | last post by:
REQUEST FOR DISCUSSION (RFD) unmoderated group comp.os.ms-windows.programmer.64bit This is a formal Request For Discussion (RFD) to create comp.os.ms-windows.programmer.64bit as an unmoderated...
18
by: Rob R. Ainscough | last post by:
MS Visual Studio Ad contained in VS Magazine. Two developers in "hip" clothing diagramming out a huge flow chart on a beach. I could NOT stop laughing at the stupidity of the ad -- "Let your...
3
by: mehrdad | last post by:
Hi, I have a fully functional MS-Access database. May I build such an "exe" file from a MS-Access "mdb" file which one who has not MS-Access installed on his/her system can take advantage of the...
92
by: Jeffrey P via AccessMonster.com | last post by:
Our IT guys are on a vendetta against MS Access (and Lotus Notes but they've won that fight). What I can't understand is, what's the problem? Why does IT hate MS Access so much. I have tried...
0
by: com | last post by:
MS Access 2000 Password Recoverer 4.2 Screenshot - Soft30.com MS Access 2000 Password Recoverer will display the password to a MS Access database (*.mdb). This program works for MS Access files...
7
by: Joe Ross | last post by:
I've been working with Microsoft support for over 3 weeks now on an intermittent General Network Error we're seeing in our production environment between our ASP.NET application and SQL Server...
22
by: Jordan S. | last post by:
SQL Server will be used as the back-end database to a non trivial client application. In question is the choice of client application: I need to be able to speak intelligently about when one...
5
by: Ted | last post by:
I am working on two versions of an application, one of which will be a windows forms application (which will need to be redistributable) and the other will be a web application. I have MS Visual...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.