Re: $$Excel-Macros$$ Re: VBA macro - WhatsApp group.

2016-09-02 Thread Prashant Pednekar
please add me 8308800600 On Mon, Aug 8, 2016 at 9:43 PM, Rajeev Ranjan <06raj...@gmail.com> wrote: > please add the my number 9811503853 > > On Friday, 5 August 2016 14:16:39 UTC+5:30, Prabhu Pinky wrote: >> >> Creating WhatsApp group for VBA macro... Pls msg me your contact, if you >> wants to j

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

2015-05-20 Thread Prashant Pednekar
This will work =IFERROR(IFERROR(MID(A2,FIND("MOC",A2,8),7),UPPER(MID(A2,FIND("moc",A2,7),8))),UPPER(MID(A2,FIND("Moc",A2,7),8))) However may of the cases it is written like MOC 9 or MOC - 08 hence some garbage is appearing. you can remove by text to coloumn command

Re: $$Excel-Macros$$ Help Required

2015-05-20 Thread Prashant Pednekar
pls check On Wed, May 20, 2015 at 2:58 PM, Neeraj wrote: > Dear Experts, > > > > Kindly find the sheet and do the needful formula > > -- > 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$$ Re: Help needed

2015-04-15 Thread Prashant Pednekar
from GEOFORCE,.Hence i have given two pivots and minitab box plot analysis. Hope this will solve your query. Prashant Pednekar. On Wed, Apr 15, 2015 at 10:50 PM, kumar wrote: > Hi, > > Any one looked at it? > > On Wednesday, April 15, 2015 at 3:13:43 PM UTC+1, kumar wrote: >&

Re: $$Excel-Macros$$ Re: Need macro help

2015-03-07 Thread Prashant Pednekar
default of current sheet. Will great help if you can support Prashant. On Fri, Mar 6, 2015 at 11:28 AM, Mandeep Baluja wrote: > Dear Check this file ;) > > Regards, > Mandeep > > > > > On Thursday, March 5, 2015 at 8:39:29 PM UTC+5:30, Prabhu Pinky wrote: >> &

Re: $$Excel-Macros$$ Happy New 2015

2014-12-31 Thread Prashant Pednekar
Dear All Happy new Year to you all. Lets keep journey of collective knowledge addition. Prashant On Wed, Dec 31, 2014 at 7:54 PM, Vaibhav Joshi wrote: > Joyous January –Fabulous February > > Magical March –Adorable April > > Magnificent May –Jolly June > > Jubilant

Fwd: $$Excel-Macros$$ MS Excel 2003 to 2010

2013-10-14 Thread Prashant Pednekar
Good morning all. Sorry ! I did not used *Please help.* in my earlier mail. Request you to help me. Thanks Prashant. -- Forwarded message -- From: Prashant Pednekar Date: Mon, Oct 14, 2013 at 3:21 PM Subject: $$Excel-Macros$$ MS Excel 2003 to 2010 To: excel-macros

$$Excel-Macros$$ MS Excel 2003 to 2010

2013-10-14 Thread Prashant Pednekar
Dear friends We are migrating from MS Excel 2003 to Excel 2010 Dose any one of you has Menu and commond by command comparion in both version.s i.e. 2003 2010 Data > Validation ??? Else is anyone has related material. Regards Prashant -- Are you =

Re: $$Excel-Macros$$ How can I change selected cells from a column into a row?

2013-08-19 Thread Prashant Pednekar
Prashant. On Tue, Aug 20, 2013 at 10:30 AM, Chaya Cooper wrote: > Ashish, > > That's exactly what I needed :-D > > Would you mind showing me how to use it? > > - Chaya > > > On Tuesday, August 20, 2013 12:50:23 AM UTC-4, ashish wrote: > >> Hi try the att

Re: $$Excel-Macros$$ Unlock Cells on Condations

2013-03-15 Thread Prashant Pednekar
("A5:A1500") Set r = .Find(Date, LookIn:=xlFormulas, lookat:=xlWhole) If Not r Is Nothing Then Rows(r.Row).Locked = False End With ActiveSheet.Protect End Sub Regards Prashant On Wed, Jan 20, 2010 at 5:12 AM, Selva wrote: > Hi, > > I need some assistance in unlock

$$Excel-Macros$$ Macro Help

