$$Excel-Macros$$ Transpose Query

Dear Members, I have one file for Transpose query but now i need this formula in reversal(opposite) condition...Data in sheet2 format and need to change in sheet1 format. Please guide me! -- *Sky* "Good, Better, Best! *Always listen to your heart, because there lives your parents.* -- Are

Re: $$Excel-Macros$$ How to pick rental on pro-rata/monthly basis as per date

t; pro-rata/monthly basis as per date >To: excel-macros@googlegroups.com > Date: Friday, March 17, 2017, 9:44 AM > > > >On Fri, 3/17/17, Sunil Kumar Yadav <sk.yadav7...@gmail.com> >wrote: > > Subject: Re: $$Excel-Macros$$ How to pi

Re: $$Excel-Macros$$ How to pick rental on pro-rata/monthly basis as per date

Dear Paul, I want to formula in one column not month-wise separately. Please guide me! On Fri, Mar 17, 2017 at 12:44 PM, Sunil Kumar Yadav <sk.yadav7...@gmail.com> wrote: > Dear Team, > > I want to pick rental pro-rata/monthly as per purchasing date. > > Pro-rata - If

$$Excel-Macros$$ How to pick rental on pro-rata/monthly basis as per date

Dear Team, I want to pick rental pro-rata/monthly as per purchasing date. Pro-rata - If purchasing date after 1st then rental will be calculated days-wise(count) monthly - If purchasing date 1st then rental will be paid full. -- *Sky* "Good, Better, Best! *Always listen to your heart,

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

> *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > --

$$Excel-Macros$$ How to pick numbers which are missing in serial numbers

Dear Paul, I have need your help for this query. Please guide me. -- *Sky* "Good, Better, Best! *Always listen to your heart, because there lives your parents.* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of

Re: $$Excel-Macros$$ How to make dynamic formula for value change on fix date every month

As long as ever you can.” - John Wesley* - On Saturday, March 4, 2017 12:10 AM, Sunil Kumar Yadav < sk.yadav7...@gmail.com> wrote: Dear Paul, Thank you so much for your support but I don't have need formula calculation start from today. It shoul

Re: $$Excel-Macros$$ How to make dynamic formula for value change on fix date every month

mber and removing the > decimal portion > (extract just the integer portion) > then divide it by 2: > =INT(A23*2)/2 > > this works for your samples. > > hope this helps. > > > > *Paul* > - > > > > >

$$Excel-Macros$$ How to make dynamic formula for value change on fix date every month

Dear All, I have two query for automatically update value on one fixed date, have created formula but need dynamic formula. Formula:

Re: $$Excel-Macros$$ copy paste issue from one sheet to another

check it...maybe this is helpful...because i m also learner :-) On Fri, Feb 19, 2016 at 11:43 AM, Kat wrote: > Hi guys, > > I would like to copy paste entire row from king sheet to queen sheet if > the cells in range "B2:B" has the value of "update" in king sheet.

Re: $$Excel-Macros$$ Re: Enabling VB cobe to change cell format with protected sheet format. Excel 2007

No thank you…I'm also learner! On Mon, Oct 26, 2015 at 6:10 PM, Gary Dinges wrote: > Thank You Sir! > > Gary > > On Friday, October 23, 2015 at 2:47:17 PM UTC-4, Gary Dinges wrote: > >> I will start by saying I did search group looking for answer to my issue, >> but

Re: $$Excel-Macros$$ Require formula to find the count targeted till date

Hello, Please check enclosed file. -- Thanks Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 On Tue, Jul 28, 2015 at 1:13 AM, raghu raghuredd...@gmail.com wrote: Hi All We have planned some execution of test cases daily. I would like to have the test conditions planned till date

Re: $$Excel-Macros$$ Ribbon_Gallery_Items

