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
 

Some videos you may like

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

sykes

Well-known Member
Joined
May 1, 2002
Messages
1,759
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

????
 

Watch MrExcel Video

Forum statistics

Threads
1,118,022
Messages
5,569,711
Members
412,289
Latest member
Kingchaos64
Top