$$Excel-Macros$$ Need Help of percentage based on condition

Hi Team, I need help on Percentage based on the condition. Units Amount Rate Answer 851400 7821722 7.021,05,496.560 If A2 is >10 and up to 100 then ((A2-10)* 2%)*C2 discount on the amount Now for next up to 500 units percentage will be 1.5% and for units in excess of 500

$$Excel-Macros$$ Need Count data Based on Account reference

Hi Team, I Need Count data Based on Account name. Your help in this regards will be highly appreciated. Desk Location Emp. ID Employee Name Account P4001 #N/A #N/A Administration Account Employee Count #N/A Count P4002 123 ABC Administration Administration 4 2 P4003 345 BCA Procurement

$$Excel-Macros$$ Re: Need help on conditional formating

Please help... On Monday, September 24, 2018 at 5:31:49 PM UTC+5:30, vikas khen wrote: > > Hi All, > > > > Kindly find the attached two sheets, based on the same I need Conditional > formatting formula to highlight the cell value in color it the given > criteria m

Re: $$Excel-Macros$$ Need help on conditional formating

Kindly help on the said issue. Thanks! On Mon, Sep 24, 2018 at 5:31 PM vikas khen wrote: > Hi All, > > > > Kindly find the attached two sheets, based on the same I need Conditional > formatting formula to highlight the cell value in color it the given > criteria matc

$$Excel-Macros$$ Need help on conditional formating

Hi All, Kindly find the attached two sheets, based on the same I need Conditional formatting formula to highlight the cell value in color it the given criteria matches. I have mentioned the criteria in the Book 1. Your help in the regards will be highly appreciated. -- Are you =EXP(E:RT)

Re: $$Excel-Macros$$ Re: Need Macro for Data Fetching from mail to Excel sheet

On Tue 3 Jul, 2018, 08:51 ravikiran kandikonda, wrote: > Hi, Is it a freelance project? How much you want to pay? I can help you on > this. > > On Saturday, 30 June 2018 15:52:29 UTC+8, vikas khen wrote: >> >> Hi Experts, >> >> >> Request you to kind

Re: $$Excel-Macros$$ Re: Need Macro for Data Fetching from mail to Excel sheet

requirement. Regards, On Tue 3 Jul, 2018, 08:51 ravikiran kandikonda, < ravikiran.kandiko...@gmail.com> wrote: > Hi, Is it a freelance project? How much you want to pay? I can help you on > this. > > On Saturday, 30 June 2018 15:52:29 UTC+8, vikas khen wrote: >> >>

Re: $$Excel-Macros$$ Need Macro for Data Fetching from mail to Excel sheet

Team pls pls help... Regards, Vikas Khengre On Mon 2 Jul, 2018, 11:18 vikas khen, wrote: > Hi All, > > It would be very helpful if you could help me regarding on the below said > issue. > > Regards, > VK > > On 30-Jun-2018 1:22 PM, "vikas khen" wro

Re: $$Excel-Macros$$ Need Macro for Data Fetching from mail to Excel sheet

Hi All, It would be very helpful if you could help me regarding on the below said issue. Regards, VK On 30-Jun-2018 1:22 PM, "vikas khen" wrote: Hi Experts, Request you to kindly help me with VBA macro which will fetch the data from *Outlook mail folder* and will arrang

$$Excel-Macros$$ Need Macro for Data Fetching from mail to Excel sheet

Hi Experts, Request you to kindly help me with VBA macro which will fetch the data from *Outlook mail folder* and will arrange the same in required format in excel. Example, I am Sending below mail to every new joiner for getting the desk allocation details from him (Mail 1). When the person

Re: $$Excel-Macros$$ Conditional formatting issue

Thanks Sourav for your help. On Wed, Mar 7, 2018 at 8:05 PM, sourav devrani <souravdevrani1...@gmail.com> wrote: > PFA > > On Wed, Mar 7, 2018 at 5:08 PM, vikas khen <vikk...@gmail.com> wrote: > >> Hi All, >> >> Request all of you to kindly help

$$Excel-Macros$$ Conditional formatting issue

Hi All, Request all of you to kindly help me on the attached sheet. I need conditional formatting for based on following two conditions 1) If the Actual date is less than or equal to Projected date it should highlighted in Green color and 2) If the Actual date is Greater than Projected date

$$Excel-Macros$$ Formula for Month wise calculation

