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

Hi Guys, My Name is Pankaj Pandey, I'm from Uttarakhand. Now I am working Gurgaon based MNC as a Sr. MIS role. I think it is great platform for anyone to enhance knowledge. I feel really good to be a part of this group. Thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And d

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

$$Excel-Macros$$ Need Help in Macro Loop for data dirstribution

to only Wave 1 sheet and similar for others. I would appreciate you support. pls help. Regards Pankaj k Pandey -- 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

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$$ Select all excel files in computer

uter > > Hi, > Instead of macro do it manually, it will be faster. use search > functionality of windows... Search for *.xls and *.xlsx and then move those > files to destination folder. > Regards, > Swapnil Suresh Palande > > > On 08-Oct-2015 8:28 am, "Pankaj Michael&

$$Excel-Macros$$ Select all excel files in computer

per policy. Please help -- Thanks Pankaj Kumar 9910075248 -- 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$$ 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$$ Count If Cell Contains

Assuming data stored in Range A1:A100 Put this formula in B1, it will give the count of IRE in the given Range CountIf(A1:A100,"(IRE)") Use the same again with another criteria CountIf(A1:A100,"(xxx)") -- 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$$ 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

i recd 20-30 Mobile Bills in PDF format every month, which i need to copy in Excel with different sheets. That's what i want to make automate. On Sat, May 9, 2015 at 11:21 AM, Pol Ktk wrote: > Are you working with cdr ? > if s > what exactly u need ? > > On 8 May 2

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

Re: $$Excel-Macros$$ Re: Business Analyst Role

I think you should move and grab the opportunity... Send your resume to Puneet AON HR... All the Best buddy!! On Wed, Apr 29, 2015 at 6:03 AM, Nasir Saikh wrote: > Hi Pankaj, > > As per your post I am looking for job and I think I ll suitable for your > expectation. > An

$$Excel-Macros$$ Business Analyst Role

Hello, There is walk-in in AON Hewitt on Saturday.. Please share your resume to puneet.rawa...@aonhewitt.com and mention Refer By: Pankaj Sangotra Role: Business Analyst / Data Analyst Experience: 0 - 4 Expertise: Excel, VBA, Access, SQL Venue: Noida 127 Express Highway Thanks!! Pankaj

Re: Re: $$Excel-Macros$$ I need VBA code to copy the cell value and paste in comment box for the same cell.

Thanks a ton to Ashish and Vaibav!! I looks good now. You guys are brilliant. :) On Wed, Aug 20, 2014 at 1:59 AM, Ashish Kumar wrote: > Vaibhav Bro, > > Superb!!! > > > On 20 August 2014 12:12, Vaibhav Joshi wrote: > >> FA >> >> Cheers!! >> >

$$Excel-Macros$$ VBA code for adding new row at the end of last row

to be little complex but I know, in this forum all of you are genius and expert of VBA and hence if you could help me with this then It'll be really great thing for us. Regards, Pankaj -- 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

Fwd: Re: $$Excel-Macros$$ I need VBA code to copy the cell value and paste in comment box for the same cell.

g As Range On Error resume Next xTitleId = "Select Cell" Set WorkRng= Application selection Set WorkRng= Application Inputbox ("Range",xTitleId,WorkRng.Address, Type:= 8) For Each Rng in WorkRng Rng.NoteText Text= Rng.value Next End Sub Regards, Pankaj -- Forwarded messag

Re: $$Excel-Macros$$ I need VBA code to copy the cell value and paste in comment box for the same cell.

cell number and code will add comment or message box for that cell only. Looking for your response. Thanks, Pankaj On Aug 18, 2014 12:13 AM, "Vaibhav Joshi" wrote: > hi > > I suggest alternate way.. > > put this code in ThisWorkbook module.. > > You need to double click

$$Excel-Macros$$ I need VBA code to copy the cell value and paste in comment box for the same cell.

I need VBA code to copy the cell value and paste in comment box for the same cell. Example: If I select any cell or merged cells which has some text in it then code should copy the text and create a comment and paste the same text. I need this because when user can't see the entire text because

$$Excel-Macros$$ Help to skip saturday sunday and holidays while substracting the number of days from date.

me on this! Regards. Pankaj Khairnar -- 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

