DaveRowland
New Member
- Joined
- Nov 22, 2016
- Messages
- 2
- Office Version
- 365
- Platform
- MacOS
I am currently using the below to make writing up my reports quicker.
="The work was carried out by "&Constants!H11&" on the "&TEXT(Constants!H9, "dd/mm/yyyy")
when printing cell would look like :- The work was carried out by Dave on the 08/06/2020
The constants page contains information that is repeated often throughout, the 2 cells contain name and date for this example what I am trying to do is format the info carried forward (i.e bold or italic ) I would like to do this without VBA if possible?
="The work was carried out by "&Constants!H11&" on the "&TEXT(Constants!H9, "dd/mm/yyyy")
when printing cell would look like :- The work was carried out by Dave on the 08/06/2020
The constants page contains information that is repeated often throughout, the 2 cells contain name and date for this example what I am trying to do is format the info carried forward (i.e bold or italic ) I would like to do this without VBA if possible?