Re: $$Excel-Macros$$ Fwd: Need your Help on Priority

Didn't get your query, what you want to do in this sheet, pls mention example with result. *PJ * *MIS Analyst* *Greater Kailash-1, New Delhi.* *Instagram* *pj_sharma_* *Tweeter* *dude_sharma_pj**Facebook**

Re: $$Excel-Macros$$ $$Help Required$$

use this: ={IFERROR(VLOOKUP($A3$1,CHOOSE({1,2},$M$13:$M$22&$O$13:$O$22,$N$13:$N$22),2,0),0)} *PJ * *MIS Analyst* *Greater Kailash-1, New Delhi.* *Instagram* *pj_sharma_* *Tweeter* *dude_sharma_pj**Facebook**

Re: $$Excel-Macros$$ Comine Text

chk *PJ * *MIS Analyst* *Greater Kailash-1, New Delhi.* *Instagram* *pj_sharma_* *Tweeter* *dude_sharma_pj**Facebook** www.facebook.com/dude.pj * *We meet for a reason, either you're a

$$Excel-Macros$$ Re: Need help Using Isblank and days360 in Macro

Hi Maju,,,i think if you provide some example sheet, you will get your answer very soon. On Wednesday, March 9, 2016 at 8:23:53 PM UTC+5:30, Maju wrote: > > Hello all! > > > > Please I need macro help with the below in red: > > What is the best way to achieve this without using the

$$Excel-Macros$$ Re: GOAL SEEK

Hi buddy, Find the below link to understand Goal Seek basic... https://youtu.be/7QIBvMPC9vM *PJ * *MIS Analyst* *Greater Kailash-1, New Delhi.* *Instagram* *pj_sharma_* *Tweeter* *dude_sharma_pj**Facebook**

Fwd: $$Excel-Macros$$ Sorting Comma Separated Values in a cell

Hi Dev,, little long process but working as per your requirement. Check this out Option Explicit Sub SortRangeData() Dim sh1 As Worksheet, sh2 As Worksheet Dim rng1 As Range, rng2 As Range, rng As Range, data As Range Dim arr As Variant, arr2 As String, txt As String Dim i As Long Set

Re: $$Excel-Macros$$ Sorting Comma Separated Values in a cell

Result type2 is here: Sub SortRangeData2() Dim sh1 As Worksheet, sh2 As Worksheet Dim rng1 As Range, rng2 As Range, rng As Range, data As Range Dim arr As Variant, arr2 As String, txt As String Dim i As Long, lr As Long Set sh1 = ActiveSheet On Error Resume Next Set

Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula

;> >> PFA the same. >> >> On Thu, Jan 7, 2016 at 7:16 PM, Pankaj Sharma <pankaj123...@gmail.com> >> wrote: >> >>> where is the attachment. ??? >>> >>> >>> >>> *Pankaj Sharma

Re: $$Excel-Macros$$ Correction required in highlet cell & refresh d15 automatically when last any entry of any raw change

in Conditional formatting use formula: =AND($F5>=TODAY(),$F5<=TODAY()+14) Applied to : =$A$5:$AI9 and secondly in Function GetConcat formula coding use : Application.Volatile for Auto refresh *Pankaj Sharma * *MIS Analyst* *G

Fwd: $$Excel-Macros$$ Refresh d15 automatically when last any entry of any raw change

use this: Private Sub Worksheet_Change(ByVal Target As Range) Dim r As Long: r = Target.Row If r >= 5 And r < Sheet1.Range("A" & Rows.Count).End(xlUp).Row Then r = r - 3 Range("C15").FormulaR1C1 = "=OFFSET(R[-12]C[1]," & r

$$Excel-Macros$$ Fwd: Need Help

use this: Sub Reporting() Dim abc As Long: abc = Sheet1.Range("A" & Rows.Count).End(xlUp).Row Sheet1.Range("B7:B" & abc).FormulaR1C1 = "=IF(RC1="""","""",TEXT(RC1,""mmm"")&""-

Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula

it's already done i think.. pfa *Pankaj Sharma * *MIS Analyst* *Greater Kailash-1, New Delhi* *Email * *p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com <ankaj123...@gmail.com>* *Skype** pankaj.sharma_pj* On Wed, Jan 6,

