LinkBack URL
About LinkBacks
To avoid duplicating work, I am looking for a way to copy data from cell B2, the Job ID number, into the right footer.
Is this possible to do? Spreadsheet attached. Thank you!
To avoid duplicating work, I am looking for a way to copy data from cell B2, the Job ID number, into the right footer.
Is this possible to do? Spreadsheet attached. Thank you!
What do you mean by Right footer, are you talking about the right side of cell B1?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hello LoriLynn,
Welcome to the Forum!
The code below has been added to the attached workbook.
Please Login or Register to view this content.
Last edited by Leith Ross; 01-06-2012 at 01:37 PM. Reason: Change left footer to right footer
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi,
One way with a macro:
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
If selecting "Page Layout" from the "View" ribbon, you can see your Header and Footer. This can be broken into Left, Center, and Right. I'd like for Excel to automatically copy the numbers I enter in B1 to show in the Right footer.
Thanks!
Thank you, this was helpful but now I have another question. I use my master sheet to create a copy as I add new sheets. Is there a way to write the code to update with each new sheet added/copied?
~Lori
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks