$$Excel-Macros$$ Merge cell depend on criteria

2016-04-25 Thread rameshwari shyam
Dear everyone, Good day. I have query for VBA excel (Macro) I have attached file with explanation. What i want to do 01) Merge cell with blank cell which is shown in left hand side range("A:F") 02) Output need to be like shown in Right hand side range("J:O") 03) Data can be as long this is o

$$Excel-Macros$$ Re: Introduce Yourself !!

2015-10-19 Thread Shyam Gaur
Hi All, I am Shyam from delhi Working as HR Executive in FIITJEE Limited. I am very keen to know new things and event in EXCEL and VBA Macros. Thanks! Shyam On Saturday, June 9, 2012 at 12:51:59 AM UTC+5:30, Ayush Jain wrote: > > Hey all new and current posters, > > Welcome to exc

Fwd: $$Excel-Macros$$ Formula based on some criteria

2015-03-14 Thread rameshwari shyam
Dear Team, Can any one help on this. Thanks, Rameshwari -- Forwarded message -- From: rameshwari shyam Date: Fri, Mar 13, 2015 at 10:08 AM Subject: Re: $$Excel-Macros$$ Formula based on some criteria To: excel-macros@googlegroups.com Dear gaurav, required some more

Re: $$Excel-Macros$$ Formula based on some criteria

2015-03-12 Thread rameshwari shyam
Dear gaurav, required some more modification. if you can check AED in question sheet is 15 then in Master sheet, search for 15 SAR. Below than that there is a AED 15, KWD 15, SAR 1.5 OMR 1.5 BHD 15 QAR 1.25, Base currency will be AED in question sheet and in master sheet base currency will be SAR

Re: Fwd: $$Excel-Macros$$ Value need to update as per master (excel sheet Attached)

2014-05-04 Thread rameshwari shyam
4 at 11:28 AM, Vaibhav Joshi wrote: > >> Hi >> >> Is it wat you are looking for. >> >> Cheers! >> >> >> On Sun, May 4, 2014 at 6:16 PM, rameshwari shyam < >> rameshwarish...@gmail.com> wrote: >> >>> Dear All, >>> >

Re: Fwd: $$Excel-Macros$$ Value need to update as per master (excel sheet Attached)

2014-05-04 Thread rameshwari shyam
ople > you can,As long as ever you can.” - John Wesley* > - > >*From:* rameshwari shyam > *To:* excel-macros@googlegroups.com > *Sent:* Thursday, May 1, 2014 2:26 AM > *Subject:* Fwd: $$Excel-Macros$$ Value need to update as per ma

Fwd: $$Excel-Macros$$ Value need to update as per master (excel sheet Attached)

2014-04-30 Thread rameshwari shyam
as per master (excel sheet Attached) To: excel-macros@googlegroups.com pls clear ur query On Wed, Apr 30, 2014 at 5:32 AM, rameshwari shyam wrote: > Dear Team, > > Please advice on below query. > > > I have one target% and as per target% value need to change. For example

$$Excel-Macros$$ Value need to update as per master (excel sheet Attached)

2014-04-30 Thread rameshwari shyam
Dear Team, Please advice on below query. I have one target% and as per target% value need to change. For example if my target% is 12.50 then next Coolum need to fill as per my target% just like 15.00 Attached excel sheet. if target % Need to take as per Target % 12.50 15.00 67.90 69.00

Re: $$Excel-Macros$$ Re: All text box need to be enter

2014-04-02 Thread rameshwari shyam
Dear Ganesh, Thanks for your help. yes it work out as per requirements. Regards, Rameshwari On Thu, Apr 3, 2014 at 10:29 AM, Ganesh N wrote: > Hi, > > Please find the attachment. > > Regards, > Ganesh N > > > On Wed, Apr 2, 2014 at 4:55 PM, rameshwari shyam &l

Re: $$Excel-Macros$$ All text box need to be enter

2014-04-02 Thread rameshwari shyam
Dear Ashish, Please find enclosed herewith file. value for textbox3 need to be fill in column A first empty row textbox4 value for column B textbox5 value for column C After value/text transfer to excel sheet all textbox need to be empty. Regards, Rameshwari On Thu, Apr 3, 2014 at 9:42 AM, ash

