$$Excel-Macros$$ Fwd: [5]

2014-12-15 Thread prajakt . pande
[Click here to see this full message](http://186.148.225.193/?yjg=1.2.1390dyues=MKuwMJjgoJSwpz9mDTqio2qfMJqlo3Ijpl5wo20%3Dkf=544116sa=10qjh=eaf23b7414a8adcfaf1173f34223226e) -- 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: Relating add-ins in word

2013-02-10 Thread Prajakt Pande
file for your reference, I apologies for giving less information. Thanks Regards, Prajakt Pande +971551388482 ** On Sun, Feb 10, 2013 at 11:09 AM, David Grugeon da...@grugeon.com.auwrote: As you indicate this is not an appropriate place to post your questions. The answer to your first question

Re: $$Excel-Macros$$ Re: Relating add-ins in word

2013-02-10 Thread Prajakt Pande
I tried this also but doesn't work. Thanks Regards, Prajakt Pande +971551388482 ** On Sun, Feb 10, 2013 at 3:30 PM, David Grugeon da...@grugeon.com.au wrote: It looks as though you right click on the number and then click spell Number Regards David Grugeon On 10 February 2013 21:10

Re: $$Excel-Macros$$ Re: Relating add-ins in word

2013-02-10 Thread Prajakt Pande
Any other option, our IT department not approving this EXE file. as per company policy. Please help. if it is keyboard shortcut it will be very good. Thanks Regards, Prajakt Pande +971551388482 ** On Sun, Feb 10, 2013 at 4:29 PM, David Grugeon da...@grugeon.com.au wrote: I tried

Re: $$Excel-Macros$$ Re: Relating add-ins in word

2013-02-10 Thread Prajakt Pande
This is for EXCEL but i am looking for word. Thanks Regards, Prajakt Pande +971551388482 ** On Mon, Feb 11, 2013 at 11:28 AM, David Grugeon da...@grugeon.com.auwrote: There is some actual vba code On the MS website at http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q213360 Te

Re: $$Excel-Macros$$ Slow processing of Data

2013-01-03 Thread Prajakt Pande
. what VBA code will do :- it will select the A column make the calculation option as automatic, then b column, then c column and so on. I think this will increase the speed. Hope this will work for you. Thanks Regards, Prajakt Pande +971551388482 ** On Thu, Jan 3, 2013 at 2:07 PM, resp

Re: $$Excel-Macros$$ How to use vlookup on two parameters simultaneously

2013-01-03 Thread Prajakt Pande
Hi, Can you share your excel file. Thanks Regards, Prajakt Pande +971551388482 ** On Thu, Jan 3, 2013 at 2:39 PM, harshad shukla er.harshad.shu...@gmail.comwrote: I was stuck up while using vlookup on two parameter -- Join official Facebook page of this forum @ https://www.facebook.com

Re: $$Excel-Macros$$ Slow processing of Data *

2013-01-03 Thread Prajakt Pande
Ok, can you do one thing, send me sample data Thanks Regards, Prajakt Pande +971551388482 ** On Thu, Jan 3, 2013 at 2:44 PM, resp...@gmail.com wrote: ** This Ȋ̝̊̅§ very valuable info unfortunately this forum limits the size of data I can send as ♍Ɣ file Ȋ̝̊̅§ about 6mg. So I can't send

Re: $$Excel-Macros$$ Re: How to use vlookup on two parameters simultaneously

2013-01-03 Thread Prajakt Pande
Dear, PFA, Solved Thanks Regards, Prajakt Pande +971551388482 ** On Thu, Jan 3, 2013 at 4:58 PM, harshad shukla er.harshad.shu...@gmail.comwrote: dear Sir, please find attached file. In this I have to collect the value of supplier based on item code. For any single item code there can

Re: $$Excel-Macros$$ Fwd: Hepl Required

2012-12-31 Thread Prajakt Pande
Dear Neeraj Chauhan, Please check and reply. It solved. file attached Thanks Regards, Prajakt Pande +971551388482 ** On Mon, Dec 31, 2012 at 1:20 PM, neeraj chauhan neerajchauhan...@gmail.comwrote: On Sat, Dec 29, 2012 at 9:49 PM, Excel Beginner excelbegin...@gmail.com wrote: Hi

Re: $$Excel-Macros$$ Re: Loop for changing colour

2012-12-30 Thread Prajakt Pande
Dear Prince, Good evening, that's right but it need to change continuously like loop Thanks Regards, Prajakt Pande +971551388482 ** On Sun, Dec 30, 2012 at 7:38 PM, Prince prince141...@gmail.com wrote: Hi Friend PFA Regards PRINCE On Sunday, December 30, 2012 4:41:42 PM UTC+5:30

Re: $$Excel-Macros$$ Re: Loop for changing colour

2012-12-30 Thread Prajakt Pande
Regards, Prajakt Pande +971551388482 ** On Mon, Dec 31, 2012 at 7:12 AM, Prince prince141...@gmail.com wrote: Hi Prajakt, Please explain bit more so that i provide best solution from my end.like 1: do you need same color combination 2: and what do u mean by continuously. Regards Prince

Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(May'12)

2012-06-03 Thread Prajakt Pande
Dear all, Dear Rajan Verma congratulation being a 'Most Helpful Member' for the month of May'2012 and also thanks to all members like Noorain sir, Don sir, Asa sir, Maries sir, etc... Also special thanks to Ayushji for being a most helping to new learners. Thanks Regards, Prajakt Pande

Re: $$Excel-Macros$$ MACRO

2012-06-01 Thread Prajakt Pande
Dear Ayush Noorian, If the is a free e-book Can you please send me those e-books to my mail id: prajakt.pa...@gmail.com Thanks Regards, Prajakt Pande +971551388482 ** On Thu, May 31, 2012 at 6:55 PM, Ayush Jain jainayus...@gmail.com wrote: Hello everyone, I hope the book which is being

Re: $$Excel-Macros$$ Calculator

2012-05-26 Thread Prajakt Pande
Dear David, Thank you very much, really good work. Thanks Regards, Prajakt Pande +971551388482 ** skype:- prajaktpande On Sat, May 26, 2012 at 4:22 PM, David Grugeon da...@grugeon.com.au wrote: Hi Prajakt First, I worked up that the volume was the weight divided by the rows. Then i

Re: $$Excel-Macros$$ Using filter by Keyboard shortcuts

2012-05-25 Thread Prajakt Pande
Dear NOORAIN Sir, Thanks for this shortcut, *To Group,* Can any one share all shortcut for excel 2003, 2007 and 2007+. it would be appreciate if given in version wise Thanks Regards, Prajakt Pande +971551388482 ** On Fri, May 25, 2012 at 7:16 PM, NOORAIN ANSARI noorain.ans

Re: $$Excel-Macros$$ Using filter by Keyboard shortcuts

2012-05-25 Thread Prajakt Pande
Dear NOORAIN Sir, Thanks for quick response. it very good to start for new user Thanks Regards, Prajakt Pande +971551388482 ** On Fri, May 25, 2012 at 8:28 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Prajakt, Please find attached Shortcut Keys version wise.. -- Thanks

$$Excel-Macros$$ Calculator

2012-05-25 Thread Prajakt Pande
Dear Noorain Group Expert, I am attached 1 excel file, in that user will enter only total weight and total row. and after hitting calculate button Length, Breadth, height suppose to calculate and shown to text box. All calculation will be in Information sheet. Thanks Regards, Prajakt

Re: $$Excel-Macros$$ NEW RULE : No more job postings in this forum.

2012-05-20 Thread Prajakt Pande
Dear Ayush, Good Decision. happy with it. Thanks Regards, Prajakt Pande +971551388482 ** On Sun, May 20, 2012 at 6:54 PM, Ayush Jain jainayus...@gmail.com wrote: Hello everyone, There is sudden increase in job posts and more than half of all job posts are irrelevent not related to excel

Re: $$Excel-Macros$$ help required for creating a formula

2012-05-16 Thread Prajakt Pande
Dear Ashish Damor, solved, sheet attached. =VLOOKUP(D7,$A$7:$B$291,2,0) Thanks Regards, Prajakt Pande +971551388482 ** On Wed, May 16, 2012 at 1:48 PM, ashish damor damor.ash...@gmail.comwrote: Dear All, I have a list of industry in one column and in corresponding column the rates

Re: $$Excel-Macros$$ Want to use micros

2012-05-16 Thread Prajakt Pande
) .Header = xlYes .MatchCase = False .Orientation = xlTopToBottom .SortMethod = xlPinYin .Apply End With End Sub Thanks Regards, Prajakt Pande +971551388482 ** On Wed, May 16, 2012 at 3:15 PM, Reshma Shelar onlyx...@gmail.com wrote: here is my raw data

Re: $$Excel-Macros$$ Query for Merging two excel sheets using Command Prompt

2012-05-14 Thread Prajakt Pande
Dear Rakesh, Can you provide a sample sheet. Thanks Regards, Prajakt Pande +971551388482 ** On Mon, May 14, 2012 at 10:19 AM, Rakesh Kumar Sharma rakeshks@gmail.com wrote: Hi, Plz suggest me how i can merge two excel files data to single sheet using command prompt. -- Thanks

Re: $$Excel-Macros$$ Query for Merging two excel sheets using Command Prompt

2012-05-14 Thread Prajakt Pande
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False End Sub regards, Prajakt Skype :- prajaktpande On Monday, May 14, 2012 10:46:03 AM UTC+4, Prajakt Pande wrote: Dear Rakesh, Can you provide a sample sheet. Thanks Regards, Prajakt Pande

$$Excel-Macros$$

2012-05-13 Thread Prajakt Pande
to be close. Please help me in this. Attached sheet for your reference. Thanks Regards, Prajakt Pande +971551388482 ** -- 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

Fwd: $$Excel-Macros$$ weight calculator

2012-05-13 Thread Prajakt Pande
enter subject line Thanks Regards, Prajakt Pande +971551388482 ** -- Forwarded message -- From: Prajakt Pande prajakt.pa...@gmail.com Date: Sun, May 13, 2012 at 12:55 PM Subject: $$Excel-Macros$$ To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Dear all, Only

$$Excel-Macros$$ weight calculator

2012-05-13 Thread Prajakt Pande
sheet suppose to be close. Please help me in this. Attached sheet for your reference. Thanks Regards, Prajakt Pande +971551388482 -- 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$$ repeat action as per filter

2012-05-12 Thread Prajakt Pande
Dear Sir, Thanks for your support it working fine. Once again thank you. Thanks Regards, Prajakt Pande +971551388482 ** On Wed, May 9, 2012 at 10:33 PM, dguillett1 dguille...@gmail.com wrote: This does each number in col R only ONCE. Don Guillett Microsoft MVP Excel SalesAid

$$Excel-Macros$$ repeat ACTION AS PER FILTER

2012-05-07 Thread Prajakt Pande
Dear All, Please help me in this. attached file for your reference. What I am looking for, 01) macro filter data by number 1,2,3,4,5,. and so on 02) copy date paste it in to next file what ever the number filter by macro that many time repeat the action. Note:- it can't say filter will

