So I have this government document, where the first section(s) must have page 
numbering at the bottom that relates to the headings (i.e., 2.3-18 where 2.3 
is Heading 2 style and 18 is the current page of the entire document. 

However, when it comes time for tables in the document, I need to maintain 
the numbering at the bottom per previous sections, but ADD numbering at the 
top that says "Sheet 1 of 5," that calculates the pages in the table (section 
breaks before and after, used SectionPages field). 

Two different sets of numbers, different formats, same page. 

I have tried Seq variables, PageRef fields, but any time I change the footer 
format to include the Heading, it changes my Sheet numbering to have a 
Heading as well. 

Tell me it can't be done. 

There are three header/footers associated with each section (First Page, 
Primary and Even Pages).
Insert a section break before the table and break the link between the 
header of that section and the previous section. Put what you require in the 
appropriate header/footers of each section.

-- 
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


"That70sHeidi" <That70sHeidi@discussions.microsoft.com> wrote in message 
news:98857FD6-49E1-4B18-8337-1E972E34ABCF@microsoft.com...
> So I have this government document, where the first section(s) must have 
> page
> numbering at the bottom that relates to the headings (i.e., 2.3-18 where 
> 2.3
> is Heading 2 style and 18 is the current page of the entire document.
>
> However, when it comes time for tables in the document, I need to maintain
> the numbering at the bottom per previous sections, but ADD numbering at 
> the
> top that says "Sheet 1 of 5," that calculates the pages in the table 
> (section
> breaks before and after, used SectionPages field).
>
> Two different sets of numbers, different formats, same page.
>
> I have tried Seq variables, PageRef fields, but any time I change the 
> footer
> format to include the Heading, it changes my Sheet numbering to have a
> Heading as well.
>
> Tell me it can't be done. 

Already have Section Breaks applied. 

Header of Section 4 needs to say Sheet 1 of 8.
Footer of Section 4 needs to say 2.8-14. 
On the same page.

Even with the codes I mentioned earlier, I cannot make the footer use one 
form of page number without the header reflecting that. If I want the footer 
to use Heading 2, then my Sheet number will use Heading 2 as well. 

"Graham Mayor" wrote:

> There are three header/footers associated with each section (First Page, 
> Primary and Even Pages).
> Insert a section break before the table and break the link between the 
> header of that section and the previous section. Put what you require in the 
> appropriate header/footers of each section.
> 
> -- 
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> Graham Mayor -  Word MVP
> 
> My web site www.gmayor.com
> Word MVP web site http://word.mvps.org
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> 
> 
> "That70sHeidi" <That70sHeidi@discussions.microsoft.com> wrote in message 
> news:98857FD6-49E1-4B18-8337-1E972E34ABCF@microsoft.com...
> > So I have this government document, where the first section(s) must have 
> > page
> > numbering at the bottom that relates to the headings (i.e., 2.3-18 where 
> > 2.3
> > is Heading 2 style and 18 is the current page of the entire document.
> >
> > However, when it comes time for tables in the document, I need to maintain
> > the numbering at the bottom per previous sections, but ADD numbering at 
> > the
> > top that says "Sheet 1 of 5," that calculates the pages in the table 
> > (section
> > breaks before and after, used SectionPages field).
> >
> > Two different sets of numbers, different formats, same page.
> >
> > I have tried Seq variables, PageRef fields, but any time I change the 
> > footer
> > format to include the Heading, it changes my Sheet numbering to have a
> > Heading as well.
> >
> > Tell me it can't be done. 
> 
> 
> .
> 

To get the 2.8, insert a cross-reference to the paragraph number and after 
it, insert the hyphen and a { Page } field.

To get the 1 of the 1 of 8, you are going to need to insert some bookmarks 
at the end of each section thenand use some field maths to subtract the 
PageRef of the bookmark from a { page } field

-- 
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

"That70sHeidi" <That70sHeidi@discussions.microsoft.com> wrote in message 
news:3CD9917D-6909-4EA8-B85A-719A700CE55B@microsoft.com...
> Already have Section Breaks applied.
>
> Header of Section 4 needs to say Sheet 1 of 8.
> Footer of Section 4 needs to say 2.8-14.
> On the same page.
>
> Even with the codes I mentioned earlier, I cannot make the footer use one
> form of page number without the header reflecting that. If I want the 
> footer
> to use Heading 2, then my Sheet number will use Heading 2 as well.
>
> "Graham Mayor" wrote:
>
>> There are three header/footers associated with each section (First Page,
>> Primary and Even Pages).
>> Insert a section break before the table and break the link between the
>> header of that section and the previous section. Put what you require in 
>> the
>> appropriate header/footers of each section.
>>
>> -- 
>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>> Graham Mayor -  Word MVP
>>
>> My web site www.gmayor.com
>> Word MVP web site http://word.mvps.org
>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>>
>>
>> "That70sHeidi" <That70sHeidi@discussions.microsoft.com> wrote in message
>> news:98857FD6-49E1-4B18-8337-1E972E34ABCF@microsoft.com...
>> > So I have this government document, where the first section(s) must 
>> > have
>> > page
>> > numbering at the bottom that relates to the headings (i.e., 2.3-18 
>> > where
>> > 2.3
>> > is Heading 2 style and 18 is the current page of the entire document.
>> >
>> > However, when it comes time for tables in the document, I need to 
>> > maintain
>> > the numbering at the bottom per previous sections, but ADD numbering at
>> > the
>> > top that says "Sheet 1 of 5," that calculates the pages in the table
>> > (section
>> > breaks before and after, used SectionPages field).
>> >
>> > Two different sets of numbers, different formats, same page.
>> >
>> > I have tried Seq variables, PageRef fields, but any time I change the
>> > footer
>> > format to include the Heading, it changes my Sheet numbering to have a
>> > Heading as well.
>> >
>> > Tell me it can't be done.
>>
>>
>> .
>> 

The first part is brilliant, thank you!

The second part I need some clarification on - I didn't know you could do 
"field math" and I'm not that familiar with the PageRef field. If you could 
expand on that, that'd be great!

"Doug Robbins - Word MVP" wrote:

> To get the 2.8, insert a cross-reference to the paragraph number and after 
> it, insert the hyphen and a { Page } field.
> 
> To get the 1 of the 1 of 8, you are going to need to insert some bookmarks 
> at the end of each section thenand use some field maths to subtract the 
> PageRef of the bookmark from a { page } field
> 
> -- 
> 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
> 
> "That70sHeidi" <That70sHeidi@discussions.microsoft.com> wrote in message 
> news:3CD9917D-6909-4EA8-B85A-719A700CE55B@microsoft.com...
> > Already have Section Breaks applied.
> >
> > Header of Section 4 needs to say Sheet 1 of 8.
> > Footer of Section 4 needs to say 2.8-14.
> > On the same page.
> >
> > Even with the codes I mentioned earlier, I cannot make the footer use one
> > form of page number without the header reflecting that. If I want the 
> > footer
> > to use Heading 2, then my Sheet number will use Heading 2 as well.
> >
> > "Graham Mayor" wrote:
> >
> >> There are three header/footers associated with each section (First Page,
> >> Primary and Even Pages).
> >> Insert a section break before the table and break the link between the
> >> header of that section and the previous section. Put what you require in 
> >> the
> >> appropriate header/footers of each section.
> >>
> >> -- 
> >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> >> Graham Mayor -  Word MVP
> >>
> >> My web site www.gmayor.com
> >> Word MVP web site http://word.mvps.org
> >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> >>
> >>
> >> "That70sHeidi" <That70sHeidi@discussions.microsoft.com> wrote in message
> >> news:98857FD6-49E1-4B18-8337-1E972E34ABCF@microsoft.com...
> >> > So I have this government document, where the first section(s) must 
> >> > have
> >> > page
> >> > numbering at the bottom that relates to the headings (i.e., 2.3-18 
> >> > where
> >> > 2.3
> >> > is Heading 2 style and 18 is the current page of the entire document.
> >> >
> >> > However, when it comes time for tables in the document, I need to 
> >> > maintain
> >> > the numbering at the bottom per previous sections, but ADD numbering at
> >> > the
> >> > top that says "Sheet 1 of 5," that calculates the pages in the table
> >> > (section
> >> > breaks before and after, used SectionPages field).
> >> >
> >> > Two different sets of numbers, different formats, same page.
> >> >
> >> > I have tried Seq variables, PageRef fields, but any time I change the
> >> > footer
> >> > format to include the Heading, it changes my Sheet numbering to have a
> >> > Heading as well.
> >> >
> >> > Tell me it can't be done.
> >>
> >>
> >> .
> >> 

OK, I think I got the second Table section to work with the following: 

(Note: Table 1 was only 1 page and did not need a sheet number, so this 
formula is for Table 2)

SH. {={Page}-{PageRef Table1}} of {SectionPages}

It counts up from 1 to the final page. 

But for the third Table, I can't seem to get the formula right, and I'm 
getting everything from -3 of 3 to -15 of 3.

What do I change for subsequent Tables after that first formula worked so 
well? I assumed you'd just add the next table's PageRef, but it doesn't seem 
to work out. 


"That70sHeidi" wrote:

> The first part is brilliant, thank you!
> 
> The second part I need some clarification on - I didn't know you could do 
> "field math" and I'm not that familiar with the PageRef field. If you could 
> expand on that, that'd be great!
> 
> "Doug Robbins - Word MVP" wrote:
> 
> > To get the 2.8, insert a cross-reference to the paragraph number and after 
> > it, insert the hyphen and a { Page } field.
> > 
> > To get the 1 of the 1 of 8, you are going to need to insert some bookmarks 
> > at the end of each section thenand use some field maths to subtract the 
> > PageRef of the bookmark from a { page } field
> > 
> > -- 
> > 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
> > 
> > "That70sHeidi" <That70sHeidi@discussions.microsoft.com> wrote in message 
> > news:3CD9917D-6909-4EA8-B85A-719A700CE55B@microsoft.com...
> > > Already have Section Breaks applied.
> > >
> > > Header of Section 4 needs to say Sheet 1 of 8.
> > > Footer of Section 4 needs to say 2.8-14.
> > > On the same page.
> > >
> > > Even with the codes I mentioned earlier, I cannot make the footer use one
> > > form of page number without the header reflecting that. If I want the 
> > > footer
> > > to use Heading 2, then my Sheet number will use Heading 2 as well.
> > >
> > > "Graham Mayor" wrote:
> > >
> > >> There are three header/footers associated with each section (First Page,
> > >> Primary and Even Pages).
> > >> Insert a section break before the table and break the link between the
> > >> header of that section and the previous section. Put what you require in 
> > >> the
> > >> appropriate header/footers of each section.
> > >>
> > >> -- 
> > >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> > >> Graham Mayor -  Word MVP
> > >>
> > >> My web site www.gmayor.com
> > >> Word MVP web site http://word.mvps.org
> > >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> > >>
> > >>
> > >> "That70sHeidi" <That70sHeidi@discussions.microsoft.com> wrote in message
> > >> news:98857FD6-49E1-4B18-8337-1E972E34ABCF@microsoft.com...
> > >> > So I have this government document, where the first section(s) must 
> > >> > have
> > >> > page
> > >> > numbering at the bottom that relates to the headings (i.e., 2.3-18 
> > >> > where
> > >> > 2.3
> > >> > is Heading 2 style and 18 is the current page of the entire document.
> > >> >
> > >> > However, when it comes time for tables in the document, I need to 
> > >> > maintain
> > >> > the numbering at the bottom per previous sections, but ADD numbering at
> > >> > the
> > >> > top that says "Sheet 1 of 5," that calculates the pages in the table
> > >> > (section
> > >> > breaks before and after, used SectionPages field).
> > >> >
> > >> > Two different sets of numbers, different formats, same page.
> > >> >
> > >> > I have tried Seq variables, PageRef fields, but any time I change the
> > >> > footer
> > >> > format to include the Heading, it changes my Sheet numbering to have a
> > >> > Heading as well.
> > >> >
> > >> > Tell me it can't be done.
> > >>
> > >>
> > >> .
> > >> 

I got it! I forgot to put the footer page code in, so naturally it wasn't 
pulling anything to calculate with. *headdesk* I've tried it on several 
tables and it works a charm, the PageRef bookmark just keeps going up a 
number. 

THANK YOU!

"That70sHeidi" wrote:

> OK, I think I got the second Table section to work with the following: 
> 
> (Note: Table 1 was only 1 page and did not need a sheet number, so this 
> formula is for Table 2)
> 
> SH. {={Page}-{PageRef Table1}} of {SectionPages}
> 
> It counts up from 1 to the final page. 
> 
> But for the third Table, I can't seem to get the formula right, and I'm 
> getting everything from -3 of 3 to -15 of 3.
> 
> What do I change for subsequent Tables after that first formula worked so 
> well? I assumed you'd just add the next table's PageRef, but it doesn't seem 
> to work out. 
> 
> 
> "That70sHeidi" wrote:
> 
> > The first part is brilliant, thank you!
> > 
> > The second part I need some clarification on - I didn't know you could do 
> > "field math" and I'm not that familiar with the PageRef field. If you could 
> > expand on that, that'd be great!
> > 
> > "Doug Robbins - Word MVP" wrote:
> > 
> > > To get the 2.8, insert a cross-reference to the paragraph number and after 
> > > it, insert the hyphen and a { Page } field.
> > > 
> > > To get the 1 of the 1 of 8, you are going to need to insert some bookmarks 
> > > at the end of each section thenand use some field maths to subtract the 
> > > PageRef of the bookmark from a { page } field
> > > 
> > > -- 
> > > 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
> > > 
> > > "That70sHeidi" <That70sHeidi@discussions.microsoft.com> wrote in message 
> > > news:3CD9917D-6909-4EA8-B85A-719A700CE55B@microsoft.com...
> > > > Already have Section Breaks applied.
> > > >
> > > > Header of Section 4 needs to say Sheet 1 of 8.
> > > > Footer of Section 4 needs to say 2.8-14.
> > > > On the same page.
> > > >
> > > > Even with the codes I mentioned earlier, I cannot make the footer use one
> > > > form of page number without the header reflecting that. If I want the 
> > > > footer
> > > > to use Heading 2, then my Sheet number will use Heading 2 as well.
> > > >
> > > > "Graham Mayor" wrote:
> > > >
> > > >> There are three header/footers associated with each section (First Page,
> > > >> Primary and Even Pages).
> > > >> Insert a section break before the table and break the link between the
> > > >> header of that section and the previous section. Put what you require in 
> > > >> the
> > > >> appropriate header/footers of each section.
> > > >>
> > > >> -- 
> > > >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> > > >> Graham Mayor -  Word MVP
> > > >>
> > > >> My web site www.gmayor.com
> > > >> Word MVP web site http://word.mvps.org
> > > >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> > > >>
> > > >>
> > > >> "That70sHeidi" <That70sHeidi@discussions.microsoft.com> wrote in message
> > > >> news:98857FD6-49E1-4B18-8337-1E972E34ABCF@microsoft.com...
> > > >> > So I have this government document, where the first section(s) must 
> > > >> > have
> > > >> > page
> > > >> > numbering at the bottom that relates to the headings (i.e., 2.3-18 
> > > >> > where
> > > >> > 2.3
> > > >> > is Heading 2 style and 18 is the current page of the entire document.
> > > >> >
> > > >> > However, when it comes time for tables in the document, I need to 
> > > >> > maintain
> > > >> > the numbering at the bottom per previous sections, but ADD numbering at
> > > >> > the
> > > >> > top that says "Sheet 1 of 5," that calculates the pages in the table
> > > >> > (section
> > > >> > breaks before and after, used SectionPages field).
> > > >> >
> > > >> > Two different sets of numbers, different formats, same page.
> > > >> >
> > > >> > I have tried Seq variables, PageRef fields, but any time I change the
> > > >> > footer
> > > >> > format to include the Heading, it changes my Sheet numbering to have a
> > > >> > Heading as well.
> > > >> >
> > > >> > Tell me it can't be done.
> > > >>
> > > >>
> > > >> .
> > > >>