Dear Mr. Ashish, Can u tell me what's wrong in my query? Thanks, Sunil Kr. Yadav Sent from my ASUS On 25-Jul-2015 5:35 pm, Ashish Kumar kumar.ashish...@gmail.com wrote: Dear Sunil Kumar Yadav, Don't violating our group rules. Go thru our group rules once before posting your queries

Re: $$Excel-Macros$$ Ribbon_Gallery_Items

Thanks, Sunil Kr. Yadav Sent from my ASUS On 25-Jul-2015 5:35 pm, Ashish Kumar kumar.ashish...@gmail.com wrote: Dear Sunil Kumar Yadav, Don't violating our group rules. Go thru our group rules once before posting your queries. Regards Ashish Kumar On Sunday, July 19, 2015 at 11:51:58

Re: $$Excel-Macros$$ Ribbon_Gallery_Items

Hi Team, Please revert on this!!! -- Thanks Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 On Sun, Jul 19, 2015 at 11:51 AM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Hi Experts I need your little help...please check my file i want to call my sub processors for three stages

$$Excel-Macros$$ Web_Query_For_Mozilla

, Please guide me any coding for this so that i can run my ID on Mozilla. -- Thanks Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https

Re: $$Excel-Macros$$ Web_Query_For_Mozilla

Dear Vaibhav Sir Please look into this matter! -- Thanks Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 On Sat, Jul 11, 2015 at 12:45 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Hello Team, i have created gmail login query only for example but now i want to run

Re: $$Excel-Macros$$ renaming of pdf files

Dear Siraj, Coding is absolutely fine need to just defined variables...Please check Dim line! and add on error resume next anywhere in coding for Error handling. Dear Mandeep Sir, i m also learner...Excellent Job sir! -- Thanks Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 On Sat

Re: $$Excel-Macros$$ Query in VBA

Hi Soumyendu, PDF -- Thanks Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 On Sat, Jul 11, 2015 at 8:48 AM, Soumyendu Paul soumyendu...@gmail.com wrote: Dear All, My query for attached file When we select data from drop down A cursor to move A6;when we select B from drop down

Re: $$Excel-Macros$$ Change the date in required format in macro and store in variable

Welcome! -- Thanks Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 On Fri, Jul 10, 2015 at 12:14 PM, Ganesh N ganeshg...@gmail.com wrote: Thanks bro Regards, GN On Thu, Jul 9, 2015 at 1:45 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: PFA -- Thanks Regards *Sunil

Re: $$Excel-Macros$$ Change the date in required format in macro and store in variable

PFA -- Thanks Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 On Thu, Jul 9, 2015 at 12:15 PM, Ganesh N ganeshg...@gmail.com wrote: Dear team, Need a help on storing the date in the required format in macro. I can able to do but i showing the current date not the actual date

Re: $$Excel-Macros$$ Loop in filtered value by VBA

Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 On Mon, Apr 27, 2015 at 5:41 PM, Mandeep Baluja rockerna...@gmail.com wrote: change activesheet to Sheets(sheet1) On Monday, April 27, 2015 at 5:41:00 PM UTC+5:30, Mandeep Baluja wrote: Sub Getvalues() Dim r As Range lr = ActiveSheet.Cells

Re: $$Excel-Macros$$ Loop in filtered value by VBA

hi...pls any revert -- Thanks Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 On Sat, Apr 25, 2015 at 3:10 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: My means sometimes LF invoice no. not exist in data that time my filter query got error bcoz filtered value blank i want

Re: $$Excel-Macros$$ Loop in filtered value by VBA

Thank u so much it's working as per my requirement :-) -- Thanks Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 On Mon, Apr 27, 2015 at 3:12 PM, Mandeep Baluja rockerna...@gmail.com wrote: check this out code given Regards, Mandeep Baluja On Monday, April 27, 2015 at 12:42:08 PM

Re: $$Excel-Macros$$ Loop in filtered value by VBA

Dear Mandeep, I need to some modification in this, when no record of LF exist in this data then your query showing error and stop it but I want to go on next step(copy other data) without error or stop Please also check my coding!!! -- Thanks Regards *Sunil Kumar Yadav* Skype ID

