Carbon Copy worksheet

Stevealexa

New Member
Joined
May 24, 2002
Messages
11
Hello Everyone.

Please could someone help me with this issue.

I have a worksheet that contains purely manually entered data(No functions.
across the coloumns there are names and registration numbers etc and then 10 columns of times (hours:mins) in am pm foarmat.

I want to be able to create two identical worksheets from one input but the text formatting must be different.

Font in input doc = 15point in copy doc = 9 point.

I can get the "text" to copy through but the times all change in the copy document.

Any ideas please

Merry Christmas

Stve
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

sykes

Well-known Member
Joined
May 1, 2002
Messages
1,884
Office Version
  1. 365
Platform
  1. Windows
Easiest way would probably be to create a copy of the original:

Right-click the sheet tab (name of the sheet) select "Move or copy........" then tick the "Create Copy" box, and click "OK."

The new sheet will have the same name but a (2) at the end.

edit - Re-name it if you wish by right clicking the sheet tab and using "Re-name"

Select all the data on the new sheet with drag - and - drop, or select the very top left hand grey box - to the left of the "A" and above the "1", then set your new font in.

Edit2 ; ......and happy Christmas to you!!
 

Stevealexa

New Member
Joined
May 24, 2002
Messages
11
Thanks Sykes, but this has to be a NO EFFORT job for a very lazy and disinterested old lady.

Basically she has to cut and paste the smaller point version into Mac Cont 3 and publish to the web the larger version is printed as a Poster type thing.

But she point blank refuses to do anything to reformat or re-create her data and insists on the **** thing being automatic

????
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,124
Messages
5,835,544
Members
430,366
Latest member
glastonbury

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
Top