Coping text using Formulas -

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to format text on a worksheet, where any text in cell A1 entered
on Sheet 1 automatically fills in a cell on Sheet 2. My formula on Sheet 2
reads:

=Sheet1!A1

The text copies fine, but I need the properties and formatting to go with
it, such as text color, bold, row height, etc. Can someone help?
 
The easy way to do what you're describing is to select the entir
worksheet 1, copy, select the entire worksheet 2, and paste special --
formats.

You could also write some VBA code to do the same, if you were s
inclined, but this i think should do it
 
I should probably explain. Worksheet 1 is Detailed information. Worksheets
2 thru 10 are summaries of 1, where only critical cells are being copied
over. Hence why I was using the formula to automatically copy over the data
from Sheet 1 to Sheet 2.

Unfortunately, I'm not proficient enough with VBA to do anything. Any other
suggestions?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to format cells on several worksheets 2
protect cell format 1
Excel VBA 1
Duplicate "Drag" feature 2
Excel Count If Formula Question 1
Fill formula down for cells 74 rows apart 3
Using text in a cell in a formula 2
=Sheet!A1 formula alternative 2

Back
Top