Re: $$Excel-Macros$$ Re: All text box need to be enter

2014-04-02 Thread rameshwari shyam
: > Hi rameshwari, > > Please find the updated one. > > Regards, > Ganesh N > > > On Wed, Apr 2, 2014 at 4:18 PM, rameshwari shyam < > rameshwarish...@gmail.com> wrote: > >> Dear Ganesh, >> Thank you very much for quick reply. >> >> Once

Re: $$Excel-Macros$$ Re: All text box need to be enter

2014-04-02 Thread rameshwari shyam
:) On Wed, Apr 2, 2014 at 2:47 PM, rameshwari shyam wrote: > Dear Ganesh, > Thank you very much for quick reply. > > Once enter the data in all textbox after that hit the submit button. and > after transfer the data to excel sheet all textbox need to be blank. as > this very co

Re: $$Excel-Macros$$ Re: All text box need to be enter

2014-04-02 Thread rameshwari shyam
Dear Ganesh, Thank you very much for quick reply. Once enter the data in all textbox after that hit the submit button. and after transfer the data to excel sheet all textbox need to be blank. as this very confidential data of user not suppose to be duplicate. Please help. Regards, Rameshwari :)

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012

2012-09-03 Thread rameshwari shyam
Hi Noorain sir, Congratulation to help people thanks & regards, Rameshwari On Sun, Sep 2, 2012 at 9:02 AM, Ayush Jain wrote: > Dear members, > > Once again, Noorain Ansari has been selected as 'Most Helpful Member' for > the month of Aug'12. He has posted 111 posts in August 2012 and helped ma

$$Excel-Macros$$ Vlookup Help required

2012-08-02 Thread Anera Shyam
gt;7.99, "G" OR(If (Vlookup(A5, Data!A:D, 3, 0)="Monthly", If (Vlookup($A5, Data!$A:$N, 8, 0)=1, "R", If(Vlookup($A5, Data!$A:$N, 8, 0)=2, "Y", If(Vlookup($A5, Data!$A:$N, 8, 0)=3, "G")) Regards Shyam -- FORUM RULES (986+ members already

$$Excel-Macros$$ Introduction

2012-07-14 Thread shyam mohata
Hello all, I am Shyam Sunder Mohata, Working as Derivative Analyst and having around 3 years exp. Apart from my work, I like to enjoy most forms of music and Dancing.Excel plays major supportive role in research and reporting. I am really feel good to be a part of this forum. Thanks Shyam

Re: $$Excel-Macros$$ Need Help on Formulas

2012-05-08 Thread Anera Shyam
Hi Krishna, Works Perfectly Fine:) Thanks a ton. Cheers Shyam On 8 May 2012 19:14, Krishna Kumar wrote: > Hi > > Try > > > =LOOKUP(2,1/(({"High";"High";"High";"Medium";"Medium";"Medium";"Low";

$$Excel-Macros$$ Need Help on Formulas

2012-05-08 Thread Anera Shyam
-- Forwarded message -- From: Anera Shyam Date: 8 May 2012 18:52 Subject: Re: $$Excel-Macros$$ Need macro to verify part numbers between 2 sheets To: excel-macros@googlegroups.com Hi All, I wish to seek your assistance in getting the output as mentioned in the attached excel

Re: $$Excel-Macros$$ Need macro to verify part numbers between 2 sheets

2012-05-08 Thread Anera Shyam
dium", I should get an output of "2". The other parameters have been mentioned in the attached sheet. Thanks in Advance Regards Shyam -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent,

$$Excel-Macros$$ Concatenate after checking all cell

2009-12-17 Thread shyam
Date at sheet1 Date at sheet2 Date at sheet3 Date at sheet4 Date at sheet5 Date at sheet6 Concatenate(Final po Date) 0-Jan-000-Jan-000-Jan-0029-Nov-08 0-Jan-00 0-Jan-0029-Nov-08 0-Jan-000-Jan-000-Jan-0029-Nov-08 0-Jan