ExcelBanter - View Single Post

remove nospam

Mangesh

"MINAL ZUNKE" wrote in message
...
hi Mangesh

If you can give me your email-id that will be really helpful. I can
forward my excel sheet with explanation in it.

Thnx

"Mangesh Yadav" wrote:

If you don't mind sharing your excel sheet, why don't you mail me your
excel
sheet with a little explanation. Maybe something like I just have to
press a
button to run your macro, and a little write-up on what should happen
after
pressing this button. You can write to me at my gmail id. And remove
NOSPAM.

Mangesh

"MINAL ZUNKE" wrote in message
...
Hi again

Sorry but it is not working. If I check code no error in that, that
background colour information is not getting passed on. Can't figure
out
any
reason for that.
Thanking you in anticiapation!

"MINAL ZUNKE" wrote:

Hi mangesh

I have done that , the day you gave me solution. I have done that
this
way
Select Cell A2 in sheet 2, click right hand mouse button, select
patterns,
select colour, click ok . Done that for cell B2, C2 as well.
The background colour for the cell A2 changes as per settings but
this
information is not getting passed onto sheet 1.

Thnx for ur help!

"Mangesh Yadav" wrote:

First thing before I read your mail completely, set the background
color for
cells A2, B2 and C2 and not row 3.

Mangesh

"MINAL ZUNKE" wrote in
message
...
Hi Mangesh

Thnx for your suggestion!!! I appreciate you help, Sorry but
mothing
seems
to happen again. As you said the code was written a/c to my
example,
I
would
like to clarify few more bits.

I have set background colour in sheet 2 cell A3, B3 & C3 (and
not
whole
column) as per my choice. I already have set up conditional
formatting in
sheet 1 in other columns. I have written VB script in sheet 1.
I am
using
column A to column W in sheet 1.
Data in sheet 1 from column A to column E gets copied over
automatically.
I
have developed MS Access query to get the data. After I
analyse
executed
query with excel, all the data in executed query gets copied
over to
another
excel file(say A). I have recorded macro to copy data from ( A)
excel file
into main excel file sheet 1.
Data in column B in main excel file(where all the customer name
gets
listed)
also gets copied over.
As I have said before as soon as I run macro, data gets copied
over,
from
column A to column E, column B should change colour depending on
the
class. I
think this might help you a bit. If you need more help from me,
I am
happy
to
answer your query.
Thanking you in anticipation!!!
Minal

"Mangesh Yadav" wrote:

Hi Minal,

The following code was written with the example you gave. The
only
thing
you
need to do is:
In sheet2, cells A2, B2, and C2 should be colored (the
backgroud
should
be
colored as per your requirements).

Mangesh