Hi Premal,
Today, i uploaded one new file on our group "Excel_tutor.xls"
Try this, it will help you...
Regds,
Manish
On Dec 30, 9:32 am, Premal wrote:
> Hi,
> I am very new to VBA. I know C++.I have few questions related to Excel
> programming.
> 1) I have two xls files Rate.xls and Bill.xls. R
Thanks Ashish,
This is perfect as i want.
I need some more help, If i want to lock only column B to G (not want
to lock entire row) than what will the code.
I want to understand the diff in codes. :)
Thanks once again for your help.
Regds,
Manish
On Dec 30, 10:31 am, ashish koul wrote:
> Priva
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
'target.column =3 because column c is no 3 column
'you can change password ashish and choose your own
ActiveSheet.Unprotect Password:="ashish"
If Not IsEmpty(Target.Value) And Target.Value = "Yes" Then
Rows(Target.Row
Sub InsertWorksheetAfter()
ActiveWorkbook.Worksheets.Add After:=ActiveSheet
End Sub
On Wed, Dec 29, 2010 at 8:31 PM, renuka chari wrote:
> Normally(Shift+F11), when we insert a worksheet in Excel, it will
> appear left to the current sheet. Is it possible to insert a worksheet
>
Any help/suggestion ???
Thanks,
Manish
On Dec 29, 3:03 pm, Manish Pansari wrote:
> Dear EE,
>
> Is it possible to lock the entire row/selected cell based on condition
> in particular Cell.
> for example, I want to lock the row based on value in column A. If
> macro found value "yes" in cell A1 &
Hi Experts,
Kindly suggest me regarding of learning macros with VBA codding
Thanx for your support in advance
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http
Hi,
I am very new to VBA. I know C++.I have few questions related to Excel
programming.
1) I have two xls files Rate.xls and Bill.xls. Rate.xls file contains
two columns which has heading ItemNo and ItemRate.Now I want that in
bill.xls when I enter ItemNo and quantity then final price should be
cal
Thanks, got it to work finally.
On Dec 29, 3:51 am, Dave Bonallack wrote:
> Hi,
> To just do the 3 levels you asked about, try:
> =IF(B16<500,3.5,IF(B16<1000,2.75,2.25))
> Regards - Dave.
>
> Date: Tue, 28 Dec 2010 20:18:30 +0530
> Subject: Re: $$Excel-Macros$$ Nested IF functions?
> From: dilipa
dear friends,
i saw some web based sms companies have excel plugin it will sent dynamic
sms via web
(*dynamic sms* :-excel sheet 1 column is mobile no 2 column is message it
will send each number each different message)
like that any macro is there for sent same dynamic sms via bluetooth and
dude here you go.
there wont be any ans if u type 500 in A3. for rest there will b proper ans.
=IF(A3<500,3.5,IF(AND(5001000,2.5)))
let me know if you require anythig else
happy new year in advance.
- Original Message
> From: J D
> To: MS EXCEL AND VBA MACROS
> Sent: Wed, 29 Decem
Normally(Shift+F11), when we insert a worksheet in Excel, it will
appear left to the current sheet. Is it possible to insert a worksheet
to the right side?
--
--
Some important links for excel users:
1. Follow us on T
Hello,
Thank you very much
Regards,
Chandra Shekar
On Sun, Dec 26, 2010 at 2:23 AM, hanumant shinde
wrote:
> simply select E12:J22 cells lock them then protect sheet using password
> so nobody can unprotect it. see the attached file n let me know if it works
> for u.
>
>
> --
login group and then click on upload file then browse your file then
click on I'm attached my file then ok.
On Dec 29, 3:09 pm, Manish wrote:
> There is no option available. :(
> pls suggest...
>
> Regds,
> Manish Pansari
--
--
Hi,
i want to a graph which is a combination of two graphs.
eg: x axis: date.
y axis:rainfall : 800mm,900mm,750mm,925mm,825mm.etc.
change with respect to sea lvl: 5mm,8mm,9mm,8.5mmetc.
could anyone help me on this?
Thanks & Regards,
Kenil Gala
--
-
Hi Guys,
Anyone looking for a job ?
We need one Excel expert having knowledge on VB scripting in Pune.
If interested .. drop me a mail.
Thanks,
Rajesh
--
--
Some important links for excel users:
1. Follow us on TWI
Hello,
Consider pivot table. I may post a sample file. Just tell what your Excel
version is.
Regards.
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de Walter Moser
Envoyé : mardi 28 décembre 2010 17:04
À : MS EXCEL AND VBA M
Yes it's very clear now. Try any one of the below formula which will do the
trick.
=IF(ISNUMBER(A3),IF(A3>1000,2.5,IF(A3>=500,3,IF(A3<500,3.5,""))),"")
OR
=IF(ISNUMBER(A3),IF(A3<500,3.5,IF(AND(A3>=500,A3<=1000),3,IF(A3>1000,2.5,""))),"")
At the same time herewith I have attached a sample file f
Hi
Thank You
Regards
Rajesh Kainikkara
On 12/27/10, Ms-Exl-Learner . wrote:
> Hi,
>
> In addition to the above post I would like to remove the helper column and
> we make the formula to do the work.
>
> Have a look in the attached file.
>
> ---
> Ms.Exl.Learner
> ---
Hi,
XL is always looking for the opportunity to convert something to a date. In my
region, where we use day, month, year, and with A1 containing the word 'July':
=--(1&A1)
XL reads this as the 1st day of July, then adds the current year as a default.
It returns 40360, which if the cell is format
There is no option available. :(
pls suggest...
Regds,
Manish Pansari
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our
Dear EE,
Is it possible to lock the entire row/selected cell based on condition
in particular Cell.
for example, I want to lock the row based on value in column A. If
macro found value "yes" in cell A1 & A5, Macro will lock the row 1 &
row 5.
I hope its possible in macro. Pls suggest me the code.
Hi
Thanks, if the data is in different sheets can get the min & high
values,Pls check the attached file.
Regards
Rajesh Kainikkara
On 12/27/10, Ms-Exl-Learner . wrote:
> Hi,
>
> In addition to the above post I would like to remove the helper column and
> we make the formula to do the work.
>
>
My code is like the below but I want it to be more generic so if I add
lines, I don't have to reset the range:
Range("N77").Select
Range(Selection, Selection.End(xlToRight)).Select
Range("N77:Y77").Select
Range(Selection, Selection.End(xlDown)).Select
Range("N77:Y81").Select
App
Hello,
so i have this 1+ rows excel sheet. Each row containins a name and
a price - each in its own column. A name may appear various times.
How can i filter the rows in order to display only one row for a given
name. The one row i'd like to display is the one with the highest
price.
How can
Thanks. I have the Syntax correct now but how do I end it. I want to
write a formula that would return the right answer for the below.
if A3 < 500 value will be 3.5
if 5001000 then value will be 2.5
I entered =IF(A3<500,3.5,IF(5001000,2.5 and got
False for an answer. I want to type into A3
Really Impressive!
Let me know how this formula works
On Tue, Dec 28, 2010 at 3:43 PM, Dave Bonallack
wrote:
> Hi,
> A shorter version would be:
> =MONTH(--(1&A1))
> This works for 3-lettered abbreviatios (eg Mar, Oct) as well as extended
> abbreviations (eg Sept) and also unabbreviated (eg
Good.
On Tue, Dec 28, 2010 at 7:39 PM, Daniel wrote:
> Please, see attached file.
> Regards.
> Daniel
>
> -Message d'origine-
> De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
> De
> la part de Rajiv Kumar
> Envoyé : lundi 20 décembre 2010 15:11
> À : excel-macr
Tried to but was blocked from doing so. That is why I pasted what i
could.
On Dec 28, 9:48 am, Dilip Pandey wrote:
> Hi J D,
>
> It would be really appreciable if you can share a test file on this. Help
> us to help you :)
>
> Best Regards,
> DILIPandey
>
>
>
>
>
> On Tue, Dec 28, 2010 at 7:36
Hi Anand,
Thanks for your valuable suggestion.
Pls fwd me the link for ebook. I want ebook on Excel VBA.
Thanks in advance !! :)
Regds,
Manish Pansari
On Dec 9, 12:28 pm, anandydr wrote:
> Hi,
>
> If you do a google search for the term MS Excel VBA tutorials you will
> find a lot of websites f
done using vlookup.. refer attached file
On Tue, Dec 28, 2010 at 8:18 PM, Dilip Pandey wrote:
> Hi J D,
>
> It would be really appreciable if you can share a test file on this. Help
> us to help you :)
>
> Best Regards,
> DILIPandey
>
> On Tue, Dec 28, 2010 at 7:36 AM, J D wrote:
>
>
Hi,
To just do the 3 levels you asked about, try:
=IF(B16<500,3.5,IF(B16<1000,2.75,2.25))
Regards - Dave.
Date: Tue, 28 Dec 2010 20:18:30 +0530
Subject: Re: $$Excel-Macros$$ Nested IF functions?
From: dilipan...@gmail.com
To: excel-macros@googlegroups.com
Hi J D,
á
It would be really apprec
Thanks! Not my own though. Learnt it on another group. Happy to pass it on.
Regards - Dave
Date: Tue, 28 Dec 2010 17:44:51 +0530
Subject: Re: $$Excel-Macros$$ how to get month Occurrence in no.
From: dilipan...@gmail.com
To: excel-macros@googlegroups.com
Impressive ..!!
Good show Dave, Siti,
32 matches
Mail list logo
