$$Excel-Macros$$ Re: need excel job frasher

2017-05-23 Thread Pramod Singh
Hey guys If any one have opening in excel frasher job pls call me 9990517398 I looking job urgency basis. 🙏 On 23 May 2017 1:26 p.m., "Vijayendra Rao" wrote: Hi Experts, I have created one reconciliation statement in which I need to do many manual work. Is there any option which i can ea

Re: $$Excel-Macros$$ Formula for Conditional Formatting

2016-06-26 Thread Pramod Singh
Please find the attached file :) On Sun, Jun 26, 2016 at 12:27 PM, vikas khen wrote: > 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 yo

Re: $$Excel-Macros$$ VBA developer job in Gurgaon

2016-03-15 Thread Pramod Singh
Bro have u knowledge of Excel automation? Pramod On 15 Mar 2016 14:24, "Anil Gawli" wrote: > > > On Tue, Mar 15, 2016 at 1:08 PM, Pramod Singh wrote: > >> This is notify to all guys who have good knowledge of VBA programming. >> I have un Opning for the p

$$Excel-Macros$$ VBA developer job in Gurgaon

2016-03-15 Thread Pramod Singh
This is notify to all guys who have good knowledge of VBA programming. I have un Opning for the post of Vba developer. Please contact me on below mention details if any one interested. Profile Vba developer Location Gurgaon Contact 9899650234 Pramod Singh. -- Are you =EXP(E:RT) or =NOT(EXP

Re: $$Excel-Macros$$ V LOOK UP QUERY

2016-02-08 Thread Pramod Singh
PFA... On Mon, Feb 8, 2016 at 6:21 PM, big smile wrote: > Respected Excel Guru's > I am giving inputs to calculate desire Eligibility % > Inputs given as per b16-c16-d16 > & by this 3 input I have to check > From the above table ie B 3 to F 7 it should search all criteria > then give result i

Re: $$Excel-Macros$$ Re: Macro to create attendance Sheet for each Employee

2015-11-21 Thread Pramod Singh
Akash. Kinldy Share Excel File On Sat, Nov 21, 2015 at 9:01 PM, Akash Singh wrote: >> Hi, > > Can anyone guide who write a code in VBA in excel to find the employee > attendance record or check whether employee working more than 6 day in a > week > > akash > > -- > Are you =EXP(E:RT) or =NOT(EXP(

Re: $$Excel-Macros$$ Replace cell value "0" to header cell

2015-09-20 Thread Pramod Singh
Hi Expert. Q. (*Pramod Bisht) Need to get:- (Pramod Bisht) By Text formula... Pramod On 19 Sep 2015 17:54, "nyree" wrote: > Hello Abhishek > > That's pefect! Thank you so much for your quick response > Regards > Nyree > > > On 19-Sep-15 2:20 PM, Abhishek Jain wrote: > > Please see attached > >

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

2015-06-26 Thread Pramod Singh
Cheers Karanam ..and Welcome in this Group. . Pramod On 26 Jun 2015 21:51, "Karanam Srinivas" wrote: > Hi , > > I am Srinivas Karanam from Hyderabad. I am working as Financial Analyst in > Hyderabad. > > We regularly use macros to download report, check the control points and > report to client.

Re: $$Excel-Macros$$ Re: Query to retreive data

2015-04-28 Thread Pramod Singh
Why not you are using MS Access. It's pretty cool and can we use easy.. this is best for if some one have to work in large data Pramod On 28 Apr 2015 15:41, "Mandeep Baluja" wrote: > Yes it works, Thanks for the same we can considered this issue is > resolved. But one thing Excel is not usef

Re: $$Excel-Macros$$ formula required

2015-04-02 Thread Pramod Singh
PFA... On Fri, Apr 3, 2015 at 12:06 PM, Rajesh Agarwal wrote: > Hi > Required formula in B1 > > -- > Rajesh Kumar Agarwal > 9811063001 > > -- > 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 @ > h

Re: $$Excel-Macros$$ Calender Control

2015-03-31 Thread Pramod Singh
Bro u need install Microsoft Activex control go in activex.microsoft.com and click control. Pramod On 31 Mar 2015 16:26, "Rakesh kumar" wrote: > Hi, > > I am using Excel 2010 and I want to use Date Picker(Calender) in Excel > sheet. > but Calender control is not showing on Additional Con

Re: $$Excel-Macros$$ How to show VBA code in *.xlsm format file

2015-03-30 Thread Pramod Singh
Hi There is not vba code. This is just made by custom UI editor. ..there is control by made in Custom UI editor. Pramod On 31 Mar 2015 11:02, "Ashish Bhalara" wrote: > Dear experts, > > I have downloaded some files with macro to editing in ribbon for learning > purpose, but I can't see coding i

Re: $$Excel-Macros$$ Re: Find Second Highest value from data

2015-03-27 Thread Pramod Singh
Hi All. Good question came from amit. Excel expert. Can anyone get the large second value from the list without using large function not sheet function and not vba function. Take the range(a1:a15) and make the logic there. Pramod On 27 Mar 2015 11:41, "Mandeep Baluja" wrote: > did you tried t

Fwd: $$Excel-Macros$$ PLS SOLVE

2015-03-08 Thread Pramod Singh
Hi David. .. PFA Pramod -- Forwarded message -- From: "Pramod Singh" Date: 9 Mar 2015 11:33 Subject: Fwd: $$Excel-Macros$$ PLS SOLVE To: "Pramod Singh" Cc: Pramod -- Forwarded message -- From: Date: 9 Mar 2015 10:05 Subject: $$Excel-Macros

Re: $$Excel-Macros$$ Help required - alternate sorting

2015-02-03 Thread Pramod Singh
Send with Excel file where you want to do this. Pramod On 3 Feb 2015 17:25, "singla.kris...@gmail.com" wrote: > Hi, > > Can somebody please help me in a small macro. My sheet have a column with > some values and I want to sort them alternately. > > Current > Dr. > Cr. > Dr. > Dr. > Cr. > Cr. > C

Re: $$Excel-Macros$$ How to change texts into numbers by macro

2014-11-09 Thread Pramod Singh
Your welcome Ivaana Regards Pramod Www.facebook.com/Pramodbish Pramod On 9 Nov 2014 18:45, "ivavok" wrote: > Hi, > > thank you, that´s perfect! > > Dne neděle, 9. listopadu 2014 5:08:16 UTC+1 pramodb35 napsal(a): >> >> Hi Dear, >> >> >> Please find the attached file. Hope this will be fine for

Re: $$Excel-Macros$$ Transpose Several Rows to Columns

2014-11-09 Thread Pramod Singh
Can u send us with a big dummy data. Then we can change on this. Pramod On 9 Nov 2014 19:11, "prkhan56" wrote: > Thanks > Works great > A small problem > The date comes as serial no. in transposed data > Can you fix this please > > Regards > > On Sunday, November 9, 2014 4:18:10 PM UTC+4, pram

Re: $$Excel-Macros$$ Transpose Several Rows to Columns

2014-11-09 Thread Pramod Singh
Hi Prkhan, PFA... On Sun, Nov 9, 2014 at 1:48 PM, prkhan56 wrote: > Hello All, > I am using Excel 2010 > I need a macro to transpose several Rows into respective Columns > > Please see attached sample file for 'Before' and 'After' > > TIA > > Rashid > > -

Re: $$Excel-Macros$$ How to change texts into numbers by macro

2014-11-08 Thread Pramod Singh
Hi Dear, Please find the attached file. Hope this will be fine for you. Regards Pramod On Sun, Nov 9, 2014 at 1:05 AM, ivavok wrote: > Hi PramodSingh , > > Thank you for the funtion! Sorry I did not mention but the comma is a > decimal comma not between thousands. So for example the fi

Re: $$Excel-Macros$$ How to change texts into numbers by macro

2014-11-08 Thread Pramod Singh
Hi ivana, Please find the attached file as your reference... On Sat, Nov 8, 2014 at 1:46 PM, ivavok wrote: > Hi, > > I have tried it before too but it does not work. It does not delete "KÄŤ" at > all...When I run my macro, I get the data in the table attached. "KÄŤ" is > deleted but spaces are

Re: $$Excel-Macros$$ Userform - Login

2014-11-03 Thread Pramod Singh
Hi All. User id 123456 Password: 321 REgards Pramod On Mon, Nov 3, 2014 at 6:48 PM, Ashish Kumar wrote: > Hi, > > Try this UserName & password. > > UserID - 123456 > Password - secret > > > Regards > Ashish > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =T

Re: $$Excel-Macros$$ Userform - Login

2014-11-02 Thread Pramod Singh
-in macros >> enable else disable >> >> thanks >> >> On Sun, Nov 2, 2014 at 6:24 PM, joseph camill >> wrote: >> >>> Hi Pramod, >>> >>> Thank you for the file, but I am unable to log-in. Checked the password, >>> in the s

Re: $$Excel-Macros$$ Userform - Login

2014-11-02 Thread Pramod Singh
Hi Dear, PFA.. Regards Pramod On Sun, Nov 2, 2014 at 4:33 AM, joseph camill wrote: > Hi experts, > > With the help of various online help have managed to work on few codes in > userform. > > I need two help: > 1. Get error when I "Update password", please help me rectify >

Re: $$Excel-Macros$$ Produce CSV file as a output file by using the values/Data's from the Excel worksheet

2014-10-25 Thread Pramod Singh
Hi Laxman Can you save all data in one file. And then explain which is ur input tab. And how is your output Need more explain. Pramod On 25 Oct 2014 21:15, "Laxmanan M" wrote: > Pls help me.. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,

Re: $$Excel-Macros$$ Automatic update excel file from website

2014-10-25 Thread Pramod Singh
Share the with excel file ... which text / details you want extract... On Sat, Oct 25, 2014 at 2:17 PM, B Sharma wrote: > Dear Excel Gurus, > I am trying to update my excel sheet which contains the TIN number of some > of the registered tax payers with their contact details and a

Re: $$Excel-Macros$$ VBA code for convert numbers (RS to USD & AED to USD)

2014-10-25 Thread Pramod Singh
Hi Amar, Please find the attached file as per your requirement. On Sat, Oct 25, 2014 at 2:29 PM, Pramod Singh wrote: > Hi Amar, > > After change value. link should remove and paste value multiply with > conversion.?? > > > Regards > Pramod > > On Sat, Oct 25,

Re: $$Excel-Macros$$ VBA code for convert numbers (RS to USD & AED to USD)

2014-10-25 Thread Pramod Singh
ers are only converted. > Regards > Amar > > On Sat, Oct 25, 2014 at 12:19 PM, Pramod Singh wrote: >> Need more explanation... in your first sheet there are many number and >> link each other. so explain more. >> >> On Sat, Oct 25, 2014 at 11:48 AM, amar takale

Re: $$Excel-Macros$$ Please help on VBA- adjustments of a table with data

2014-10-25 Thread Pramod Singh
Hi ivavok , Please find the attached file as per your requirement... On Fri, Oct 24, 2014 at 5:31 PM, ivavok wrote: > Hello, > > I would be grateful for help. I have had some break using VBA and I now need > to get the table attached adjusted in a certain way to be able to work with >

Re: $$Excel-Macros$$ VBA code for convert numbers (RS to USD & AED to USD)

2014-10-24 Thread Pramod Singh
Need more explanation... in your first sheet there are many number and link each other. so explain more. On Sat, Oct 25, 2014 at 11:48 AM, amar takale wrote: > Dear champs > > Above as per my explanation one thing remember that conversion rate is > "MY RATE" which is mention in sheet.As per

Re: $$Excel-Macros$$ Serial Number macro problem

2014-10-14 Thread Pramod Singh
Your welcome Mr Renuka... Pramod On 15 Oct 2014 10:12, "renuka chari" wrote: > Thank you mr. Pramod, this is only i am expecting thanks alot.. > > > > On Wednesday, 15 October 2014 08:59:44 UTC+5:30, pramodb35 wrote: >> >> Hi Renukachari, >> >> >> Please find the attachment as per your requi

Re: $$Excel-Macros$$ Serial Number macro problem

2014-10-14 Thread Pramod Singh
Hi Renukachari, Please find the attachment as per your requirement.. On Wed, Oct 15, 2014 at 12:10 AM, Paul Schreiner wrote: > I'm sorry, but there's nothing in the attachment that describes any type of > "serial number". > > In fact, I'm not even sure WHAT it is describing. > It seems

Re: $$Excel-Macros$$ Crack Password on MS Excel Template

2014-10-11 Thread Pramod Singh
Yes Priyanka. You are right this is against the forums rules no. 3 Regards Pramod On Sat, Oct 11, 2014 at 4:25 PM, Priyanka Sachdeva wrote: > Dangerous Proposition discussing on how to crack passwords for VBA Coding. > Guess its against the forums rules > > Regards, > Priyanka S > > On Sat, Oct

Re: $$Excel-Macros$$ Job Opening for MIS profile.

2014-10-07 Thread Pramod Singh
Hi All. I have also one Opning in my company. As MIS profile. Salary 19 k and pickup and drop and also meals . Regards Pramod Pramod On 8 Oct 2014 09:51, "Ashish Kumar" wrote: > Hi Friends > > We have 2 Openings for MIS profile. > > Experience - 1 to 2 Yrs > Salary - 10 K (Take Home) + ESI

Re: Re: $$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)

2014-10-04 Thread Pramod Singh
Hi SUDHIR VERMA PFA File as you require On Wed, Oct 1, 2014 at 10:30 PM, Vaibhav Joshi wrote: > What is criteria for false condition? > > On Oct 1, 2014 9:07 PM, "SUDHIR VERMA" wrote: >> >> Dear Vaibhav, >> >> Thanx for new intellectual property of coding. But there is all conditions >> a

Re: $$Excel-Macros$$ Macro to highlight Max Value in a Column and copy/transpose data in another file

2014-09-24 Thread Pramod Singh
Hi Dear. You can self change of range that which range u want and remove the come workbook.save /close. And create one new modul anf paste that code. Thanks P Pramod On 24 Sep 2014 14:38, "prkhan56" wrote: > Hi Pramod > Thanks for your response. > If you check my Input data sheet on File 1 o

Re: $$Excel-Macros$$ Macro to highlight Max Value in a Column and copy/transpose data in another file

2014-09-23 Thread Pramod Singh
Hi prkhan56 , Please find the your second macro.Kindly see the path as i mention your attached file.[File2.xlsb] your will be second file. Thanks P On Tue, Sep 23, 2014 at 9:23 PM, prkhan56 wrote: > > > Hello All, > Can someone help me with the Second Macro? > Thanks > On Monday, September 2

Re: $$Excel-Macros$$ Macro to highlight Max Value in a Column and copy/transpose data in another file

2014-09-22 Thread Pramod Singh
Hi Dear, Please find the Attached file ... Regards P On Mon, Sep 22, 2014 at 2:53 PM, prkhan56 wrote: > Dear All, > > I am using Excel 2010 and have attached a file with my problem. > > I need Two Macros for my problem. > > > > There are two Files (both in a shared location - Path S:\...\...\

Re: $$Excel-Macros$$ Need help with time sheet

2014-09-14 Thread Pramod Singh
Hi Ujjwal. PFA... Thanks P -- 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

Re: $$Excel-Macros$$ Need help with time sheet

2014-09-14 Thread Pramod Singh
Hi Ujjawal. U want each tym in earch row and save.. When click button. Pramod On 14 Sep 2014 11:46, "Ujjwal Desai" wrote: > Hi Pramod, > > Can you please advise ??. > > Thanks, > Ujjwal > > -- > 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) ! Jo

Re: $$Excel-Macros$$ Need help with time sheet

2014-09-08 Thread Pramod Singh
Hi Ujjwal... PFA. On Tue, Sep 9, 2014 at 1:09 AM, Ujjwal Desai wrote: > Hello , > > I need your help in regards with the attached timesheet. > > 1.The Time should be captured for each row separately. > 2.Reset tab vba code is not working properly. > > Please provide your inp

Re: $$Excel-Macros$$ Solution Requested

2014-09-05 Thread Pramod Singh
Ur Welcome P On Fri, Sep 5, 2014 at 10:43 PM, Nagendra Joshi wrote: > Thanks Buddy, > > For your support. > > > On Fri, Sep 5, 2014 at 8:46 AM, Pramod Singh wrote: > >> Hi Joshi, >> >> >> PFA.

Re: $$Excel-Macros$$ Solution Requested

2014-09-04 Thread Pramod Singh
Hi Joshi, PFA. On Thu, Sep 4, 2014 at 10:20 PM, Nagendra Joshi wrote: > Dear Team, > > Please find the enclosed file which contains many sheets but i need a > solution regarding the first & second sheet. > > First sheet is a dump which is directly entered by the fi

Re: $$Excel-Macros$$ modify a macro to have startCol and endCol

2014-09-02 Thread Pramod Singh
Hi Bill PFA... On Wed, Sep 3, 2014 at 10:55 AM, Mr_Bill wrote: > I appreciate the effort but that doesnt work correctly. > > > On Tuesday, September 2, 2014 8:52:50 PM UTC-7, pramodb35 wrote: > >> Hi Bill >> >> Please find the attached fi

Re: $$Excel-Macros$$ Need macro to covert pdf to excel

2014-09-02 Thread Pramod Singh
Hi Ujjwal. Please find the below links for your requirement. http://www.myengineeringworld.net/2013/03/vba-macro-to-convert-pdf-files-into.html P On Tue, Sep 2, 2014 at 10:58 PM, Ujjwal Desai wrote: > Hello guys, > > Still awaiting for your response. > > Ujjwal > > -- > Are you =EXP(E:R

Re: $$Excel-Macros$$ modify a macro to have startCol and endCol

2014-09-02 Thread Pramod Singh
Hi Bill Please find the attached file . P On Wed, Sep 3, 2014 at 1:17 AM, Mr_Bill wrote: > I currently have a macro that works for columns 1:5 > > I would like to know how would I make the script work with columns 7:11 > with 10 being the sortKeyCol. > > Not sure what I need to chang

Re: $$Excel-Macros$$ Need Help - Show (-) Value

2014-09-01 Thread Pramod Singh
Hi Ashu, PFA..As per your requirement.. On Tue, Sep 2, 2014 at 10:39 AM, Ashu k wrote: > Dear Seniors, > > If I have value in Column A and B. A value is 1 and B value is 12000 > than -2000 is showing in C column & Highlight Column C with Blinking. > > Like :

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

2014-08-28 Thread Pramod Singh
Welcome Marty chrs for u.. Pramod On 27 Aug 2014 22:56, "Marty Girvan" wrote: > hello, My name is Marty and I work at Boeing in Washington. I use Excel, > VBA and some other tools for daily tasks. Glad to see all the contributors > and posts. Let the learning begin. > > Marty > > -- > Are

Re: $$Excel-Macros$$ Only Excel formuala

2014-08-25 Thread Pramod Singh
Hi Kamal Ganeshan Please find the attached file i cheersss Regards Pramod On Tue, Aug 26, 2014 at 12:16 AM, Kamal Ganeshan wrote: > Hi Friends, > > Can anyone help me with the excel formula for the attached list of question > > Regards, > Ganeshan > > -- > Are you =EXP(E:RT) or =NOT(EXP(

Re: $$Excel-Macros$$ Re: VBA questions

2014-08-11 Thread Pramod Singh
Hi Kapil, Please find the Answer for your VBA Q... One Q has been left.you can take ans from do google.. Regards Pramod On Tue, Aug 12, 2014 at 12:27 AM, kapil Gupta wrote: > Please solve this question is very urgent. > > On Sunday, August 3, 2014 11:51:07 PM UTC+5:30, kapil Gupta

Re: $$Excel-Macros$$ Shorter way of getting sum of each column using VBA

2014-08-06 Thread Pramod Singh
Hi Danj, PF below is code. i = Sheet1.Cells(Sheet1.Rows.Count, "K").End(xlUp).Row Sheet1.Range("K" & i + 1).Value = WorksheetFunction.Sum(Sheet1.Range("K1:K" & i + 1)) change columns in K for *O, P, T, U, and V...* Regards Pramod On Thu, Aug 7, 2014 at 8:50 AM, 'DanJ' via MS EXCEL A

Re: $$Excel-Macros$$ Combining six IF formula into one formula

2014-07-25 Thread Pramod Singh
Your Welcome.. On Sat, Jul 26, 2014 at 9:48 AM, Nur Hossain wrote: > Hi Pramod da, > > It works perfectly , thanks for your supports > > > On Sat, Jul 26, 2014 at 9:58 AM, Pramod Singh wrote: > > H Nur, > > > > Your Formula wil

Re: $$Excel-Macros$$ Combining six IF formula into one formula

2014-07-25 Thread Pramod Singh
H Nur, Your Formula will be =IF(A1="Red","us2",IF(A1="Sta","ru2",IF(A1="Ida","Cu2",IF(A1="Pco","Us3",IF(A1="Pde","Cu3","") Regards Pramod On Sat, Jul 26, 2014 at 9:22 AM, Nur Hossain wrote: > Dear all , how to merge following six formula into single formula. > small formula is requir

Re: $$Excel-Macros$$ Problem for copy and paste range in one sheet to other sheet

2014-07-17 Thread Pramod Singh
What is error going on..Completely explain On Fri, Jul 18, 2014 at 2:00 AM, Renukachari Kasee wrote: > Dear Experts please help me in this regard. > > my macro was not working properly > > please help me...its urgent > > > > > > > > *(¨`•.•´¨) Always`•.¸(¨`•.•´¨) Keep(¨`•.•´¨)¸.•´ Smiling!!

Re: $$Excel-Macros$$ Re: Multiple Web Page Extraction

2014-07-16 Thread Pramod Singh
Hi Bill, The website is so heavy so it is taking lot of time to load .I am also working on it from another method. Regard Pramod On Thu, Jul 17, 2014 at 7:23 AM, Bill Q wrote: > Pramod, > > Would you have any idea why it stops ? > > On Monday, July 14, 2014 7:16:58 AM UTC-4, Bill Q wr

Re: $$Excel-Macros$$ Re: How to direct multiple hyperlink ?

2014-07-16 Thread Pramod Singh
> CHINA Hong Kong Chennai Sea NOS 25 1,32,800 5,312 > https://www.zauba.com/import-tm T82 printer pos-hs-code.html > > > Thanking you > Regards, > Nitya > > > On Tue, Jul 15, 2014 at 12:10 PM, Nitya > wrote: > >> Perfectly working, thank you Pramod sir and victor

Re: $$Excel-Macros$$ Half day formula

2014-07-15 Thread Pramod Singh
Need More Explain Plzzz With Example ... Warm Regards Pramod On Tue, Jul 15, 2014 at 5:21 PM, Shamugam Pillai wrote: > > > Hi > > First time posting and am not sure if this is the right platform but I > have this attendance template and I'm unsure of how to input the formula > for half day tak

Re: $$Excel-Macros$$ Re: How to direct multiple hyperlink ?

2014-07-14 Thread Pramod Singh
Hi Nitya, Please find the Attached file. As per your requirement.. Hope This will fine for you. Warm Regards Pramod Bisht On Tue, Jul 15, 2014 at 9:23 AM, Nitya wrote: > Dear Experts, > > Any update on this. Thanks. > > From: Nitya > Date: Mon, Jul 14, 2014 at 5:17 PM > Subject: How to dir

Re: $$Excel-Macros$$ Multiple Web Page Extraction

2014-07-13 Thread Pramod Singh
Hi Bill, What you want to extract from your hyperlink... Can You explain Completely... :) Regards Pramod On Mon, Jul 14, 2014 at 12:21 AM, Bill Q wrote: > Hi, > > I would like to have (hopefully) a simple code made to extra all the pages > from a URL.This URL is static and requires that

Re: $$Excel-Macros$$ - merge and pivot excels

2014-07-13 Thread Pramod Singh
Need more explain on this topic.plzzz Pramod On 13 Jul 2014 14:48, "pradeep palande" wrote: > Can someone help me on this please.. i am in need of this and looking for > solution otherwise i have to keep suffering for hours every day. thanks in > advance > > > On Sun, Jul 13, 2014 at 1:11 AM

Re: $$Excel-Macros$$ Re: Look for date/time stamp when any cells in a particular row are modified.

2014-07-07 Thread Pramod Singh
ALL u thank u . who giving challenging task like ur.. On Tue, Jul 8, 2014 at 7:30 AM, Ashish Kumar wrote: > Welcome !! > > On 7 July 2014 22:47, Vaibhav Joshi wrote: > >> Great!! Cheers!! >> >> >> On Mon, Jul 7, 2014 at 9:32 PM, Bill Q wrote: >> >>> Perfect. Thanks for all your h

Re: $$Excel-Macros$$ Re: Look for date/time stamp when any cells in a particular row are modified.

2014-07-06 Thread Pramod Singh
Hi Bill Q, Please find the Attachment as per your requirement. Warm Regards Pramod On Mon, Jul 7, 2014 at 1:03 AM, Bill Q wrote: > See attached spreadsheet. > > - Starts off with time it was entered. > - Anytime a specific cell in a specific row is modified the "K" cell (for > that row on

Re: $$Excel-Macros$$ Look for date/time stamp when any cells in a particular row are modified.

2014-07-06 Thread Pramod Singh
explain with sample files pl On Sun, Jul 6, 2014 at 11:23 PM, Bill Q wrote: > Hi, > > Example: > > - The date/time stamp would be in cell K1. > - If any cell between A1 and J1 are modified, K1 would automatically > reflect the new date and time. > > Thanks. > > -- > Are you =EXP(E:RT) or =N

Re: $$Excel-Macros$$ Re: Extract duplicate data and run calculation- macro request

2014-06-27 Thread Pramod Singh
Hi Missy, PFA It's My Pleasure to help your. And do not say thanks yaar Be happy. Pramod On Fri, Jun 27, 2014 at 4:05 PM, Missy786 wrote: > Dear Pramod, > > Thank you for your reply back. > > I am writing to request, if it is possible to update the code, so it also > extracts the n

Re: $$Excel-Macros$$ Sort VBA Code Challenging difficult work

2014-06-27 Thread Pramod Singh
Not Sure What you are saying. Need more description. On Fri, Jun 27, 2014 at 11:28 AM, amar takale wrote: > Dear All friends > > Can anyone suggestion pls? > > On Wed, Jun 25, 2014 at 12:17 PM, amar takale > wrote: > > Dear Expert team > > > > I Required code for sort data as per criteria

Re: $$Excel-Macros$$ Help with Complex formula

2014-06-26 Thread Pramod Singh
Welcom steve Pramod On 27 Jun 2014 01:18, "Steve Weaver" wrote: > Pramod, > > Thank you . . . Works perfectly! > > Steve > > > Sent from my iPhone > > On Jun 26, 2014, at 2:09 PM, Pramod Singh wrote: > > Hi Steve, > > Hope this will fine

Re: $$Excel-Macros$$ Re: Extract duplicate data and run calculation- macro request

2014-06-26 Thread Pramod Singh
Dear Missy psw :35854889 warm welcome.. On Thu, Jun 26, 2014 at 10:42 PM, Paul Schreiner wrote: > In case you'd consider another solution: > > I created sample data ( 50,775 rows) > it has 9900 different user names with sample prices and dates between 6/1 > and 6/10. > > 1475 of the name/dat

Re: $$Excel-Macros$$ Re: Extract duplicate data and run calculation- macro request

2014-06-26 Thread Pramod Singh
Hi Missy, Please file the attached file which you have required. Regards Pramod VBA Delevoper . On Thu, Jun 26, 2014 at 7:10 PM, Paul Schreiner wrote: > Would you please send me a file with a larger sample? > schreiner_p...@att.net > I just need the name, price and date columns, you can clear

Re: $$Excel-Macros$$ Re: Extract duplicate data and run calculation- macro request

2014-06-26 Thread Pramod Singh
Hi, You told that you have 5 row data. if macro will run there so time will be take a lot. Regards Pramod On Thu, Jun 26, 2014 at 3:09 PM, Missy786 wrote: > Thank you for your solution and help. I am ideally looking for a macro, >> which can extract the names and prices, hence I would l

Re: $$Excel-Macros$$ Extract duplicate data and run calculation- macro request

2014-06-26 Thread Pramod Singh
You Can use Pivot Table. PFA. On Wed, Jun 25, 2014 at 9:53 PM, Missy786 wrote: > Dear all, > > I would like to be able to extract certain data from one sheet to another > using the macro condition, as explained below, please. > > Logic: > find duplicate names (column A), If same name occurs mo

Re: $$Excel-Macros$$ Excel Macros for Interest Calculation

2014-06-22 Thread Pramod Singh
Can't Understand . What is your Skype ID. for discussed. Pramod my ID:- Pramodb35 On Sun, Jun 22, 2014 at 2:45 PM, Kalpesh Shivdas wrote: > Hi Group > > > Can anyone help me on this > > Currently I am using (IF) formula for doing this calculation with is > very long & confusing. > > I have

Re: $$Excel-Macros$$ Date Format Query

2014-06-13 Thread Pramod Singh
t; On Thu, Jun 12, 2014 at 4:22 PM, Pramod Singh wrote: > >> Hi >> Pravin Gunjal, >> >> PFA >> >> Hope This will fine for you.. >> >> >> >> >> Warm Regards >> >> Pramod >> >> VBA Developer >> >

Re: $$Excel-Macros$$ Date Format Query

2014-06-12 Thread Pramod Singh
Hi Pravin Gunjal, PFA Hope This will fine for you.. Warm Regards Pramod VBA Developer On Thu, Jun 12, 2014 at 3:12 PM, Pravin Gunjal wrote: > Hi, > > I wanted to convert the dates in this format *DD.MM.* > > Now it is not in system's date format ( MM/DD/ ) and it is displaye

Re: $$Excel-Macros$$ Average of Average in Excel

2014-06-05 Thread Pramod Singh
thanks 4 share your ideas. On Tue, Jun 3, 2014 at 5:07 PM, Paul Schreiner wrote: > probably, but why? > the number usually isn't valuable. > > if you have a set of 100 numbers, and the average is 10 > another set of 500 numbers, and the average is 20 > and a set of 1000 numbers and the average

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

2014-05-04 Thread Pramod Singh
i am also confusing what she is saying. Rameshwari come on Skype or googel hangout. for complete explanation. Skype ID-Pramodb35 Regards Pramod On Sun, May 4, 2014 at 6:16 PM, rameshwari shyam wrote: > Dear All, > > > Sorry guys, I went wrong on explain the query, > > 01 01) Target % is my co

Re: $$Excel-Macros$$ Loop through

2014-04-27 Thread Pramod Singh
My Pleasure. On Mon, Apr 28, 2014 at 11:25 AM, Rupesh Patil wrote: > Dear Pramod, > > Thanks you very very much. > > > On Mon, Apr 28, 2014 at 11:19 AM, Pramod Singh wrote: > >> Hi Rupesh, >> >> Please find the attached file. as per ur requirement. >&

Re: $$Excel-Macros$$ Loop through

2014-04-27 Thread Pramod Singh
Hi Rupesh, Please find the attached file. as per ur requirement. Regards/Pramod On Mon, Apr 28, 2014 at 10:03 AM, Rupesh Patil wrote: > Hello Expert, > Good Morning > > I need your help, > I am not able to determine how to loop through only till last used row and > column, sample file is atta

Re: $$Excel-Macros$$ Help required on formula

2014-03-28 Thread Pramod Singh
hey what u want can u enplane complete... On Sat, Mar 29, 2014 at 8:08 AM, Jocky Beta wrote: > Hi, > I have already assigned formula but its showing error. > > Please help me. > > Regards > > > On Fri, Mar 28, 2014 at 1:51 PM, Jocky Beta wrote: > >> Hi, >> >> Please help me on this _ >> >> >>

Re: $$Excel-Macros$$ Need Book for Web scrpting by vba excel

2014-03-27 Thread Pramod Singh
i means to say that u have know of vba excel web scrapting book . i want to learn . web scrapting . On Thu, Mar 27, 2014 at 3:21 PM, Divaker Pandey wrote: > please explain what is your purpose. > > Divaker > > > On Wed, Mar 26, 2014 at 10:45 AM, pramodb35 wrote: > >> Hi Excel Expert, >> >>