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

2021-03-20 Thread vikas khen
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 u

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

2018-10-12 Thread vikas khen
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 Procur

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

2018-09-25 Thread vikas khen
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 match

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

2018-09-25 Thread vikas khen
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 matches.

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

2018-09-24 Thread vikas khen
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) or

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

2018-07-04 Thread vikas khen
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 kindly h

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

2018-07-02 Thread vikas khen
to my 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: >> &g

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

2018-07-02 Thread vikas khen
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" wrote:

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

2018-07-01 Thread vikas khen
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 arrange t

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

2018-06-30 Thread vikas khen
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 r

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

2018-03-07 Thread vikas khen
Thanks Sourav for your help. On Wed, Mar 7, 2018 at 8:05 PM, sourav devrani wrote: > PFA > > On Wed, Mar 7, 2018 at 5:08 PM, vikas khen wrote: > >> Hi All, >> >> Request all of you to kindly help me on the attached sheet. >> >> >> I need c

$$Excel-Macros$$ Conditional formatting issue

2018-03-07 Thread vikas khen
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 it

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

2017-09-23 Thread vikas khen
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) or

$$Excel-Macros$$

2017-09-16 Thread vikas khen
-- 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, F

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

2017-03-30 Thread vikas khen
Any hope on this _ Regards, Vikken On Wed, Mar 29, 2017 at 3:18 PM, vikas khen 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 > > -- > Are you =EXP(E:R

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

2017-03-29 Thread vikas khen
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 @ https://www

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

2016-12-19 Thread vikas khen
Hi Team Any update regarding on the same?? Regards, On Mon, Dec 19, 2016 at 9:51 AM, vikas khen 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 in Desired format. &g

$$Excel-Macros$$ Need Help for Data

2016-12-18 Thread vikas khen
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 gui

$$Excel-Macros$$ Formula for Conditional Formatting

2016-06-25 Thread vikas khen
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 official

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

2016-06-19 Thread vikas khen
imes 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 wrote: > > > Hi Paul, > > Please find the details in the attached sheet. > > Regards

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

2016-06-17 Thread vikas khen
you can,As long as ever you can.” - John Wesley* > - > > > On Friday, June 17, 2016 5:13 AM, vikas khen wrote: > > > Hi Team, > > Need your help on finding the value in attached sheet. > > Request all of you to kindly help m

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

2016-06-17 Thread vikas khen
Please Help me on this _ On Jun 17, 2016 14:43, "vikas khen" 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. > > -- > Are yo

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

2016-06-17 Thread vikas khen
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 for

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

2016-06-17 Thread vikas khen
Thanks deepak for urgent help Regards, On Jun 17, 2016 13:03, "deepak kumar" wrote: > hi, > > PFA > > On 17 June 2016 at 12:52, vikas khen wrote: > >> Hi all, >> >> >> >> Need your help on attached excel sheet as my vlookup formula is

$$Excel-Macros$$ Help on Vlookup

2016-06-17 Thread vikas khen
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

2016-05-01 Thread vikas khen
tton. > > 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 wrote: > >> Hi Gowrisankar, >&g

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

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

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

2016-04-28 Thread vikas khen
Hi Experts!!! Any Hope regarding on this?? Warm Regards, Vikkhe1 On Thu, Apr 28, 2016 at 6:55 PM, vikas khen wrote: > 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 she

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

2016-04-28 Thread vikas khen
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 o

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

2015-12-23 Thread vikas khen
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 Fa

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

2015-12-02 Thread vikas khen
Hi All, Expecting your valuable reply on this _ Regards, V!kas On Dec 3, 2015 12:32 AM, "vikas khen" wrote: > 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-picke

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

2015-12-02 Thread vikas khen
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 alt

$$Excel-Macros$$

2013-09-11 Thread vikas khen
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 pa

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

2013-07-17 Thread vikas khen
Hi Sir, I checked the same main time but In-vain it can not shows the results in the attendance details calculator. Request you to kindly assist me in briefly *Regards* On Wed, Jul 17, 2013 at 5:58 PM, P.VIJAYKUMAR wrote: > Respected Vikas, > > There is no problem with the tracker.Just enable

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

2013-07-17 Thread vikas khen
Any Hope? Regards On Tue, Jul 16, 2013 at 9:20 PM, Bé Trần Văn wrote: > File your reference, the noorain.ansari > > 2013/7/16 vikas khen > >> Hi Team, >> >> Expecting replay on this mail as It will very helpful for me >> >> Regards >> >>

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

2013-07-16 Thread vikas khen
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 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

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

2013-07-04 Thread vikas khen
gt; > * > > 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

$$Excel-Macros$$ AMC Tracker Sheet

2013-07-03 Thread vikas khen
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

2013-06-30 Thread vikas khen
$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,

$$Excel-Macros$$ Macro Require

2013-06-27 Thread vikas khen
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, accura

$$Excel-Macros$$ Attendance Tracker

2013-06-17 Thread vikas khen
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 @ https://www.facebo

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

2013-05-29 Thread vikas khen
*Hi Team,* thank you very much for helping me Regards On Wed, May 29, 2013 at 1:46 PM, priti verma wrote: > Solution with formula. > PFA > > > On Wed, May 29, 2013 at 1:17 PM, vikas khen wrote: > >> Hi Team, >> >> I have one excel sheet in which i need to

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

2013-05-29 Thread vikas khen
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

$$Excel-Macros$$

2013-05-28 Thread vikas khen
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 @ https://www.facebook.com/dis

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

2013-05-25 Thread vikas khen
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 @ https://www.fac