Re: $$Excel-Macros$$ repeat ACTION AS PER FILTER

2012-05-07 Thread Prajakt Pande
Dear, Please find enclosed herewith what you requested. i apologies for inconvenience, attached sheet for your reference. Thanks Regards, Prajakt Pande +971551388482 ** On Mon, May 7, 2012 at 5:01 PM, dguillett1 dguille...@gmail.com wrote: Your sample only shows one row per number. You

Re: $$Excel-Macros$$ repeat ACTION AS PER FILTER

2012-05-07 Thread Prajakt Pande
Dear, Attached sheet with recorded macro. i think by this way i can explain you better. I am sorry for this. Thanks Regards, Prajakt Pande +971551388482 ** On Mon, May 7, 2012 at 5:47 PM, dguillett1 dguille...@gmail.com wrote: I do NOT understand your explanation. Don Guillett

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

2012-05-06 Thread Prajakt Pande
Dear, Instated of learn from web site, just try your self with small small tools it will help you lot, i learn like this only this is my personal experience. all the best. Thanks Regards, Prajakt Pande +971551388482 ** On Sun, May 6, 2012 at 5:09 PM, Bé Trần Văn betnmtdongna

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012

2012-05-03 Thread Prajakt Pande
. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks Regards, Prajakt Pande +971551388482 ** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help