Re: $$Excel-Macros$$ Excel VBA Password Issues/ Cannot view the code

Hi I am agree with paul and anil. it's a violation of group policy On Fri, Jun 20, 2014 at 9:52 PM, Ankur Gupta wrote: > hi Paul, > > the person who wrote the code has left the company and now i need the code > behind in order to work further. I am not violating any policies dear. > Please help

$$Excel-Macros$$ Re: FW: Auto update Data, Row & Columns

Hi Can you please share more details? it couldent be possible for any one to provide you correct macro without understanding the proper requirement. Regards, Pankaj On Wednesday, June 18, 2014 2:08:42 PM UTC+5:30, Raj wrote: > Dear Experts, > > > > Is t

Re: $$Excel-Macros$$ Want Excel formula to Omit saturday sunday!

Thanks Paul! Got the solution and as well knowledge! Regards, Pankaj On Tuesday, June 17, 2014 8:43:44 PM UTC+5:30, Paul Schreiner wrote: > Here we can make use of a couple of different concepts: > #1) Excel stores dates as numbers (the number of days since 1/1/1900). > So, if your d

$$Excel-Macros$$ Want Excel formula to Omit saturday sunday!

/14 - 9=Sunday, May 25, 2014 Want to omit this sunday and want result as Monday, May 26,2014 Regards, Pankaj -- 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

Re: $$Excel-Macros$$ Need VBA Code to extract pdf file from URL.

Hi Ashish, Thank you so much for your reply. Just I went trhough your code , and using this code I can only able to extract the single file at a time. Is there any possible way to extract all the pdf's mentioned in excel sheet in a single button click? Regards, Pankaj On Thursday,

$$Excel-Macros$$ Need VBA Code to extract pdf file from URL.

eference! Best Regards, Pankaj Khairnar -- 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, l

$$Excel-Macros$$ Re: VBA-For Next

Hi Prafull, Follow the below steps to achieve the result you want, 1.Select the horizontal data and copy(dont select empty cells). 2 Left click on cell where you want data, and click on paste special. 3 Paste special dialogue will open, select transpose option in botton right corner. 4 Click OK.

$$Excel-Macros$$ Specific dates Grouping(urgent) excel or vba

3008 Pankaj Hindi 15-02-2014 Result 3009 Amit English 28-02-2014 Month Jan Feb Mar Total 3010 Karan Hindi 01-03-2014 Count of Students 4 5 1 10 -- 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$$ hi

group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.go

Re: $$Excel-Macros$$ Codes for SubPart

Please try this hope this will help.. Sub output() Dim i As Integer, k As Integer, j As Integer k = 1 For i = 1 To 5 For j = 97 To 100 Cells(k, 1).Value = i & Chr(j) k = k + 1 Next Next End Sub On Thu, Feb 13, 2014 at 12:52 PM, arvind sharma Rajendra < arveensharm...@gmai

Re: $$Excel-Macros$$ plz add me to the group thanks

s from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/groups/opt_out. > --

Re: $$Excel-Macros$$ Comments

Please try the below code.. Hope this will help Shrinivas.. Sub showcomments() Application.ScreenUpdating = False Dim commrange As Range Dim mycell As Range Dim curwks As Worksheet Dim newwks As Worksheet Dim i As Long Set curwks = ActiveSheet On Error Resume Nex

Re: $$Excel-Macros$$ if then code in macro doesn't work

Sub DeliveryCost() Dim i As Integer Dim j As Integer Dim iEndrow As Long iEndrow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row For i = 2 To iEndrow If Cells(i, 14).Value < 25 Then Cells(i, 16).Value = 2 Else Cells(i, 16).Value = 5 End If Next End Sub On Fri, Nov 1

Re: $$Excel-Macros$$ Help needed in Excel

aring? On Tuesday, August 13, 2013 1:26:31 PM UTC+5:30, Ravinder Negi wrote: > > pfa...first select area which you want to merge...example select range > "A1:B4" then click on button > > ------ > *From:* Pankaj > > *To:* excel-...@googleg

Re: $$Excel-Macros$$ Help needed in Excel

I want to merge contents of column A & B as shown in column C. Please see the sample file enclosed On Wednesday, August 7, 2013 2:34:57 PM UTC+5:30, Ravinder Negi wrote: > > pls provide excel or explain more about your query... > > -- > *Fr

