$$Excel-Macros$$ Track the system Lock

2014-09-18 Thread Ganesh N
i need VBA code for below task I want to do disable and the (windows lock) *window+L* or (lock workstation) or *Crtl+alt+Del*. can every one give the code for that...? -- 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

Re: $$Excel-Macros$$ Loop in cell in different sheet in a workbook

2014-09-18 Thread Paul Schreiner
What is the actual name of your worksheets? Is one actually called "Sheet1" or have you renamed it something else? For instance, if the first sheet in your workbook is called "Data", in the VBA explorer window, it will be called: Sheet1 (Data) If you want to refer to the value of Cells(32 + j, 3

$$Excel-Macros$$ Loop in cell in different sheet in a workbook

2014-09-18 Thread josua sitinjak
Good morning MS EXCEL AND VBA MACROS member. I'm newbie in macros. I would like to ask something. Please help me, I want to loop in a value in different sheet in a workbook at macro excel. ex : I want to compute x value in sheet 2, but to compute the x value, i need y value in sheet 1. I have t

Re: $$Excel-Macros$$ Amazing Excel formulas...

2014-09-18 Thread Waseem Saifi
It is really an amazing collection vaibhav. thank you so much vaibhav. On Thu, Sep 18, 2014 at 8:06 AM, Govardhan Bhatia wrote: > On 9/18/14, Prafull Jadhav wrote: > > Dear Vaibhav Sir, > > > > Thanks for the shared us a very useful file. > > > > > > Regards, > > Prafull Jadhav > > 9920553518 >

Re: $$Excel-Macros$$ Amazing Excel formulas...

2014-09-18 Thread Govardhan Bhatia
On 9/18/14, Prafull Jadhav wrote: > Dear Vaibhav Sir, > > Thanks for the shared us a very useful file. > > > Regards, > Prafull Jadhav > 9920553518 > > On 18 September 2014 17:32, Ganesh N wrote: > >> Got it sir!! Thanks >> >> One more help sir. Like formulas do you have sample files for macros ?

Re: $$Excel-Macros$$ Amazing Excel formulas...

2014-09-18 Thread Prafull Jadhav
Dear Vaibhav Sir, Thanks for the shared us a very useful file. Regards, Prafull Jadhav 9920553518 On 18 September 2014 17:32, Ganesh N wrote: > Got it sir!! Thanks > > One more help sir. Like formulas do you have sample files for macros ? > just to learn. im a beginner to macro. > > Regards,

Re: $$Excel-Macros$$ Amazing Excel formulas...

2014-09-18 Thread Ganesh N
Got it sir!! Thanks One more help sir. Like formulas do you have sample files for macros ? just to learn. im a beginner to macro. Regards, Ganesh N On Thu, Sep 18, 2014 at 4:59 PM, Vaibhav Joshi wrote: > ok, COGS is named range, press Ctr + G you will see all defined cells. > Select COGS you w

Re: $$Excel-Macros$$ Amazing Excel formulas...

2014-09-18 Thread Vaibhav Joshi
ok, COGS is named range, press Ctr + G you will see all defined cells. Select COGS you will be taken to range. Cheers!! + *I did not do this for you. God is here working through me for you.* On Thu, Sep 18, 2014 at 4:55 PM, Ganesh N wrote: > Yes sir no macro but can you tell me how the for

Re: $$Excel-Macros$$ Amazing Excel formulas...

2014-09-18 Thread Ganesh N
Yes sir no macro but can you tell me how the formula works ? e.g =SUM(COGS) how is sum the cogs ? Note: if I add some more amount in addition row/col it not working Regards, Ganesh N On Thu, Sep 18, 2014 at 4:25 PM, Vaibhav Joshi wrote: > Hi > > There is no Macro in this file, it contains

Re: $$Excel-Macros$$ Amazing Excel formulas...

2014-09-18 Thread Vaibhav Joshi
Hi There is no Macro in this file, it contains formula only. Cheers!! + *I did not do this for you. God is here working through me for you.* On Thu, Sep 18, 2014 at 3:36 PM, Ganesh N wrote: > Hi Vaibhav Ji, > > Can you please explain how the attachment works because I cant even see > any

Re: $$Excel-Macros$$ hi all

2014-09-18 Thread Ashish Kumar
Hi Sunil, PFA.!! Regards Ashish -- 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

Re: $$Excel-Macros$$ Amazing Excel formulas...

2014-09-18 Thread Ganesh N
Hi Vaibhav Ji, Can you please explain how the attachment works because I cant even see any macro in that file. Note: Its in the amazing excel formulas file. Thanks & Regards, Ganesh N On Thu, Sep 18, 2014 at 12:39 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Thanks Vaibhav > > O

Re: $$Excel-Macros$$ hi all

2014-09-18 Thread Vaibhav Joshi
HI Where you will enter value i? Sheet Name & Cell No. Which area of Sheet you want to compare? Sheet Name? Range Name>? What msg you want? + *I did not do this for you. God is here working through me for you.* On Thu, Sep 18, 2014 at 2:21 PM, sunil lobo wrote: > hi i have a value in s

$$Excel-Macros$$ hi all

2014-09-18 Thread sunil lobo
hi i have a value in sheet 1 named black and another sheet named white in Sheet named black in cell A1 i already have a value with validation on it In Sheet named white i have certain values in column A the values are from A1 to A10 Now i am want a vb code to check if i enter a value it has t

Re: $$Excel-Macros$$ Amazing Excel formulas...

2014-09-18 Thread Chandra Shekar
Thanks Vaibhav On Wed, Sep 17, 2014 at 5:22 PM, Vaibhav Joshi wrote: > Hi, > > No posts since morning thought of sharing amazing excel formulas by Bill > Jelen aka Mr. Excel. > > Cheers!! > + > *I did not do this for you. God is here working through me for you.* > > -- > Are you =EXP(E:RT) o