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** www.facebook.com/

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

use this: ={IFERROR(VLOOKUP($A3&C$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** www.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 ble

$$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 formu

$$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** www

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

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 sh1

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

reason, either you're a blessing or a lesson...* On Wed, Jan 13, 2016 at 6:04 PM, mohd sadiq wrote: > Team , Please help to closed it on priority > > On Fri, Jan 8, 2016 at 2:03 PM, mohd sadiq wrote: > >> Opsss , sorry >> >> PFA the same. >> >> On

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$$ 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

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 ankaj123...@gmail.com * *Skype** pankaj.sharma_pj* On Wed, Jan 6, 2016 at 6:15 PM, mohd sadiq wrote: > Dera Team , &g

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 ankaj123...@gmail.com * *Skype** pankaj.sharma_pj* -- Forwarded

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 ankaj123...@gmail.com * *Skype** pankaj.sharma_pj* On Sun, Dec 27, 2015 at 5:53 PM, SUDHIR VERMA wrote

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)

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 ankaj123...@gmail.com * *Skype** pankaj.sharma_pj*

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$$ help on find the list matches to the cell part value

check it ! *Pankaj Sharma * *MIS Analyst* *Greater Kailash-1, New Delhi* *Email * *p ankaj123...@gmail.com * *Skype** pankaj.sharma_pj* On Tue, Dec 22, 2015 at 5:07 PM, Ganesh N wrote: > Dear team, > > I want to find the a

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

okay, now check it *Pankaj Sharma * *MIS Analyst* *Greater Kailash-1, New Delhi* *Email * *p ankaj123...@gmail.com * *Skype** pankaj.sharma_pj* On Tue, Dec 22, 2015 at 3:20 PM, Rashi Singh wrote: > Thanks. but it is not picking

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

pfa *Pankaj Sharma * *MIS Analyst* *Greater Kailash-1, New Delhi* *Email * *p ankaj123...@gmail.com * *Skype** pankaj.sharma_pj* On Tue, Dec 22, 2015 at 9:28 AM, Rashi Singh wrote: > Hi, there some small changes in line item. Supp

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

check it *Pankaj Sharma * *MIS Analyst* *Greater Kailash-1, New Delhi* *Email * *p ankaj123...@gmail.com * *Skype** pankaj.sharma_pj* On Mon, Dec 21, 2015 at 10:54 AM, Rashi Singh wrote: > Dear all, > > I have been try

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

done! *Pankaj Sharma * *MIS Analyst* *Greater Kailash-1, New Delhi* *Email * *p ankaj123...@gmail.com * *Skype** pankaj.sharma_pj* On Tue, Dec 15, 2015 at 7:51 PM, mohd sadiq wrote: > Dear All , > > Pls help on the same. &g

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 ankaj123...@gmail.com * *Skype** pankaj.sharma_pj* On Tue, Dec 15, 2015 at 11:13 PM, Pankaj Sharma wrote: > d

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

check it! *Pankaj Sharma * *MIS Analyst* *Greater Kailash-1, New Delhi* *Email * *p ankaj123...@gmail.com * *Skype** pankaj.sharma_pj* On Fri, Dec 11, 2015 at 12:06 PM, mohd sadiq wrote: > Dear Team , > > Please help on the

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 ankaj123...@gmail.com * *Skype** pankaj.sharma_pj* On Wed, Dec 2, 2015 at 6:10 AM, Nilkanth Raval wrote: > Hi All, >

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 * *Skype** pankaj.sharma_pj* On Thu, Oct 1, 2015 at 6:23 PM, Jitendra Kumar wrote: > Dear

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

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

;38500". On Thu, Aug 27, 2015 at 5:13 PM, Shrinivas Shevde wrote: > Dear Abhi > Can you please explain (1/($A$1:$A$17=F2) > > Thanks > Shrinivas > > On Thu, Aug 27, 2015 at 4:30 PM, Prafull Jadhav > wrote: > >> Great ... >> Abhishekji >> &

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

> > Regards, > > > On Thu, Aug 27, 2015 at 3:51 PM, Pankaj Sharma > wrote: > >> Thank you Abhishek Jain >> >> On Thu, Aug 27, 2015 at 3:37 PM, Abhishek Jain >> wrote: >> >>> HTH >>> >>> On Thu, Aug 27, 2015 at 3:18

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

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

$$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 conc

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, 20

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 wrote: > I need fig

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

Attachment ?? On Mon, May 25, 2015 at 3:10 PM, Chandan Bisht 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. > > example file at

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

t;),"-","")," ","")))+3),2),1))>47),(CODE(RIGHT(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1351,".",""),"-","")," ",""),(FIND("MOC",UPPER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1351,".&q

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

,2+(IF(AND((CODE(RIGHT(MID(SUBSTITUTE(SUBSTITUTE(A1351,"-","")," ",""),(FIND("MOC",UPPER(SUBSTITUTE(SUBSTITUTE(A1351,"-","")," ","")))+3),2),1))>47),(CODE(RIGHT(MID(SUBSTITUTE(SUBSTITUTE(A1351,"-",

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

so 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 Su

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

acros@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, P

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

015 at 18:44, Pankaj Sharma wrote: > >> Please find attached file. >> >> >> >> On Fri, May 8, 2015 at 5:27 PM, Vabz wrote: >> >>> can you share PDF file, if it is text only then same can be imported.. >>> >>> On Thursday, May 7, 2015 a

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

nd Sub Private Sub MyExcel() AppActivate "Microsoft Excel" ThisWorkbook.Activate Sheets(1).Activate Range("A1").Activate SendKeys ("^v") End Sub ----- *Cheers!!!* *Pan

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 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 fo

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. > > > > --

$$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) = ""

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 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 the Word "E