$$Excel-Macros$$ Help needed in Excel

I have 2 columns in excel - A and B. I want to merge the contents of a horizontal row one below the other as: A B please tell me a formula to do this as the columns contain 900 cells each and I cannnot merge the contents manually using Alt + Enter. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in

Re: $$Excel-Macros$$ Fwd: Mandatory Cell Entry

Thank You Abhishek Great! I was just looking for the same. in future I will try to provide a sample query or form.. Regards, Pankaj Michael On Thu, May 2, 2013 at 11:28 AM, Abhishek Jain wrote: > Dear Pankaj, > > Please see attached. Hope this is what you are looking for, if no

Re: $$Excel-Macros$$ Fwd: Mandatory Cell Entry

in VBA Form. Regards, Pankaj On Wed, May 1, 2013 at 4:30 PM, ravinder negi wrote: > please give more detail with example file so we can understand properly > whether you want this in VBA for or normally in excel sheet. > > > --- On *Wed, 5/1/13, pankaj gmail account * wrote: >

Re: $$Excel-Macros$$ Fwd: Mandatory Cell Entry

Dear Priti, I want user restriction in Excel GUI form. Regards, Pankaj On Wed, May 1, 2013 at 2:59 PM, priti verma wrote: > Hi Pankaj, > I thing you want data validation thats restrict to enter the name in to > the column of phone number.and to restrict the phone number to e

$$Excel-Macros$$ Fwd: Mandatory Cell Entry

-- Forwarded message -- From: pankaj gmail account Date: Sat, Jan 5, 2013 at 9:10 AM Subject: Mandatory Cell Entry To: excel-macros@googlegroups.com Dear Gurus I want to make a excel data entry form in which i want some cells to be mandatory and some can be left out. But with

$$Excel-Macros$$ Curve Graph Help

13 7 4 12 9 119 15 17 6 11 7 8 1 10 7 7 5 11 5 611 11 5 10 9 4 712 12 18 5 12 7 613 8 9 8 4 5 6 1 14 7 12 4 5 11 5 2 15 6 12 5 8 1 6 1 16 6 5 1 2 2 317 4 3 3 2 3 118 2 1 3 1 3 1 -- Thanks Pankaj Kumar 9910075248 -- Thanks Pankaj Kumar 9910075248 -- Are you

$$Excel-Macros$$ Tricks to hide/restrict viewing excel data in sheets

Dear Gurus, Please suggest ideas to hide/restrict data viewing in excel data sheets version 2007/2010. using VBA also. blocking right click, copy/paste, printing, saving, copy file, not able to view formula's etc. -- Thanks Pankaj Kumar 9910075248 -- Thanks Pankaj Kumar 99100

$$Excel-Macros$$ MIS Job in Ienegizar

Job Description * Should have good knowledge of Work force management * Prepare Weekly, Monthly reports on Excel sheets * Preparing MIS Reports using various Excel Formula Vlookup, Hlookup, Sorting and Pivot Table * Prepare data on MS Excel * 24/7 shifts *Good knowledge of Macros Walk in In

$$Excel-Macros$$ Type mismatch error found in Sumproduct

Hello team, Please find the attached and suggest as "I am having the TYPE MISMATCH error at sumproduct line... Thanks Pankaj Sangotra -- 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$$ Locking Particular Cells in Excel

Please follow the below link u will get the awesome detailed answer bro.. http://www.techonthenet.com/excel/cells/protect2007.php On Tue, Feb 19, 2013 at 11:21 AM, Prabhakar H wrote: > Can you explain me how did you do lock the cell. > > Rgds, > Prabhakar > > On Tue, Feb 19, 2013 at 10:13 AM,

Re: $$Excel-Macros$$ Formula for Loan amount

Hello Bro.. if u are using Excel 2007 it is bulid template named Loan Amortization.. To get this template : Go to Home page : New: Installed template and u will get what you are looking for .. Hope this is helpfull to U.. Enjoy ur day.. Thanks Pankaj Sangotra On Tue, Feb 19, 2013 at 6:09 AM

Re: $$Excel-Macros$$ Minimum Value of particular columns to be highlighted