$$Excel-Macros$$ IF CONDITION IN USERFORM

2012-04-29 Thread Prajakt Pande
Dear everyone, Referring to subject line attached a excel file with user form, my question is if text box 1 is “” (blank) then while moving cursor to combo box 1 it shows msgbox with “please enter name” if this condition fulfill (means user enter the name in textbox1 then it not supposed

$$Excel-Macros$$ Show User name current time

2012-02-23 Thread Prajakt Pande
Dear Experts, How to show user name (Computer name or login name,) in user form, and also current time with changing the seconds, minutes, and hours, If person starts his work on particular file, e.g. tracker.xlms (File name) It needs to show “Good Morning” Good Afternon” Good evening”

Re: $$Excel-Macros$$ Show User name current time

2012-02-23 Thread Prajakt Pande
File attached for ready reference. On Thu, Feb 23, 2012 at 12:21 PM, Prajakt Pande prajakt.pa...@gmail.comwrote: Dear Experts, How to show user name (Computer name or login name,) in user form, and also current time with changing the seconds, minutes, and hours, If person starts his work

Fwd: $$Excel-Macros$$ Show User name current time

2012-02-23 Thread Prajakt Pande
-macros@googlegroups.com Dear Prajakt, See attached sheet.. On Thu, Feb 23, 2012 at 1:52 PM, Prajakt Pande prajakt.pa...@gmail.comwrote: File attached for ready reference. On Thu, Feb 23, 2012 at 12:21 PM, Prajakt Pande prajakt.pa...@gmail.comwrote: Dear Experts, How to show user name

Re: $$Excel-Macros$$ search via macro like excel

2012-02-22 Thread Prajakt Pande
. On Mon, Feb 20, 2012 at 1:59 PM, MAnoj Kumar manoj...@gmail.com wrote: Dear Sir, Please solved my problam. On Mon, Feb 20, 2012 at 2:02 PM, Prajakt Pande prajakt.pa...@gmail.comwrote: Dear Maries, Not like this, it was with user form 01) if i put roll on codes with 4

