how to copy cell value from one sheet to another with the same formatting

allexbyta

New Member
Joined
Jan 4, 2022
Messages
1
Office Version
  1. 365
  2. 2021
  3. 2016
Platform
  1. Windows
hello, community.

I'm trying for 2-3 days to make a Microsoft Access Database for a schedule at my work - 24/7 x6 people. it's too hard for me and I'm back to excel.

at the moment I'm trying to bring the information (text) from sheet 2 to sheet 1 but i want to keep the text formatting ( only the text color I'm interested , not the size or font)

the formula I have now it's like

=Sheet2!D94&"("&Sheet2!E94&") ("Sheet2!$F94&"), ("&Sheet2!J94&") ("Sheet2!$K94&")" etc... many other values

I must say it's a a schedule for the entire year in 3 shifts 24/7 for 6 people / shift and I'm trying to make it easy to read.

So can u help me copy the cell value from one sheet to another and keep the text collor from sheet 2 ?

Thank you in advance.
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
Welcome to the Board!

Native Excel formulas only act on the values of cells, not on the formatting.
If you want to copy formatting from one sheet to another and not do it manually, that will require VBA.

However, you may want to pause before totally giving up on Micorsoft Access.
There are many pre-built Access Database Templates for things like this.
If you do a Google search on "Microsoft Access Scheduling Template", you will find many hits.
There are usually free offerings and ones you can purchase.
You may want to peruse those and see if you can find one that is already built for you that you can use.
 
Upvote 0

Forum statistics

Threads
1,213,510
Messages
6,114,037
Members
448,543
Latest member
MartinLarkin

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