Text Format Transfer

R

RAB2685

To simplify I will explain as easy as possible what I'm in need of but within
the same file I have 2 work sheets (I'll call them A & B)

On worksheet A (which is basically just a summary sheet) I'm extracting
applicable data from worksheet B where all of my detailed sheduling is done
which is basically noise to the rest of the organization because all they
just want to see are the results without all the details.

So in worksheet A I'm going out to worksheet B and retrieving the result on
worksheet B if my conditions are being met (mainly using "If" statements).
On worksheet B I use different text formats to highlight changes or deletions
such as highlighting in red text, using strike through, maybe making the text
bold, etc...... but here is my problem:

When the data is pulled over onto worksheet A it always defulat to just
basic text format and I want it to carry over the exact text format as it
appears on worksheet B - again it is just the appearance and not for instance
how the date is represented such as 01/03/09 vs. 1/3/09 as I can fix that
condition easily.

Does anyone know if this can be done as my local very experienced partners
cannot figure it out.

Please help if you have suggestions!

Thanks
 
S

Sheeloo

When you get the contents of another cell through a formula formatting is not
passed through.

What you want can be achieved through VBA code...
 
R

RAB2685

Wow that may be way above my head as I have never gotten into VBA coding - I
see how to get to it within Excel, but do you know of a website or somewhere
I can read about basic VBA coding as the "Help" directs me to various add-ons
such as software, etc......

Wish I had the knowledge like you guys - it sure would make my life easier!
LOL

Any suggestions?

Thanks
 

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

Change a great number of words in word files, with a macro as short as possible. 5
Formating bolded text exclusively. 0
How to Import Formatted text as new Slides in PowerPoint 0
Format change in merge data - Bold formatting after a comma 0
Outlook 365 use on my desktop and sometimes my iPhone 0
Excel does not accept text format! 0
When I insert a worksheet the cell format is accounting 1
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1

Top