Hello Amit, Please find the aatched solution, please let me know if it works fine for you.. Thanks Pankaj Sangotra On Wed, Feb 13, 2013 at 11:15 AM, Amit Gandhi wrote: > Hi Experts > > I want to highlight minimum value of some particular columns say columns > D,H,L in attached

$$Excel-Macros$$ Query: Charts

Hi Experts, I have mention the details in the tab itself, Please do the needful.. Thanks Pankaj Sangotra -- 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

Re: $$Excel-Macros$$ Need formula Solution

dear frnd. Use Pivot get the solution. On 2/12/13, Dhaval Shah wrote: > Dear Friends > > pls refer my sheet i want a formula solution > > -- > 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://

Re: $$Excel-Macros$$ Need Help to Prepare the dashboard

help me solve this problem.if any query please let me know. Regards Pankaj kumar On 1/26/13, Pankaj Singh wrote: > Dear All, > > Hope you will be well. here is attached the excel workbook Stock Count > Report.xls.in this work book has many sheet as by people name, i want to

Re: $$Excel-Macros$$ Any one help to solve the Test

Thanks for your support.. On Sun, Jan 20, 2013 at 2:26 AM, >>Excel Beginner<< wrote: > Hi Pankaj, > >I gave an answer to your question look at the attachment. > > > > > -- > *Regards,* > * > * > *Excel Beginner* > On Sat, Jan 19,

Re: $$Excel-Macros$$ Re: Mandatory Cell Entry

Dear All, Pleae help to resolve the query. DEar Prince Please check On Tue, Jan 15, 2013 at 12:40 PM, pankaj gmail account wrote: > Dear Gurus > > Please help. > > Regards, > Pnkaj > > On Thu, Jan 10, 2013 at 5:10 PM, Prince wrote: > >> Ok Pank

Re: $$Excel-Macros$$ Any one help to solve the Test

gt; Use a meaningful subject line which identifies the nature of the problem . > Explain the problem in detail in the body of the email. Identify what you > have tried, what you wanted it to do and what it actually did. > Attach a sample file (You already did this). > > On Friday, 18 January

Re: $$Excel-Macros$$ Any one help to solve the Test

Dear Team, Can any one to help to solve the attached test sheet. On Tue, Jan 15, 2013 at 9:50 PM, Pankaj Singh wrote: > Dear Team, > > > Kidly help so sole the test sheet. > > > Thanks > pankaj kumar > > -- > Join official Facebook page of this forum @ > h

Re: $$Excel-Macros$$ HyperLinks to Sheets * *

How to get back in hyper liked sheet after clicking on hyper link..need code..plz. On Wed, Jan 16, 2013 at 9:00 PM, Hilary Lomotey wrote: > > > > > *BINGO- IT WORKING TO PERFECTION,* > * > * > *very grateful Ashish and Rajan > * > * > * > * > * > * > * > On Wed, Jan 16, 2013 at 3:18 PM, ashish k

Re: $$Excel-Macros$$ Any one help to solve the Test

help any one to solve the attached sheet of excel plz. On Tue, Jan 15, 2013 at 9:50 PM, Pankaj Singh wrote: > Dear Team, > > > Kidly help so sole the test sheet. > > > Thanks > pankaj kumar > > -- > Join official Facebook page of this forum @ > https://www

$$Excel-Macros$$ Any one help to solve the Test

Dear Team, Kidly help so sole the test sheet. Thanks pankaj kumar -- 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, Formula Problem, Code

Re: $$Excel-Macros$$ Re: Mandatory Cell Entry

Dear Gurus Please help. Regards, Pnkaj On Thu, Jan 10, 2013 at 5:10 PM, Prince wrote: > Ok Pankaj > i can only reply in evening. > > regards > Prince > > > On Thursday, January 10, 2013 5:02:06 PM UTC+5:30, Pankaj wrote: > >> Don't use differnt mails.

Re: $$Excel-Macros$$ Re: Mandatory Cell Entry

I have not received any answer. Regards, Pankaj On Tue, Jan 8, 2013 at 7:56 PM, pankaj gmail account wrote: > Dear Prince and Lalit Thanks for response. > > what i wanted in a excel file:- > > Student ID Class SubjectMarks(Mandatory) > 123

  1   2   >