VBA: create dynamic header based on column values

R

robertvdb

Active Member
Joined
Jan 10, 2021
Messages
327
Office Version
  1. 2016
Platform
  1. Windows
I have a macro which prints a PDF, consisting of multiple pages. These pages are split, based on the values in column D. So when the value in col D changes, a pagebreak is inserted.

Now I want to have a header on each page, which string value reflects the value in column B.

See enclosed. Any help is appreciated.
 

Attachments

  • header.png
    header.png
    26.2 KB · Views: 7

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

R
  • Locked
  • Question
VBA: create dynamic header based on column values
Replies
1
Views
328
Joe4
Joe4
S
  • Question
Mail Merge Macro Doesn't Connect Refresh
Replies
1
Views
78
StephenBart
S
P
  • Question
Automating copying of columns within same sheet in excel using VBA.
Replies
1
Views
161
MountainFog
M
G
  • Question
PDF Create button to manage output formatting
Replies
0
Views
734
grabrail
G
A
  • Question
VBA to Split Data From an Existing Table into Another Single Worksheet with Header for Each Section
Replies
1
Views
207
John_w
J

Forum statistics

Threads
1,215,219
Messages
6,123,684
Members
449,116
Latest member
HypnoFant

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top