Re: $$Excel-Macros$$ Help for Macro

2014-06-08 Thread Shrinivas Shevde
Dear Vaibhav Thanks for reply. As I mentioned earlier today I have 10 rows and I run the macro. I will get output. Tomorrow I will add more 12 rows and if I run the macro I will get output and it will overwrite the last one .there are chances someone will change the data and resend .What I want is

$$Excel-Macros$$ Re: Privacy Warning for macro enabled excel

2014-06-08 Thread Sandip Bhange
Everything i have shown you in my video on youtube... please go through the given link... I hope your problem solve... I show you the practical in link... so please *This document contains macros activex controls XML expansion pack inform video* li

RE: $$Excel-Macros$$ Similar Items

2014-06-08 Thread Virkar,Nilesh
Hi, I want the similar item in separate sheet OR in separate Colum. Regards Nilesh Virkar From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Vaibhav Joshi Sent: Saturday, June 07, 2014 6:58 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ S

$$Excel-Macros$$ Re: assigning color to cells on basis of value

2014-06-08 Thread Awal
Here is code snippet I got from the net: Dim MyRange As Range 'vba to do: I need to BG a cell based on it's value 'IF A,B or C it is green 'IF D,E,F it is Blue etc 'So, once I past a value in a cell I need to call a function to evaluate it then give it the proper BG color 'What range do we care ab

Re: $$Excel-Macros$$ Need Code for data

2014-06-08 Thread Vaibhav Joshi
Hi Jack Did you check version 1? Thanks Hi, I have basic knowledge excel and have 2010 office if anyone could help as I have lot of data. I have attached sample of working needed. The procedure I do manually is as below: I have two sheets 'data' and 'area' in 'data' sheet monthly entries are d