Automatic copy of cell formatting between sheets

P

Phrank

Hi,

I've got this follow-up question buried in another post (Selective
selecting of multiple tabs), but I felt I should pull it out here as a
seperate post in hopes of getting more views.

I recieved some great help that led to a positive solution (solution
from Jim Cone included below), and I'm hoping to be able to tweak this
macro so that the formatting in the cell on the CTD sheet matches that
of the same cell on the Data Entry sheet. When data gets entered onto
the Data Entry sheet, we set significant figures and cell orientation
(center or right justified). Is there a way for that to get
translated to the CTD tab too? Thanks.

Frank
 

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

Selective selecting of multiple tabs 7
Macro to Combine Data from Multiple Sheets with Cell References 4
Create if partial match then copy and paste data from one cell to another 1
Conditional formatting within macro? 3
Copy the formatting of one cell to other cell 5
Search for the cell content between sheets and copy corresponding 2
Issue With Macro Sheduling Using On Time Event 0
Copy unformatted value of cell via macro 0

Top