Fwd: $$Excel-Macros$$ Re: Enable/Disable text box based on User Login

Hi Rajeev, You can also use this Form too. ☺ user1 USER PASSWORD user2 GUEST *Pankaj Sharma * *MIS Analyst* *Greater Kailash-1, New Delhi* *Email * *p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com <ankaj123...@gmail.com

Re: $$Excel-Macros$$ plz help

have you seen attachment. If no than check it.  *Pankaj Sharma * *MIS Analyst* *Greater Kailash-1, New Delhi* *Email * *p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com <ankaj123...@gmail.com>* *Skype** pankaj.sharma_pj

Fwd: $$Excel-Macros$$ plz help

use this: "=TEXT(IF(LEFT(B6,17)="Ship (P/U) Date: ",TRIM(MID(B6,18,10)),K5),"MM/DD/")" instead of "=TEXT(IF(LEFT(B10,17)="Ship (P/U) Date: ",RIGHT(B10,11),K9),"MM/DD/")" *Pankaj Sharma

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

.Offset(1, 10).Value = Range("AD" & rw).Offset(3).Value .Offset(1, 11).Value = Range("AF" & rw).Value .Offset(1, 12).Value = Range("AK" & rw).Offset(2).Value .Offset(1, 13).Value = Range("AK" & rw).Value

Re: $$Excel-Macros$$ Transform data - help required

okay, now check it *Pankaj Sharma * *MIS Analyst* *Greater Kailash-1, New Delhi* *Email * *p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com <ankaj123...@gmail.com>* *Skype** pankaj.sharma_pj* On Tue, Dec 22, 2015 at 3:

Re: $$Excel-Macros$$ Transform data - help required

pfa *Pankaj Sharma * *MIS Analyst* *Greater Kailash-1, New Delhi* *Email * *p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com <ankaj123...@gmail.com>* *Skype** pankaj.sharma_pj* On Tue, Dec 22, 2015 at 9:28 AM, Rashi Sing

Re: $$Excel-Macros$$ help on find the list matches to the cell part value

check it ! *Pankaj Sharma * *MIS Analyst* *Greater Kailash-1, New Delhi* *Email * *p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com <ankaj123...@gmail.com>* *Skype** pankaj.sharma_pj* On Tue, Dec 22, 2015 at 5:07

Re: $$Excel-Macros$$ help on find the list matches to the cell part value

If(list, "<=" & v2) b = wf.CountIf(list, ">=" & v1) ElseIf v1 > v2 Then a = wf.CountIf(list, ">=" & v2) b = wf.CountIf(list, "<=" & v1) End If

Re: $$Excel-Macros$$ REPLACE

use this: =TRIM(LEFT(A5,27) & " " & RIGHT(A5,4) & " " & MID(A5,28,14)) *Pankaj Sharma * *MIS Analyst* *Greater Kailash-1, New Delhi* *Email * *p <sharmapankaj...@yahoo.com>ankaj123...

Re: $$Excel-Macros$$ Transform data - help required

check it *Pankaj Sharma * *MIS Analyst* *Greater Kailash-1, New Delhi* *Email * *p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com <ankaj123...@gmail.com>* *Skype** pankaj.sharma_pj* On Mon, Dec 21, 2015 at 10:54 AM,

Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula

Formula updated in example sheet *Pankaj Sharma * *MIS Analyst* *Greater Kailash-1, New Delhi* *Email * *p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com <ankaj123...@gmail.com>* *Skype** pankaj.sharma_pj* On Tue, Dec 15

Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula

done! *Pankaj Sharma * *MIS Analyst* *Greater Kailash-1, New Delhi* *Email * *p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com <ankaj123...@gmail.com>* *Skype** pankaj.sharma_pj* On Tue, Dec 15, 2015 at 7:51 PM, mohd sadi

Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula

check it! *Pankaj Sharma * *MIS Analyst* *Greater Kailash-1, New Delhi* *Email * *p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com <ankaj123...@gmail.com>* *Skype** pankaj.sharma_pj* On Fri, Dec 11, 2015 at 12:06 PM

Re: $$Excel-Macros$$ FW: Get text value in pivot data field.