Re: $$Excel-Macros$$ Loop in filtered value by VBA

, Sunil Kr. Yadav Sent from my ASUS On 25-Apr-2015 12:17 pm, Vaibhav Joshi v...@vabs.in wrote: hi What do you mean by when sometime no record of LF found then other data past on state sheet with error?? You mean no additional data found ? On Fri, Apr 24, 2015 at 7:35 PM, Sunil Kumar Yadav

$$Excel-Macros$$ Loop in filtered value by VBA

Dear Team, i have read this type query on many sites but not understand properly, please write the code in my file for my data!!! Example file enclosed Please help!!! -- Thanks Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do

Re: $$Excel-Macros$$ How to check a field and change highlight color if the cell value changes

Great Sir Thanks, Sunil Kr. Yadav Sent from my ASUS On 31-Mar-2015 1:36 pm, Vaibhav Joshi v...@vabs.in wrote: Hi Bob, Check attachment, Copy formula from G2 Select A2 to D12 ( or larger range) goto conditional formatting, select manage rules select new rule, after that select use

Re: $$Excel-Macros$$ Query for If condition or VBA

Hello, Please solve this query!!! -- Thanks Regards *Sunil Kumar Yadav* * Sr. Executive - *MIS (Billing Deptt.) Skype ID: sunil.yadav7186 On Tue, Mar 24, 2015 at 5:27 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Dear ​ ​Team, PFA file and check my query. ​ -- Thanks Regards

Re: $$Excel-Macros$$ Query for If condition or VBA

Awesome Sir :-) and thanks -- Thanks Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 On Wed, Mar 25, 2015 at 2:13 PM, Vaibhav Joshi v...@vabs.in wrote: check formula in col E, If there are more than 2 case of overlap then 1st will be shown as ok second will be as error. In case

$$Excel-Macros$$ Query for If condition or VBA

Dear ​ ​Team, PFA file and check my query. ​ -- Thanks Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel

$$Excel-Macros$$ Choose Formula

Dear Experts, I want to know, what can i use choose formula in this file for get the date 1 2 3 etc. -- Thanks Regards Sunil Kumar Yadav -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https

Re: $$Excel-Macros$$ Choose Formula

Good sir :-) and Thank you Sunil On Mon, Feb 9, 2015 at 3:40 PM, Vaibhav Joshi v...@vabs.in wrote: Hi Use this array formula instead=: =INDIRECT('Attn. Sheet.xlsx'!TEXT(DATE($B$1,Month,1),MMM)) check att.. Cheers!! On Mon, Feb 9, 2015 at 1:52 PM, Sunil Kumar Yadav sk.yadav7

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

Hi Myself Sunil Yadav from Delhi. I'm a Sr. MIS Executive in Telecom Sector and recently learned VBA. Excel is my passion i want to learn more and more things about excel and thanks to Vaibhav Sir and Mr. Ashish who guide me everytime when i ask any query! -- Thanks Regards Sunil Kumar Yadav Sr

Re: $$Excel-Macros$$ Loop to check duplicate value

] -- Thanks *Sunil Kumar Yadav* On Mon, Feb 2, 2015 at 4:44 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear experts, Below code is not work to check duplicate value, please know me problem in code. For q = 5 To 1000 If Worksheets(BankData).Cells(q, 4).Value = Worksheets

Re: $$Excel-Macros$$ Loop to check duplicate value

Ok Sorry next time i will keep in my mind. On Mon, Feb 2, 2015 at 5:30 PM, Vaibhav Joshi v...@vabs.in wrote: Dear Ashish Bhalara What exactly you are doing, can you pl explain.. On Mon, Feb 2, 2015 at 4:44 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear experts, Below code is

$$Excel-Macros$$ multi range query in chart

] -- Thanks *Sunil Kumar Yadav* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please

Re: $$Excel-Macros$$ Networkdays