Hi All, Request to all of you that kindly find the attached sheet and help me to calculate Month wise cost by selecting the month and how to represent the same in piot table too. your assistance in this regards will be highly appreciated Thank you *Regards,* *Vikhen* -- Are you =EXP(E:RT)

$$Excel-Macros$$

-- 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 Help, Urgent, Need Help,

Re: $$Excel-Macros$$ Need help on piot table

Any hope on this _ Regards, Vikken On Wed, Mar 29, 2017 at 3:18 PM, vikas khen <vikk...@gmail.com> wrote: > Hi Team, > > Kindly find the attached sheet. In this sheet in need actual value in stud > of 1. hence kindly assist me on this. > > Regards, > VikKhen

$$Excel-Macros$$ Need help on piot table

Hi Team, Kindly find the attached sheet. In this sheet in need actual value in stud of 1. hence kindly assist me on this. Regards, VikKhen -- 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 @

Re: $$Excel-Macros$$ Need Help for Data

Hi Team Any update regarding on the same?? Regards, On Mon, Dec 19, 2016 at 9:51 AM, vikas khen <vikk...@gmail.com> wrote: > Hi all, > > Good Morning!!! > > Team, need help for pooling data from Outlook2016 mails (Which is I kept > in the one folder) to Excel Sheet i

$$Excel-Macros$$ Need Help for Data

Hi all, Good Morning!!! Team, need help for pooling data from Outlook2016 mails (Which is I kept in the one folder) to Excel Sheet in Desired format. my mail contains following data in table format wich I need to export in excel sheet in the same manner. It would be very helpful if you could

$$Excel-Macros$$ Formula for Conditional Formatting

Hi Team, Please find the attached sheet in which i need if the status value (is J column) Open it should highlight entire row by red color. A waiting for your reply on this Regards -- 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

Re: $$Excel-Macros$$ need help on finding the vales in attached sheet

aces you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > ----- > > > On Friday, June 17, 2016 2:54 PM, vikas khen <vikk...@gmail.com> wrote: > > > Hi Paul, > > Please find the

Re: $$Excel-Macros$$ need help on finding the vales in attached sheet

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* > - > > > On Friday, June 17, 2016 5:13 AM, vikas khen <vikk...@gmail.com> wrote: > > > Hi Team, > > Need your help on finding the value in attach

Re: $$Excel-Macros$$ need help on finding the vales in attached sheet

Please Help me on this _ On Jun 17, 2016 14:43, "vikas khen" <vikk...@gmail.com> wrote: > Hi Team, > > Need your help on finding the value in attached sheet. > > Request all of you to kindly help me on this > > please find attached sheet for the reference. &g

$$Excel-Macros$$ need help on finding the vales in attached sheet

Hi Team, Need your help on finding the value in attached sheet. Request all of you to kindly help me on this please find attached sheet for the reference. -- 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

Re: $$Excel-Macros$$ Help on Vlookup

Thanks deepak for urgent help Regards, On Jun 17, 2016 13:03, "deepak kumar" <rk900...@gmail.com> wrote: > hi, > > PFA > > On 17 June 2016 at 12:52, vikas khen <vikk...@gmail.com> wrote: > >> Hi all, >> >> >> >> Need your h

$$Excel-Macros$$ Help on Vlookup

Hi all, Need your help on attached excel sheet as my vlookup formula is not reflecting the value. -- 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

Re: $$Excel-Macros$$ Need Macro/Solution for the attached sheet

mmand button. > > it will run for more dates and more persons also. > > u paste your details in input sheet and run the macro. it will create the > report. > > Regards, > A Gowrisankar. > > On Fri, Apr 29, 2016 at 2:29 PM, vikas khen <vikk...@gmail.com> wrote: >

Re: $$Excel-Macros$$ Need Macro/Solution for the attached sheet

, Gowrisankar Arthanari GSA < a.go...@gmail.com> wrote: > hi, > > PFA > > Regards, > A Gowrisankar​ > > On Fri, Apr 29, 2016 at 10:20 AM, vikas khen <vikk...@gmail.com> wrote: > >> Hi Experts!!! >> >> Any Hope regarding on this?? >> &g

Re: $$Excel-Macros$$ Need Macro/Solution for the attached sheet

Hi Experts!!! Any Hope regarding on this?? Warm Regards, Vikkhe1 On Thu, Apr 28, 2016 at 6:55 PM, vikas khen <vikk...@gmail.com> wrote: > Hi Team, > > > > Please find the attached sheet in which there are two different sheets one > is INPUT and other one is require