Share a example sheet. Q & A *Pankaj Sharma * *MIS Analyst* *Greater Kailash-1, New Delhi* *Email * *p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com <ankaj123...@gmail.com>* *Skype** pankaj.sharma_pj* On Wed, Dec 2,

Re: $$Excel-Macros$$ Required help for count of present days

Hi Jetendra, PFA *Pankaj Sharma * *MIS Analyst* *9599220030* *Greater Kailash-1, New Delhi* *Email **sharmapankaj...@yahoo.com <sharmapankaj...@yahoo.com>* *Skype** pankaj.sharma_pj* On Thu, Oct 1, 2015 at 6:23 PM, Jitendra

Re: $$Excel-Macros$$ Re: Data Extract After "/"

Hi Anand, You can also use this =IF(ISERROR(FIND("/",A1)),A1,RIGHT(A1,LEN(A1)-FIND("~",SUBSTITUTE(A1,"/","~",LEN(A1)-LEN(SUBSTITUTE(A1,"/","")) *Pankaj Sharma * *MIS An

$$Excel-Macros$$ need Excel formula

HI Expert,, i need a formula to find last collected Amount from client.For example PFA. -- 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

Re: $$Excel-Macros$$ need Excel formula

Thank you Abhishek Jain On Thu, Aug 27, 2015 at 3:37 PM, Abhishek Jain abhishek@gmail.com wrote: HTH On Thu, Aug 27, 2015 at 3:18 PM, Pankaj Sharma pankaj123...@gmail.com wrote: HI Expert,, i need a formula to find last collected Amount from client.For example PFA

Re: $$Excel-Macros$$ need Excel formula

:$B$17) Regards, On Thu, Aug 27, 2015 at 3:51 PM, Pankaj Sharma pankaj123...@gmail.com wrote: Thank you Abhishek Jain On Thu, Aug 27, 2015 at 3:37 PM, Abhishek Jain abhishek@gmail.com wrote: HTH On Thu, Aug 27, 2015 at 3:18 PM, Pankaj Sharma pankaj123...@gmail.com wrote: HI

Re: $$Excel-Macros$$ Formula to Calculate Slab Wise Commission as per Targets Achieved

Dear Ashok, I don't think there is any easiest way to calculate this with excel formula's. You can do with run a macro or better if you make a slab chart on the right side or other sheet to calculate the same. This will be easy if you have to change slab criteria in future. On Wed, Aug 19,

Re: $$Excel-Macros$$ FORMULA REQUIRED

use this =INDEX($L$2:$R$87,MATCH($B2,$K$2:$K$87,0),MATCH($C2,$L$1:$R$1,0)) or if you don't want to see #N/A error so use this one =IFERROR(INDEX($L$2:$R$87,MATCH($B2,$K$2:$K$87,0),MATCH($C2,$L$1:$R$1,0)),-) *Regards,* *PJ* On Thu, Jul 30, 2015 at 8:01 PM, Izhar izharra...@gmail.com

Re: $$Excel-Macros$$ Fwd: Delivery Status Notification (Failure)

Attachment ?? On Mon, May 25, 2015 at 3:10 PM, Chandan Bisht csb.bi...@gmail.com wrote: Hi Group Need help by vba... i have two data sheets Main and Database, and i need to pick data from database to main by to use Find function..which data not found that output should be blank.

Re: $$Excel-Macros$$ Query on Extract word

(SUBSTITUTE(SUBSTITUTE(A1351,.,),-,), ,)))+3),2),1))47),(CODE(RIGHT(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1351,.,),-,), ,),(FIND(MOC,UPPER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1351,.,),-,), ,)))+3),2),1))58)),0,-1),No MOC) On Wed, May 20, 2015 at 9:03 PM, Pankaj Sharma pankaj123...@gmail.com wrote

RE: $$Excel-Macros$$ Query on Extract word

))47),(CODE(RIGHT(MID(SUBSTITUTE(SUBSTITUTE(A1351,-,), ,),(FIND(MOC,UPPER(SUBSTITUTE(SUBSTITUTE(A1351,-,), ,)))+3),2),1))58)),0,-1),No MOC) PFA Regards Pankaj Sharma (PJ) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kal xcel Sent