:07 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Hello Ashish, below formula is working same then why have you used MOD in your formula, please little explain! INT(B3-A3)IF(INT(B3-A3)=1, day, , days, )HOUR(B3-A3) hours, MINUTE(B3-A3) minutes On Thu, Jan 29, 2015 at 1:38 PM, Ashish

Re: $$Excel-Macros$$ Networkdays

/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Thanks Regards, Sunil Kumar Yadav -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com

Re: $$Excel-Macros$$ Re: How to Sort Data

to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Thanks Regards, Sunil Kumar Yadav -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ Re: How to Sort Data

...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Thanks Regards, Sunil Kumar Yadav -- Are you =EXP(E:RT) or =NOT(EXP(E:RT

Re: $$Excel-Macros$$ FINDING THE MAXIMUM VALUE IN A NON NUMBERIC COLUMN

Hi kanwaljit Can u explain me how to work your formula, max right i understand but minus why using twice! Pls explain it i know little more array function. On Oct 9, 2014 10:36 PM, Kanwaljit Singh Dhunna kanwal...@gmail.com wrote: Have a Look ! I hope you are aware of how to enter an Array

Re: $$Excel-Macros$$ Amazing Excel formulas...

really amazing!!! *Thanks Regards,Sunil Kumar Yadav* On Wed, Sep 17, 2014 at 5:22 PM, Vaibhav Joshi v...@vabs.in wrote: Hi, No posts since morning thought of sharing amazing excel formulas by Bill Jelen aka Mr. Excel. Cheers!! + *I did not do this for you. God is here working

Re: $$Excel-Macros$$ Auto filter issue

Hi, Anybody revert on this please!!! *Thanks Regards,Sunil Kumar Yadav* On Wed, Sep 3, 2014 at 6:51 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Sorry sir, but i think u r not understand what i want, may be in this my mistake...i tell you again! please find the enclosed file

Re: $$Excel-Macros$$ Auto filter issue

yes but first filter 5 against filter GPRS by contains(all type GPRS), if GPRS not found then sub procedure close or find it then fill Correct. but my create procedure when GPRS not found then fill correct against all number like 6,7,8,9,12 etc. that is wrong. *Thanks Regards,Sunil Kumar Yadav

Re: $$Excel-Macros$$ Auto filter issue

yeah :-), it is absolutely working as per my requirement. Thank you so much! :-) *Thanks Regards,Sunil Kumar Yadav* On Thu, Sep 4, 2014 at 3:13 PM, Vaibhav Joshi v...@vabs.in wrote: Ok, i goofed up in last stat.. Check this now.. On Thu, Sep 4, 2014 at 1:51 PM, Sunil Kumar Yadav

Re: $$Excel-Macros$$ Auto filter issue

Yes, Vaibhav Bhai is rock in VBA, his coding explanation is very sample for understanding. *Thanks Regards,Sunil Kumar Yadav* On Thu, Sep 4, 2014 at 5:23 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Vaibhav Bhai, Superb solutions according to the requirement. Regards Ashish

Re: $$Excel-Macros$$ Auto filter issue

filter GPRS in column D after that software not found 5 in Column H then macro fill correct in all number against like 2,6,7,8...i want to 2,6,7,8 etc not fill it, if 5 not found than macro running stop it. *Thanks Regards,Sunil Kumar Yadav* On Tue, Sep 2, 2014 at 8:22 PM, Vaibhav Joshi v

$$Excel-Macros$$ Auto filter issue

(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Select Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Value = Correct *Thanks Regards,Sunil Kumar Yadav* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page

Re: $$Excel-Macros$$ Vlookup Issue

thank u so much...it's working completely. *Thanks Regards,Sunil Kumar Yadav* On Mon, Sep 1, 2014 at 6:48 PM, Vaibhav Joshi v...@vabs.in wrote: Check this.. Cheers!! On Mon, Sep 1, 2014 at 6:36 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Hello Friends, i have a query