Hi.
In brief, I am trying to sort a group of tables (1,200 odd) into an order determined by the contents of row(1), cell(1) and would appreciate any help given.
Below is the detailed situation. Apologies in advance for its length.
I am trying to import three database tables (each is a list of table attributes). I then need to sort the tables based on the table name, fill in any missing duplications (as explained below), reformat the layout and automate the lot based on dialog box input.
I started six weeks ago part-time with very basic VBA skills (macro record button knowledge only). I've been full-time on this for the last two weeks and I have since solved most of the issues EXCEPT the sorting aspect. My VBA is heaps better now but I cannot get beyond the sorting of the first two tables and as time is now becoming critical, I'm hoping someone can offer some assistance.
TIA if you can.
Here is the current situation in regards to the tables:
I have imported three database tables into Word 2000.
For example:
GroupA - 4 columns: tbl_name, col_name, col_num, desc
GroupB - 3 columns: tbl_name, col_name, desc
GroupC - 3 columns: tbl_name, col_name, desc
Each table consists of many rows.
Using VBA I have split the tables based on the content of column(1). This has created a number of separate tables as follows:
GroupA-Table1
GroupA-Table2
GroupA-Table3
GroupA-Table4
GroupB-Table1
GroupB-Table2
GroupB-Table5
GroupB-Table6
GroupC-Table1
GroupC-Table2
GroupC-Table5
GroupC-Table7
Now I need to group them by their table names [column(1)].
The end product then needs to have a placeholder table inserted where a table is missing.
The end result needs to be as follows:
GroupA-Table1
GroupB-Table1
GroupC-Table1
GroupA-Table2
GroupB-Table2
GroupC-Table2
GroupA-Table3
GroupB-Table3 - placeholder table needed
GroupC-Table3 - placeholder table needed
GroupA-Table4
GroupB-Table4 - placeholder table needed
GroupC-Table4 - placeholder table needed
GroupA-Table5 - placeholder table needed
GroupB-Table5
GroupC-Table5
GroupA-Table6 - placeholder table needed
GroupB-Table6
GroupC-Table6 - placeholder table needed
GroupA-Table7 - placeholder table needed
GroupB-Table7 - placeholder table needed
GroupC-Table7
Sorry for the long-winded explanation which I hope explains the situation clearly.
Again, TIA for any help offered.
Regards,
Bruce
In brief, I am trying to sort a group of tables (1,200 odd) into an order determined by the contents of row(1), cell(1) and would appreciate any help given.
Below is the detailed situation. Apologies in advance for its length.
I am trying to import three database tables (each is a list of table attributes). I then need to sort the tables based on the table name, fill in any missing duplications (as explained below), reformat the layout and automate the lot based on dialog box input.
I started six weeks ago part-time with very basic VBA skills (macro record button knowledge only). I've been full-time on this for the last two weeks and I have since solved most of the issues EXCEPT the sorting aspect. My VBA is heaps better now but I cannot get beyond the sorting of the first two tables and as time is now becoming critical, I'm hoping someone can offer some assistance.
TIA if you can.
Here is the current situation in regards to the tables:
I have imported three database tables into Word 2000.
For example:
GroupA - 4 columns: tbl_name, col_name, col_num, desc
GroupB - 3 columns: tbl_name, col_name, desc
GroupC - 3 columns: tbl_name, col_name, desc
Each table consists of many rows.
Using VBA I have split the tables based on the content of column(1). This has created a number of separate tables as follows:
GroupA-Table1
GroupA-Table2
GroupA-Table3
GroupA-Table4
GroupB-Table1
GroupB-Table2
GroupB-Table5
GroupB-Table6
GroupC-Table1
GroupC-Table2
GroupC-Table5
GroupC-Table7
Now I need to group them by their table names [column(1)].
The end product then needs to have a placeholder table inserted where a table is missing.
The end result needs to be as follows:
GroupA-Table1
GroupB-Table1
GroupC-Table1
GroupA-Table2
GroupB-Table2
GroupC-Table2
GroupA-Table3
GroupB-Table3 - placeholder table needed
GroupC-Table3 - placeholder table needed
GroupA-Table4
GroupB-Table4 - placeholder table needed
GroupC-Table4 - placeholder table needed
GroupA-Table5 - placeholder table needed
GroupB-Table5
GroupC-Table5
GroupA-Table6 - placeholder table needed
GroupB-Table6
GroupC-Table6 - placeholder table needed
GroupA-Table7 - placeholder table needed
GroupB-Table7 - placeholder table needed
GroupC-Table7
Sorry for the long-winded explanation which I hope explains the situation clearly.
Again, TIA for any help offered.
Regards,
Bruce