RE: $$Excel-Macros$$ Re: VBA Error in copying filtered rows

Hi Nitin,, use this Dim errormessagecode, copydata, msg As String On Error Resume Next Sheets(2).Activate ActiveSheet.Range($A$1:$S$1).AutoFilter Field:=19, Criteria1:=N/A ActiveSheet.Range($A$1:$S$1).AutoFilter Field:=10, Criteria1:=Array(4-Resolved, 5-Closed, 6-Cancelled),

RE: $$Excel-Macros$$ Re: Copy PDF data to Excel macro require

that this macro can copy all pages data. Regards Pankaj Sharma From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Michael Vinoth Sent: Friday, May 15, 2015 6:45 PM To: excel-macros@googlegroups.com Cc: polkarnat...@gmail.com Subject: Re: $$Excel

RE: $$Excel-Macros$$ Re: Copy PDF data to Excel macro require

@googlegroups.com Cc: polkarnat...@gmail.com Subject: Re: $$Excel-Macros$$ Re: Copy PDF data to Excel macro require Hi Pankaj Sharma , Please find the attached macro file. kindly let me know if you have any queries. Regards, MV On Saturday, May 9, 2015 at 3:01:04 PM UTC+5:30, Pankaj Sharma

Re: $$Excel-Macros$$ Text separated with formula

use this Selection.TextToColumns Destination:=Range(B1), DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, Other:=True, _ otherchar:=_, fieldinfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1)),TrailingMinusNumbers:=True -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

Re: $$Excel-Macros$$ Re: Copy PDF data to Excel macro require

:44, Pankaj Sharma pankaj123...@gmail.com wrote: Please find attached file. On Fri, May 8, 2015 at 5:27 PM, Vabz v...@vabs.in wrote: can you share PDF file, if it is text only then same can be imported.. On Thursday, May 7, 2015 at 7:42:59 PM UTC+5:30, Pankaj Sharma wrote: Hi everyone

Re: $$Excel-Macros$$ Re: Copy PDF data to Excel macro require

Please find attached file. On Fri, May 8, 2015 at 5:27 PM, Vabz v...@vabs.in wrote: can you share PDF file, if it is text only then same can be imported.. On Thursday, May 7, 2015 at 7:42:59 PM UTC+5:30, Pankaj Sharma wrote: Hi everyone, Need your help for this easy. I have a folder

Re: $$Excel-Macros$$ Re: Copy PDF data to Excel macro require

- *Cheers!!!* *Pankaj Sharma* *9716375462* On Fri, May 8, 2015 at 6:44 PM, Pankaj Sharma pankaj123...@gmail.com wrote: Please find attached file. On Fri, May 8, 2015 at 5:27 PM, Vabz v...@vabs.in wrote: can you share PDF

$$Excel-Macros$$ Copy PDF data to Excel macro require

Hi everyone, Need your help for this easy. I have a folder with multi PDF files. I need a macro to copy all pdf data in a workbook. Note: One pdf data should be copy in one sheet. -- 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$$ Re: Move coloum

r u looking for this ?? Sub Combine() Dim J As Integer Dim rey As Range On Error Resume Next Sheets(1).Select Worksheets.Add Sheets(1).Name = Combined Sheets(1).Activate For J = 2 To Sheets.Count Sheets(J).Activate Range(A:A).Copy Sheets(Combined).Select If Range(XFD1).End(xlToLeft) = Then

Re: $$Excel-Macros$$ excel Macro

like this On Sat, Apr 18, 2015 at 3:32 PM, B.N.Chethan Kumar chetankumar1...@gmail.com wrote: Hi Please help me with macro code. I am trying to send file to each individual. I need to filter and send the file to each individual. Current i have macro it work on person. -- Chethan

Re: $$Excel-Macros$$ Copying existing Address from column B to column A Using IF statement ( I think).

Hi MIke,,,check this!!! On Sat, May 2, 2015 at 1:12 AM, Mike B mikeb...@gmail.com wrote: I would like to copy this for each location and paste in front inventory numbers in Column A(some begin with letters) and also in front of the Establishment Totals: VC Count. Then I would like to Remove