$$Excel-Macros$$ Need Macro/Solution for the attached sheet

Hi Team, Please find the attached sheet in which there are two different sheets one is INPUT and other one is required OUTPUT based on input sheet. Also I need specific word from Input sheet (ENTRY or EXIT) and reflect the same in to status row i.e. on E Column respectively. Your help

$$Excel-Macros$$ Need Help on attached sheet

Dear Team, Please find the attached excel sheet in which the raw data is sheet 1 and the required output is in Sheet 2. It would be very helpful if you help me on this. Regards -- 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

$$Excel-Macros$$ Need Help on attached sheet

Hello Everyone, Please find the above attached sheet in which i need your help on the below said points. 1) When i click on date the Date-picker should be popup and when i select the date it should enter only in cell *E6.* 2) All column of Saturday and Sunday needs to be highlighted in color

Re: $$Excel-Macros$$ Need Help on attached sheet

Hi All, Expecting your valuable reply on this _ Regards, V!kas On Dec 3, 2015 12:32 AM, "vikas khen" <vikk...@gmail.com> wrote: > Hello Everyone, > > Please find the above attached sheet in which i need your help on the > below said points. > > 1) When i cl

$$Excel-Macros$$

Hello everyone Is there anyone in the group having Good Stock register for material Inventory or PHP based code for the same. If yes, I request to share with us. Regards -- 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

Re: $$Excel-Macros$$ Help need on attached Excel

Any Hope? Regards On Tue, Jul 16, 2013 at 9:20 PM, Bé Trần Văn betnmtdongna...@gmail.comwrote: File your reference, the noorain.ansari 2013/7/16 vikas khen vikk...@gmail.com Hi Team, Expecting replay on this mail as It will very helpful for me Regards On Thu, Jul 11, 2013 at 1:43

Re: $$Excel-Macros$$ Help need on attached Excel

Hi Team, Expecting replay on this mail as It will very helpful for me Regards On Thu, Jul 11, 2013 at 1:43 PM, vikas khen vikk...@gmail.com wrote: Hi Experts, I have found below attached Excel tracker on group it's Fantastic it's amazing! but i need to understand how it's Attendance

Re: $$Excel-Macros$$ Re: AMC Tracker Sheet

* Thanks On Wednesday, July 3, 2013 6:54:24 PM UTC+5:30, vikas khen wrote: Dear all, Does anybody have AMC Tracker Template/Sheet ? Regards -- 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

$$Excel-Macros$$ AMC Tracker Sheet

Dear all, Does anybody have AMC Tracker Template/Sheet ? Regards -- 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

Re: $$Excel-Macros$$ Macro Require

...@gmail.com Subject: Re: $$Excel-Macros$$ Macro Require To: excel-macros@googlegroups.com Date: Thursday, June 27, 2013, 7:09 PM why need macro ?try pivot table please find attached file . Enjoy Team XLS On Thu, Jun 27, 2013 at 6:30 PM, vikas khen vikk

$$Excel-Macros$$ Macro Require

Dear All, Please find the excel sheet. I need macro for the same Regards -- 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,

$$Excel-Macros$$ Attendance Tracker

Hi, Any anybody Have Attendance Tracker excel sheet? I need this for my Organization purpose. Waiting for Positive Reply. Regards -- 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 @

$$Excel-Macros$$ Need help/Formula/macro on Transpose command

Hi Team, I have one excel sheet in which i need to arrange the data in such a manner that all the data will come with the help of transpose option under the one by one. i had try this by many methods but in-vain. Hence please kindly suggest formula me or share the Macro for the same. Please find

Re: $$Excel-Macros$$ Need help/Formula/macro on Transpose command

*Hi Team,* thank you very much for helping me Regards On Wed, May 29, 2013 at 1:46 PM, priti verma pritiverma1...@gmail.comwrote: Solution with formula. PFA On Wed, May 29, 2013 at 1:17 PM, vikas khen vikk...@gmail.com wrote: Hi Team, I have one excel sheet in which i need to arrange

$$Excel-Macros$$

Hi any one have Macro based inventory management worksheet??? If yes please provide me as i want for my company Regards -- 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 @

$$Excel-Macros$$ Material In Out Register (Stock Register)

Hello Group, Anybody have material In Out Register Sheet (Stock Register) If yes request you to kindly mail the same. Thanks regards -- 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 @