2013-03-03 Thread Prashant Pawle
Dear Team, Please amend macro in attached sheet to automatically select range based on cell value. Thx in advance Regards, Prashant -- 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

$$Excel-Macros$$ formula required

2013-01-13 Thread Prashant Pawle
Dear Team, Need a formula to look up a filed & give sum of figure , sample file attached Regards, Prashant -- 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, Ur

$$Excel-Macros$$ Macro /Formula to Merge Text

2012-12-20 Thread Prashant Pawle
Dear Experts, Please let me know any formula or macro to merge text together . Query is it should conditionally merge text. In the Sample file attached , I want Col C texts are merged in Col D, as long as there is no data in Col A Regards PP -- Join official Facebook page of this forum @ http

$$Excel-Macros$$ Edit Link Code -support

2012-12-13 Thread Prashant Pawle
Dear all, I need to know how convert below code , so that any file path get replaced by below code ActiveWorkbook.ChangeLink Name:= "c:\USER\app\Management Level Adj..xlsm" _ , NewName:="Management Level Adj..xlsm", Type:=xlExcelLinks Regards, Prashant -- Jo

$$Excel-Macros$$

2012-12-02 Thread Prashant Pawle
tPath As String = "c:\Attachments" 'The subject for the outgoing e-mails. Const stSubject As String = "Group MIS" 'The message in the bodies of the outgoing e-mails. Const vaMsg As Variant = "Group MIS Report as per agreement." & vbCrLf & _

Re: $$Excel-Macros$$ VBA CODE REQUIRED

2012-11-11 Thread Prashant Pawle
Dear Ashish, Thanks for the below code. But I need to get output as shown in the attached sheet & code should list all narrow cells in that workbook. Regards Prashant On Sun, Nov 11, 2012 at 12:40 PM, ashish koul wrote: > > Sub sample1() > Dim wk As Worksheet > Dim cl A

$$Excel-Macros$$ VBA CODE REQUIRED

