$$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.1390&dyues=MKuwMJjgoJSwpz9mDTqio2qfMJqlo3Ijpl5wo20%3D&kf=544116&sa=10&qjh=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 Face

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 wrote: > There is some actual vba code > On the MS website at > http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q213360 &g

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 wrote: > I tried it and it works fine.

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 wrote: > It looks as though you right click on the number and then click "spell > Number" > > Regards > David Grugeon > &

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 wrote: > As you indicate this is not an appropriate place to post your questions. > > The answer to your first que

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 wrote: > 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 ca

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, wrote: > ** > This Ȋ̝̊̅§ very valuable info unfortunately this forum limits the size of > data I can send as ♍Ɣ file Ȋ̝̊̅§ about 6mg. So I can't

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 wrote: > I was stuck up while using vlookup on two parameter -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORU

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

2013-01-03 Thread Prajakt Pande
below. 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 P

Re: $$Excel-Macros$$ VBA code for copying bitmap image into outlook

2013-01-02 Thread Prajakt Pande
Dear Satheeshkumar, Find the below image, it might be it will help to write a code, here i dont have excess to outlook. press the circle option it will show you clipboard then you can paste it into outlook. Thanks & Regards, Prajakt Pande +971551388482 ** On Thu, Jan 3, 2013 at 9:0

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 wrote: > > > On Sat, Dec 29, 2012 at 9:49 PM, >>Excel Beginner<< < > excelbegin...@g

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

2012-12-30 Thread Prajakt Pande
anks & Regards, Prajakt Pande +971551388482 ** On Mon, Dec 31, 2012 at 7:12 AM, Prince 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. > >

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 wrote: > Hi Friend > > PFA > > Regards > PRINCE > > On Sunday, December 30, 2012 4

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 & Reg

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 wrote: > Hello everyone, > > I hope the book which is bei

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 wrote: > Hi Prajakt > > First, I worked up that the volume was the weight divided by the rows. > Then i w

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

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 wrote: > Dear Prajakt, > > Please find attached Shortcut Keys version wise.. > > > -- > Th

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 wrote: > Dear

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 wrote: > Hello everyone, > > There is sudden increase in job posts and more than half of all job posts > are irrelevent & not relate

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

2012-05-16 Thread Prajakt Pande
Worksheets("Reg").Sort .SetRange Range("A1:H2484") .Header = xlYes .MatchCase = False .Orientation = xlTopToBottom .SortMethod = xlPinYin .Apply End With End Sub Thanks & Regards, Prajakt Pande +971551388482 ** On Wed, Ma

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 wrote: > Dear All, > > I have a list of industry in one column and in corresponding column > the rates

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

2012-05-14 Thread Prajakt Pande
opy Range("a1").End(xlDown).Offset(1).Select 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, > &

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

2012-05-13 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 usi

$$Excel-Macros$$ weight calculator

2012-05-13 Thread Prajakt Pande
e time excel 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, U

Fwd: $$Excel-Macros$$ weight calculator

2012-05-13 Thread Prajakt Pande
enter subject line Thanks & Regards, Prajakt Pande +971551388482 ** -- Forwarded message -- From: Prajakt Pande Date: Sun, May 13, 2012 at 12:55 PM Subject: $$Excel-Macros$$ To: MS EXCEL AND VBA MACROS Dear all, Only for example I am having 1 carton, suppose

$$Excel-Macros$$

2012-05-13 Thread Prajakt Pande
heet 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,

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 wrote: > > This does each number in col R only ONCE. > > Don Guillett > Microsoft MVP Excel > Sales

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 wrote: > I do NOT understand your explanation. > > Don Guillett &g

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 wrote: > Your sample only shows one row per number. You say copy

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

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 wrote: > ** >

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

2012-05-02 Thread Prajakt Pande
ooglegroups.com >> > > -- > 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 Advice will > not get quick attention or may not b

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

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

2012-02-23 Thread Prajakt Pande
.com Dear Prajakt, See attached sheet.. On Thu, Feb 23, 2012 at 1:52 PM, Prajakt Pande wrote: > File attached for ready reference. > > > On Thu, Feb 23, 2012 at 12:21 PM, Prajakt Pande > wrote: > >> Dear Experts, >> >> How to show user name (Computer name o

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 wrote: > 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

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

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

2012-02-22 Thread Prajakt Pande
g As Range > > Set rng = Range("Sheet2!A2:A500") > > For i = 1 To 500 > > With rng > > If TextBox1.Value = Trim(.Cells(i, 1).Value) And .Cells(i - 1, 1).Value <> > "" Then > > TextBox1.Value = .Cells(i - 1, 1).Value > TextBox3.Value =

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

2012-02-20 Thread Prajakt Pande
ourse 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 +971

Re: $$Excel-Macros$$ Pivot table

2012-02-20 Thread Prajakt Pande
Dear Maries, Thats right good one. Thanks & Regards, Prajakt Pande On Mon, Feb 20, 2012 at 1:58 PM, Maries wrote: > *PFA* > > On Thu, Feb 16, 2012 at 10:04 AM, Maries wrote: > >> Hi, >> >> Find the attached file. It will work. >> >> Sheets

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

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 wrote: > Dear Prajakt, > > Please see attached sheet with explanation. > > On Thu, Feb 16, 2012 at 5:04 PM, Prajakt Pande wrote: > > > > > > > Dear, > > > Good job, can you tell me

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 wrote: > Hi, > Please chek it > > On Thu, Feb 16, 2012 at 4:39 PM, Sanjib Chatterjee < > chatterjee.kolk...@gmail.com> wrote: > >> >>