Hi
How do I copy a formula to a second sheet to create headers without changing the formats and without using the format painter or VBA
Appreciate any help
See attached sample excel sheet
Thank you in advance
Hi
How do I copy a formula to a second sheet to create headers without changing the formats and without using the format painter or VBA
Appreciate any help
See attached sample excel sheet
Thank you in advance
You annot copy formatting with a formula, if that's what you mean.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Kinda depends on the formulae. Your examples show copying and pasting fixed text and formatting.
You could, for example, ensure the cell references are absolute. For example, =Sheet1!$C$2 should copy and paste with its formatting.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Copy a formula with the format, let VBA handle it
Please Login or Register to view this content.
Last edited by wk9128; 04-26-2024 at 06:21 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks