Autofill headers from a worksheet - Can I please get some help?

[Marq]

Hello,

I have a workbook which I have to populate headers on more than one sheet. While it's not a critical issue, the repetitiveness of it can get annoying doing multiple times a day. I figure there is a way to automate this process but it is beyond my ability.

Can someone please help me make this happen? Basically I want to have one main worksheet where I plug the info in and that info would populate headers of 4 worksheets (left header and center header)

The headers will always have certain text in them which are the same for all jobs....I want the "autofill" to show up next to the text..for example all headers have this in the left header box:

Estimate as L?
Estimate as A?
WO#
WOFC#
PO#
POFC#

I want the autofill to make it look like below <the bold items being the autofill items>:

Estimate as L? YES
Estimate as A? NO
WO# 1234567-0060
WOFC# 1234567-0030
PO# 12345678-00500
POFC# 12345678-00400

In my minds eye, I see a worksheet with cells to populate the bold items above, then once populated, click a macro button and once clicked all the headers populate. I have left box headers and center box headers to autofill. I'm hoping to get it working before 2020 so i can begin the new year being more efficient at work.

 

[ranman256]

range("A1").value = "Estimate as L?"
range("b1").value = "Estimate as A?
range("c1").value = "WO#
range("d1").value = "WOFC#
range("e1").value = "PO#
range("f1").value = "POFC#

etc...
Range("B1:B5").selection.Font.Bold = True