Text Format Transfer
 

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

Text Format Transfer
 

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...


--
To get my email id paste my address in an Excel cell and press Enter...


"RAB2685" wrote:

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

Text Format Transfer
 

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

"Sheeloo" wrote:

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...


--
To get my email id paste my address in an Excel cell and press Enter...


"RAB2685" wrote:

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

Text Format Transfer
 

If you start today you will be there very soon...

Try
http://www.angelfire.com/biz7/julian...ans_macros.htm
http://www.contextures.com/tiptech.html
http://www.cpearson.com/excel/topic.aspx

Also try ASAP Utilities which is available for free for non-commercial use.
for excellent ideas about Excel

--
To get my email id paste my address in an Excel cell and press Enter...


"RAB2685" wrote:

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

"Sheeloo" wrote:

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...


--
To get my email id paste my address in an Excel cell and press Enter...


"RAB2685" wrote:

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

Text Format Transfer
 

Thank You!

"Sheeloo" wrote:

If you start today you will be there very soon...

Try
http://www.angelfire.com/biz7/julian...ans_macros.htm
http://www.contextures.com/tiptech.html
http://www.cpearson.com/excel/topic.aspx

Also try ASAP Utilities which is available for free for non-commercial use.
for excellent ideas about Excel

--
To get my email id paste my address in an Excel cell and press Enter...


"RAB2685" wrote:

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

"Sheeloo" wrote:

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...


--
To get my email id paste my address in an Excel cell and press Enter...


"RAB2685" wrote:

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