Need help linking cells to footer

[YouthfulMind]

Hey Everyone,
I have a created a price guide in excel which contains three sheets. The first sheet is all the input information for the sales angent and the rest are the actual brochure which will be sent to the customer. I am at the point where I am trying to link 2 cells on the first sheet called Product Price Settings to the footer. One will go to the center footer the other will go to the right footer. I need this so the agents can input the customer in one and their name in the other and it will go on all footers. If someone could help me with this code that would be cool

[barryleajo]

Hi YouthfulMind
Welcome to the forum
Try this, footer values in Cells B5-B7 on Sheet1

Please Login or Register  to view this content.