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

Marq

Well-known Member
Joined
Dec 13, 2004
Messages
914
Office Version
  1. 365
  2. 2007
Platform
  1. Windows
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.
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
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
 
Upvote 0

Forum statistics

Threads
1,226,694
Messages
6,192,473
Members
453,726
Latest member
JoeH57

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