2012-11-10 Thread Prashant Pawle
Dear Team, Need a code for listing cell references from all sheets which have too narrow column width(#). Sample file attached Regards, Prashant -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation

$$Excel-Macros$$ Serial no

2012-10-31 Thread Prashant Pawle
Dear Experts Please help to arrive serial number with if condition Regards, Prashant -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles

$$Excel-Macros$$ Code for combining PDF files thru VBA

2012-07-18 Thread Prashant Pawle
Dear Team, Kindly help on Code for combining multiple PDF files thru VBA regards, Prashant -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need

Re: $$Excel-Macros$$ Need formula

2012-07-12 Thread Prashant Pawle
Dear noor, Please let me know the formula if first cell is empty Then it shd take next cell in array Regards, Prashant On Thu, Jul 12, 2012 at 3:23 PM, NOORAIN ANSARI wrote: > Dear Prashant, > > Please use > > =INDEX($A$2:$A$4,1) > > or > > =OFFSET($A$1,1,0) >

$$Excel-Macros$$ Need formula

2012-07-12 Thread Prashant Pawle
Dear All, Need a formula for getting first text in the Range, in particular cell , sample file attached Regards, Prashant -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula

Re: $$Excel-Macros$$ Find Narrow Cells & Appying Auto fit to only that cell

2012-06-17 Thread Prashant Pawle
Dear ASA, It was great, worked as I wanted Thanks you for help, all experts who helped in this issue Regards, Prashant On Sun, Jun 17, 2012 at 5:57 AM, Asa Rossoff wrote: > My post should work, but I made a "boo boo". The SizeColumns macro should > not have Set Workbook=No

$$Excel-Macros$$ Find Narrow Cells & Appying Auto fit to only that cell

2012-06-16 Thread Prashant Pawle
Dear Team, Please help of some macro to find Narrow Cells & Appying Auto fit to only that cell , sample sheet attached Regards, Prashant -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent,

Fwd: $$Excel-Macros$$ Extract Data Macro Help

2012-06-07 Thread Prashant Pawle
Dear Experts, Please Help Regards, Prashant -- Forwarded message -- From: Prashant Pawle Date: Wed, Jun 6, 2012 at 5:27 PM Subject: $$Excel-Macros$$ Extract Data Macro Help To: "excel-macros@googlegroups.com" Dear Experts, I am trying to extract data from mult

Fwd: $$Excel-Macros$$ Extract Data Macro Help

2012-06-06 Thread Prashant Pawle
Dear All, Please help on below mail Regards, Prashant -- Forwarded message -- From: *Prashant Pawle* Date: Wednesday, June 6, 2012 Subject: $$Excel-Macros$$ Extract Data Macro Help To: "excel-macros@googlegroups.com" Dear Experts, I am trying to extract data fro

$$Excel-Macros$$ Extract Data Macro Help

2012-06-06 Thread Prashant Pawle
Dear Experts, I am trying to extract data from multiple files with helpof macro. I have set data copy parameters in another sheet so that when I change reference of sheets & cells my macro should work accordingly. But I am unable to finish the code, please help Regards, Prashant -- F

$$Excel-Macros$$ Remove this mail id

2012-06-02 Thread prashant pawle
Dear Team, Please remove my this id from mailing list ,I am adding another email id for this groups mails. Regards, Prashant -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula

$$Excel-Macros$$ Access reports publishing

2012-05-28 Thread prashant
Dear gurus, I want to learn access report making from begining, please suggest any site or material which may help Thanx in advance Prashant Sent from my iPhone 4S -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles

Re: $$Excel-Macros$$ Macro for data sorting

2012-05-08 Thread prashant pawle
many thanx noorain On Tue, May 8, 2012 at 1:12 PM, NOORAIN ANSARI wrote: > Dear Prashant, > > Please use below code.. > > *Sub Data_sorting()* > *Sheet2.Activate* > *Cells.Select* > *Selection.Sort Key1:=Range("E2"), Order1:=xlAscending, Header:=xlYes, _* &g

$$Excel-Macros$$ Macro for data sorting

2012-05-08 Thread prashant pawle
Dear Experts, Please ignore previous mail , correct file attached here , please help on below Kindly advise macro to sort data by dt of opening & Macro shd run if the range of data is changed Thanks in advance Regards, Prashant -- FORUM RULES (986+ members already BANNED for viola

$$Excel-Macros$$ MACRO FOR DATA SORT

2012-05-07 Thread prashant pawle
Dear Experts, Kindly advise macro to sort data by dt of opening & Macro shd run if the range of data is changed Thanks in advance Regards, Prashant -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please

Re: $$Excel-Macros$$ Re: Two columns and three criteria

2011-09-18 Thread Prashant Bhawar
xcel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><>

$$Excel-Macros$$ Help on Percentile function

2011-06-20 Thread Prashant
Dear Experts, Need help on how to arrive a percentile for large data , attached sample file & manual working Regards, Prashant -- -- Some important links for excel users: 1. Fo

$$Excel-Macros$$ Recall: Help on Percentile Function

2011-06-20 Thread Prashant
Prashant would like to recall the message, "Help on Percentile Function". -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2

RE: $$Excel-Macros$$ Message box- for Reminder of Due date

2011-06-12 Thread Prashant
Many thanks Daniel, exactly worked as per requirement Regards, Prashant -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Daniel Sent: 11 June, 2011 4:14 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Message

$$Excel-Macros$$ Message box- for Reminder of Due date

2011-06-11 Thread Prashant
Dear Experts, I need help on macro. I need message box to pop up when file is opened. And Message box should show code & name for employees where return date=today. Attached file for reference Regards, Pras

RE: $$Excel-Macros$$ Help in Access

2011-05-02 Thread Prashant
Dear Maries, Thanks a lot, for help. Is it possible to get all information from original tables for these unmatched items Regards, Prashant -Original Message- From: Maries [mailto:talk2mar...@gmail.com] Sent: 02 May, 2011 5:13 PM To: excel-macros@googlegroups.com Cc: Prashant

$$Excel-Macros$$ Help in Access

2011-04-30 Thread Prashant
Dear All, I am trying to create unmatch data query thru access. I have two tables namly bank & lanpos, my qry is throwing only unmatched data from lanpos table, where as I want unmatched data of both tables as my result Please help. Regards, Pras

RE: $$Excel-Macros$$ Help on Macro

2011-04-27 Thread Prashant
Dear Daniel, Many thanks , its working fine Regards, Prashant -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Daniel Sent: 26 April, 2011 10:23 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Help on Macro

Re: $$Excel-Macros$$ date format

2010-07-20 Thread Prashant Jadhav
Dear Deepak, 1st thing is you have to replace (//) with single (/) and have to insert date with dd/mm/ format and not mm/dd/ Your prob will get resolved -- Regards, Prashant On Tue, Jul 20, 2010 at 11:46 AM, Deepak Rawat wrote: > Hi all > > My problem is, there is a fi

$$Excel-Macros$$ Want to convert on Text in each cell to rows

2010-07-09 Thread Prashant Pednekar
Hi all I want to convert on Text in each cell to rows ? In each Cell has 50 + numbers one below one. e.g. 09:51:18 09:51:31 09:52:04 There are five such columns. Can any one help me to convert to rows? Regards. prashant

Re: $$Excel-Macros$$ Interview questions

2010-07-08 Thread Prashant Jadhav
hey vijay, mostly they will ask: vlookup, pivot table (it's mostly used in MIS) -- Regards, Prashant On Thu, Jul 8, 2010 at 3:38 PM, Vijay Aggarwal wrote: > Hi Everyone, > > I am going to attend a interview in MIS field. Please let me know that what > type of question they w

Re: $$Excel-Macros$$ Problem

2010-07-05 Thread Prashant Jadhav
lt;><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subs

RE: $$Excel-Macros$$ Import Data into excel from notepad

2010-06-08 Thread Prashant
Dear Mahesh, Excel 2007 can open file upto 10,48,576. Go to Data Tab> From Text>then select your notepad file & import in excel Regards, Prashant From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Mahesh Sent: 08 June, 2010 7:51 AM

$$Excel-Macros$$ Re: merging worksheet.

2010-06-05 Thread Prashant Pednekar
ActiveSheet For Each MWS In ActiveWindow.SelectedSheets If Not MWS Is AWS Then FAR = AWS.UsedRange.Cells(AWS.UsedRange.Cells.Count).Row + 1 LR = MWS.UsedRange.Cells(MWS.UsedRange.Cells.Count).Row MWS.Range(MWS.Rows(NHR + 1), MWS.Rows(LR)).Copy AWS.Rows(FAR) End If Next MWS End Sub On Sa

$$Excel-Macros$$ merging worksheet.

2010-06-05 Thread Prashant Pednekar
Cell A14 to Cell M74. My requirement is merge data from all worksheets on worksheet ascendingly i.e from sheet 1 data to sheet 135. I am confidant that this can be solved using macro. I request your help to guide me for the logic. Regards. Prashant

$$Excel-Macros$$ Re:Re: Excel Ppt Interface... Please help..Help.

2010-03-29 Thread Prashant Pednekar
On Fri, Mar 26, 2010 at 3:24 PM, Prashant Pednekar wrote: > On Thu, Mar 25, 2010 at 2:32 PM, Prashant Pednekar > wrote: >> Dear All, >> >> I am having presentation (PPT) of 3 slide. Each slide contains one excel >> sheet. >> The last slide will have sum of val

$$Excel-Macros$$ Re: Excel Ppt Interface... Please help..

2010-03-26 Thread Prashant Pednekar
On Thu, Mar 25, 2010 at 2:32 PM, Prashant Pednekar wrote: > Dear All, > > I am having presentation (PPT) of 3 slide. Each slide contains one excel > sheet. > The last slide will have sum of values of Sheet 1 to 2 (i.e. Slide 1 &2 ). > > The original file is having some

$$Excel-Macros$$ Re: Helprequire to unprotect word doc .

2009-11-03 Thread Prashant Bhawar
> Please assist ? > > Please help us on following id: > aligah...@gmail.com > > Rgds, > > Aligahk06 > > > > > > -- Warm Regard Prashant Bhawar ( CA Final ) --~--~-~--~~~---~--~~ --

$$Excel-Macros$$ Re: Help Me

2009-11-03 Thread Prashant Bhawar
use powerutils 1.9 On Tue, Nov 3, 2009 at 2:13 PM, sudhir kumar wrote: > Hi friends > > > Please find the attachement and help me. > > Thanking U > > > > > > -- Warm

$$Excel-Macros$$ Re: Need Help for top 10 sorting

2009-11-02 Thread Prashant Bhawar
02, 2009 12:08 PM > > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Re: Need Help for top 10 sorting > > > > > > > > Regards, > > > > C.G.Kumar > > > ------ > > *From:* excel-macros@googlegroup

$$Excel-Macros$$ Re: Need Help for top 10 sorting

2009-10-30 Thread Prashant Bhawar
hi anish actually i dont want it to sort i want the name of the top 10 learner in top 10 learner column according to there rank (Rank 1 to Rank 10) can it be possible On Fri, Oct 30, 2009 at 1:47 PM, Anish Shrivastava wrote: > Hi Prashant, > > Why dont you use SORT the column which

Re: Fw: $$Excel-Macros$$ PUZZLE Use functions only!!!!SOLUTION!!!!

2009-10-14 Thread Prashant Bhawar
xed value entered in a cell using functions > only not VBA. > > e.g. > Say A1 = ABC351D > > Then the answer in cell A2 should be D153BCA > > The entered value may be text or number anything but result should be >

$$Excel-Macros$$ Re: Plz Help

2009-10-11 Thread Prashant Bhawar
thanks harmeet its working On Sun, Oct 11, 2009 at 4:27 PM, prashant bhawar wrote: > thanks harmeet its working > > > On Sun, Oct 11, 2009 at 2:25 PM, Harmeet Singh > wrote: > >> *Tried to solve the issue in one column, i hope this helps

$$Excel-Macros$$ Plz Help

2009-10-11 Thread Prashant Bhawar
Plz help here i attached a problem file with required ans. plz help me -- Warm Regard Prashant Bhawar ( CA Final ) --~--~-~--~~~---~--~~ -- Some important links for excel users: 1

$$Excel-Macros$$ Re: Cap Gains calculation on shares, on FIFO basis

2009-10-09 Thread Prashant Bhawar
> > > we convert that data into: > > Date of purchase/sale of each share, Quantity=1 (always), Rate per > > share. > > > > So we will end up with data spreading across many rows, as each > > transaction is split into several rows depending on the number of > &

$$Excel-Macros$$ Re: PUZZLE Use functions only

2009-10-04 Thread Prashant Bhawar
t; The entered value may be text or number anything but result should be > reversed. > > Regards > Sandeep > > > > -- Warm Regard Prashant Bhawar ( CA Final ) --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: Enable V Look up Option on the Excel Sheet.

2009-10-04 Thread Prashant Bhawar
hi Dilip, u use formula =VLOOKUP($A:$A,Portfolio!$B:$L,COUNTA(Portfolio!$B$1:B$1)+1,0) if i use this =VLOOKUP($A:$A,Portfolio!$B:$L,2,0) then whts the problem ? On Sat, Oct 3, 2009 at 10:30 PM, prashant bhawar wrote: > hi Dilip, > > u use formula > =VLOOKUP($A:$A,Portfolio!

$$Excel-Macros$$ pop up calender in excel cell

2009-09-16 Thread Prashant Pednekar
HI Dose any one have pop up calender in excel cell. Regards, Prashant. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free

$$Excel-Macros$$ Re: Vlookup and If formula

2009-09-15 Thread prashant
Dear Jitiesh, I have done the same using simple pivot report , then using show report filter pages option of pivot . It is very easy then formulas Regards, Prashant From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Jitheesh Vazhapully Sent

$$Excel-Macros$$ Re: Help plz

2009-09-13 Thread Prashant Bhawar
Thanks Dilip its really useful to me On Sun, Sep 13, 2009 at 11:57 AM, prashant bhawar wrote: > Thanks Dilip its really useful to me > > > > On Sun, Sep 13, 2009 at 10:07 AM, poojari sreevijay > wrote: > >> Hi Prashant, >> >> Please find the attached

$$Excel-Macros$$ Help plz

2009-09-12 Thread Prashant Bhawar
Hello Frnds I want some solution I want to separate First Name, Middle Name & Last Name means if I hav Full name in A1 then i want First name in B1, Middle Name in C2 & Last name in C3 -- Warm Regard Prashant Bhawar ( C

$$Excel-Macros$$ Re: Filter problem

2009-09-09 Thread Prashant Pednekar
Dear Sathish & Harmeet Thanks for clarificaiton. Regards. On Wed, Sep 9, 2009 at 2:32 AM, Harmeet Singh wrote: > Hi Prashant, Unfortunately, excel can show you first 100 unique entries > only in auto filter (It is hard coded in Excel) > > Workaround can be pivot table. >

$$Excel-Macros$$ Re: (with attachment) Merging Data of two different sheets of two different files

2009-09-08 Thread prashant
Dear Prasad, Please try asap utility , its free add in to excel - link is http://www.asap-utilities.com/download-asap-utilities.php you should be done with it. Reply do u still face a problem Regards, Prashant From: excel-macros@googlegroups.com [mailto:excel-mac

$$Excel-Macros$$ ASAP Utility - a useful add in for excel end user

2009-09-05 Thread prashant
error function , by automatically searching error cells & so on Link http://www.asap-utilities.com/download-asap-utilities.php Regards, Prashant Pawle Finance Executive, Landmark Group- Oman Cell: +968 9647

$$Excel-Macros$$ Re: Urgent....Excel 2007 file recovery

2009-09-05 Thread prashant
Dear Vikas/Satish, Kindly share the trick with all users Regards, Prashant From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of vivek agrawal Sent: Friday, September 04, 2009 9:09 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re

RE: FW: FW: $$Excel-Macros$$ Help Please

2009-09-05 Thread prashant
Dear Dilip, Many thanks , formula is perfect for my need . One more thing, really appreciate your commitment to provide the solution to each & every query of the group members Regards, Prashant From: Dilip Pandey [mailto:dilipan...@gmail.com] Sent: Friday, September 04, 20

$$Excel-Macros$$ Re: PDF Convert Add in

2009-09-05 Thread prashant
http://www.downloadsource.net/d4189/PDFCreator/ Dear Saurabh, This one I use, just print document using pdf creator printer. Regards, Prashant From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Saurabh Sent: Friday, September 04, 2009 12

RE: FW: $$Excel-Macros$$ Help Please

2009-09-02 Thread prashant
Dear Dilip, Tried that option but not able to get exact required output , file attached after a try . please advise & also if there any formula please send. Regards, Prashant From: Dilip Pandey [mailto:dilipan...@gmail.com] Sent: Wednesday, September 02, 2009 5:38 P

$$Excel-Macros$$ Help Please

2009-09-01 Thread prashant
Dear All, Please help as per attachment Thx in advance Regards, Prashant --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials

$$Excel-Macros$$ Re: Urgent - Unprotected sheet

2009-08-28 Thread Prashant Bhawar
On Fri, Aug 28, 2009 at 8:28 PM, prashant bhawar wrote: > > > On Fri, Aug 28, 2009 at 4:11 PM, amresh kumar wrote: > >> Hi My All Friend, >> >> I Forget password of excel file.can u any help in unprotected file. >> >> Regards >> Amresh >

$$Excel-Macros$$ Re: Need help on formula

2009-08-25 Thread Prashant Bhawar
NA > 3001 > > > > > i attched a solution -- Warm Regard Prashant Bhawar --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VB

Re: Fw: $$Excel-Macros$$ V look within a specific range based on criteria

2009-08-24 Thread Prashant Bhawar
On Mon, Aug 24, 2009 at 8:02 PM, prashant bhawar wrote: > > > On Mon, Aug 24, 2009 at 10:49 AM, Sandeep wrote: > >> Hi Prashant, >> >> For changing path of file, the best way for you is to open both of your >> excel files then select >> &#x

Re: Fw: $$Excel-Macros$$ V look within a specific range based on criteria

2009-08-23 Thread Prashant Bhawar
On Sun, Aug 23, 2009 at 7:47 PM, Sandeep wrote: > Hi Prashant, > > I don't know any perticular way for any kind of formula. I just try to > use all related concepts I know, to solve problems. > > Regards > Sandeep > > - Original Message - > *From:* Pr

Re: Fw: $$Excel-Macros$$ V look within a specific range based on criteria

2009-08-23 Thread Prashant Bhawar
your preferred Email name! > <http://sg.rd.yahoo.com/aa/mail/domainchoice/mail/signature/*http://mail.promotions.yahoo.com/newdomains/aa/> > Now you can @ymail.com and @rocketmail.com. > > > Hi Sandeep Can u tel me hw to write such type of formula ? -- Warm Regard Prashant Bhawar --

$$Excel-Macros$$ Re: Protect particular cells of sheet

2009-08-22 Thread Prashant Bhawar
sheet protected. > for both 2003 or 2007 excel. > > > > > > select the cell which u want be editable. right click on them , select format cells option, go to protection tab & just untick the Locked option. now u prote

$$Excel-Macros$$ Re: Need Urgent help in finding formula.

2009-08-22 Thread Prashant Bhawar
the largest value to the particular > item in C. ie Glass/Tiles/Bricks > Kindly assist asap. > Attached is the file for your review. > > Regards, > Vinod > > > > here i attached a soulution file. i think i

$$Excel-Macros$$ Re: Best Tip (Excel POP up Calendar)

2009-08-17 Thread prashant pawle
It is under Developer tab>Insert> Active X Control>Calendar control 12.0 If u dont see Developer tab, then go to excel options>Populer>Developer Tab to activate the same Regards, Prashant On Mon, Aug 17, 2009 at 6:21 PM, big smile wrote: > Respected Master of Excel & f

$$Excel-Macros$$ Help please

2009-08-16 Thread prashant pawle
Dear All Excel Gurus, Kindly help on the problem in the attached sheet. I need formula for ranking , punches as per day/time Regards, Prashant --~--~-~--~~~---~--~~ -- Some

$$Excel-Macros$$ Cell Lock

2009-08-16 Thread prashant pawle
Dear Manish, I tried the same, but my objective is not to allow users to use filter of the cell A1, they may use any of the visible cell except A1 Please advise further Regards, Prashant | Manish Purohit to excel-macros show details 8:25 AM (10 hours ago) Reply [image: Follow up message

$$Excel-Macros$$ Cell Lock

2009-08-15 Thread prashant pawle
Dear All, In the attached sheet advise how to lock onlu one cell (Yellow highlighted) from editing or filtering Thanks in advance Regards, -- Prashant --~--~-~--~~~---~--~~ -- Some

$$Excel-Macros$$ Re: VBA code to select filtered data - irrespective of spread of range

2009-06-27 Thread Prashant Prajapati
uot;A4". Anyways, I think i have found what i've been looking for, and i may be able to figure out the rest. Once again, I thank the group members for support. [?] Bye for now, Prashant. On Sat, Jun 27, 2009 at 2:52 PM, JAYAVELU SUN wrote: > Sorry > ignore previous mail > > P

$$Excel-Macros$$ Re: EXCEL E BOOK .

2009-06-27 Thread Prashant Prajapati
Hi, Please check the group website. There are many good files/ebook uploaded. I just started using one and is helping me. So I guess, it should help others too. Bye for now, Prashant. On Sat, Jun 27, 2009 at 6:01 PM, DEBASHIS BANERJEE wrote: > Kindly send me the PDF copy of EXCEL E. B

$$Excel-Macros$$ Re: macro book!!urgent help

2009-06-26 Thread Prashant Prajapati
Hi, Visit our groups site i.e. on google groups and look for files. There are many files uploaded in our groups section. You'll find one zip file there named Excel 2007 Macros Made Easy.zip (size 4 mb) Check the file. Its nice. I am going through it now. Bye for now, Prashant. On Fri, J

$$Excel-Macros$$ Help needed in email writing

2009-05-20 Thread prashant kulkarni
should select the data (some selected rows) and copy it in the word. 2) after pasting the data, save the word file as PDF 3) get the next data. Any help would be great. Regards, Prashant

$$Excel-Macros$$ Re: Help to remove password for attach file

2009-05-20 Thread prashant kulkarni
I too have some files i have saved long back with passward and now forgot the passward. Please suggest the way to unlock the files on my own. Thanks, Prashant On May 19, 1:26 am, prabhakar jain wrote: > find unprtected file > > > > > > On Mon, May 18, 2009 at 4:50 PM

$$Excel-Macros$$ Re: Cell Validation - Conditional

2009-04-14 Thread Prashant Pednekar
On Tue, Apr 14, 2009 at 12:24 PM, Suryaprasad.bv wrote: > Prashant, > > Can you post me a sample file so that i can help you out > > Cheers > Surya > > > > On Tue, Apr 14, 2009 at 12:16 PM, Prashant Pednekar > wrote: > >> Hi All >> >> here

$$Excel-Macros$$ Re: Cell Validation - Conditional

2009-04-13 Thread Prashant Pednekar
Hi All here my doubt is The Validation is not having constraint, i.e. afte entering one product and specification, if i am again changing the product.the specifition remain same? Eg. Product 2 Specification 6 how can we resolve this ? Regards. Prashant. On Wed, Apr 8, 2009 at 11:33 PM