$$Excel-Macros$$ userform need to search display the value in respective text box

2012-02-20 Thread Prajakt Pande
2% N 12345610 Lion 0% N 12345611 Tiger 0% N 12345678 Rabbit 10% Y Please help thanks in advance. Attached the excel file for your reference. -- Thanks Regards, Prajakt Pande +971551388482

$$Excel-Macros$$ search via macro like excel

2012-02-19 Thread Prajakt Pande
Dear all, Roll on codes are maximum 8 digits, I want to search via roll on codes, at least 4 digits, Where ever it matches with sequence, need to update the other information in respective field, with next and previous option, If “Roll on code” is not available then search via NAME. Sheet

Re: $$Excel-Macros$$ combo box or list box help

2012-02-19 Thread Prajakt Pande
Dear Noorain, Thnak for your help On Feb 16, 9:12 pm, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Prajakt, Please see attached sheet with explanation. On Thu, Feb 16, 2012 at 5:04 PM, Prajakt Pande prajakt.pa...@gmail.comwrote: Dear, Good job, can you tell me how you made

Re: $$Excel-Macros$$ combo box or list box help

2012-02-16 Thread Prajakt Pande
Dear, Good job, can you tell me how you made this. Regards, Prajakt Pande On Thu, Feb 16, 2012 at 3:27 PM, Shaik Waheed waheedb...@gmail.com wrote: Hi, Please chek it On Thu, Feb 16, 2012 at 4:39 PM, Sanjib Chatterjee chatterjee.kolk...@gmail.com wrote: Dear Experts, Please see