inash
> *Sent:* Friday, July 06, 2012 10:32 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ help regarding range selection from
> worksheet
>
> hi don thanks for your help
> and sorry for i was not able to explain my requirement but can u plea
Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
> *From:* dguillett1
> *Sent:* Friday, July 06, 2012 9:49 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ help regarding range selection from
> worksheet
>
> Had you
: $$Excel-Macros$$ help regarding range selection from worksheet
hi don thanks for your help
and sorry for i was not able to explain my requirement but can u please explain
me how this code is working and what if the range table which is mentioned in A
and B column is in M and N column???
what will
t;> If Target.Column <> 1 Then Exit Sub
>> Application.Goto Sheets(CStr(Target)).Range(Target.Offset(, 1))
>> End Sub
>>
>> Don Guillett
>> Microsoft Excel Developer
>> SalesAid Software
>> dguille...@gmail.com
>>
>> *From:* Avinash
Next i
End With
End Sub
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: dguillett1
Sent: Friday, July 06, 2012 9:49 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ help regarding range selection from worksheet
Had you explained that you want
th
End Sub
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Avinash
Sent: Friday, July 06, 2012 9:20 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ help regarding range selection from worksheet
Please find attached Excel sheet and run my
e(Target.Offset(, 1))
End Sub
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Avinash
Sent: Friday, July 06, 2012 6:14 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ help regarding range selection from worksheet
hi ashish there is little
Range(rngCell.Offset(, 1).Value).Select
>
> Next rngCell
>
>
>
>
>
> End Sub
>
>
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
>
groups.com
Subject: $$Excel-Macros$$ help regarding range selection from worksheet
Hi all,
i want help regarding range selection from worksheet.
i have created 1 macro to select specific range from sheet and for that
matter i have used below mentioned code
Sheets("sheet1").Selec
Awesome
Jhakaa.!!!
Thank You So Much...!:)
On Thursday, July 5, 2012 10:51:16 PM UTC+5:30, ashish wrote:
>
> try something like this
>
>
> a2 = sheet name
> b2 = cell adress
>
>
> Sub test()
> Sheets(Range("a2").Value).Range(Range("b2"
try something like this
a2 = sheet name
b2 = cell adress
Sub test()
Sheets(Range("a2").Value).Range(Range("b2").Value).Select
End Sub
On Thu, Jul 5, 2012 at 10:47 PM, Avinash wrote:
> Hi all,
>
> i want help regarding range selection from worksheet.
>
> i have created 1 macro to select spe
Hi all,
i want help regarding range selection from worksheet.
i have created 1 macro to select specific range from sheet and for that
matter i have used below mentioned code
Sheets("sheet1").Select
ActiveSheet.Range("C7:BS37").Select
my macro should work on range which i have mentioned in the
-Macros$$ Help regarding bank statment
hi
check the attachment see if it helps
On Fri, Jul 8, 2011 at 10:09 AM, L.K. Modi wrote:
Dear Members,
Thanks for your valuable support. I have an querry in which i have to check
interest calculation for banks.
Me attaching a sheet in
*hi LK modi
use this simpler formula
=LOOKUP(2,1/(A1:A10=A2),B1:B10)
file is attached
*Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Fri, Jul 8, 2011 at 10:56 AM, harsh shah wrote:
> HOPE THIS MIGHT BE USEFUL.
HOPE THIS MIGHT BE USEFUL.
On 8 July 2011 10:09, L.K. Modi wrote:
> Dear Members,
>
> Thanks for your valuable support. I have an querry in which i have to check
> interest calculation for banks.
>
> Me attaching a sheet in which column A have date that is in different
> format. and in column B
hi
check the attachment see if it helps
On Fri, Jul 8, 2011 at 10:09 AM, L.K. Modi wrote:
> Dear Members,
>
> Thanks for your valuable support. I have an querry in which i have to check
> interest calculation for banks.
>
> Me attaching a sheet in which column A have date that is in different
Dear Members,
Thanks for your valuable support. I have an querry in which i have to check
interest calculation for banks.
Me attaching a sheet in which column A have date that is in different
format. and in column B the balance as on the respective dates.
As the bank charges interest on the clos
hi,
the betterr is
=DATE(YEAR(C4),MONTH(C4)+1,5)
because he wants 'next month' 5th.
R.Karunanithi
--- On Thu, 7/7/11, ashish koul wrote:
From: ashish koul
Subject: Re: $$Excel-Macros$$ help regarding date formula
To: excel-macros@googlegroups.com
Date: Thursday, July 7, 2011
Hi,
u use this
=DATE(YEAR(C4),MONTH(C4)+1,5)and drag the fill handle down till c4 is not
blank.
u will get what u want.
R.Karunanithi.
--- On Thu, 7/7/11, L.K. Modi wrote:
From: L.K. Modi
Subject: $$Excel-Macros$$ help regarding date formula
To: excel-macros@googlegroups.com
Date
*ok sir
*Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Thu, Jul 7, 2011 at 11:44 AM, L.K. Modi wrote:
> THANKS A LOT MY PROBLEM IS SOLVED NOW BY THESE VALUABLE MEMBERS
>
>
> REGARDS
> LKMODI
>
> On Thu, Jul 7, 2011
THANKS A LOT MY PROBLEM IS SOLVED NOW BY THESE VALUABLE MEMBERS
REGARDS
LKMODI
On Thu, Jul 7, 2011 at 10:25 AM, L.K. Modi wrote:
> Dear Members,
>
> Me attaching a sheet which relates to Excise duty payment.The result should
> be 5 of the next of the month of Invoice.We are currently doing it
(YEAR(C4),MONTH(C4)+1,5)*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *L.K. Modi
> *Sent:* Thursday, July 07, 2011 10:26 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ help regarding date formula
&
Use this in D4
=DATE(YEAR(C4),MONTH(C4)+1,5)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of L.K. Modi
Sent: Thursday, July 07, 2011 10:26 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ help regarding date formula
Dear Members
use this=DATE(YEAR(C4),MONTH(C4),5)
On Thu, Jul 7, 2011 at 10:25 AM, L.K. Modi wrote:
> Dear Members,
>
> Me attaching a sheet which relates to Excise duty payment.The result should
> be 5 of the next of the month of Invoice.We are currently doing it
> manually. But is there any formula b
Dear Members,
Me attaching a sheet which relates to Excise duty payment.The result should
be 5 of the next of the month of Invoice.We are currently doing it
manually. But is there any formula by which we can do that fast and in less
time. Hope you wil surely help me.
Regards
LKModi
--
hi it is possible through vlookup see the attachment as i am in office in
our right now we are using MS Excel 2003 that's why i could not able to see
your file and give prompt solution but I hope this will help u if not plz
feel free to revert me.
On Tue, May 25, 2010 at 3:36 PM, Jai wrote:
>
Just paste this formula that will work same
=IF(B50="material",10.3%,4.12%)
On May 25, 3:06 pm, Jai wrote:
> Dear All
>
> 1. When we Selcet the Type of Work ( Material ) Service tax Show 4.12
> %,
>
> 2. When we Selcet the Type of Work ( Labour ) Service tax Show 10.3
> %
>
> Can
hi
i am trying to select the all the data of page and paste into excel
Sub ABC()
Dim IE
Dim objShell
Set IE = CreateObject("InternetExplorer.Application")
Set objShell = CreateObject("WScript.Shell")
With IE
.Left = 20
.Top = 20
.Height = 540
.Width = 9
Please assist me in attached file
Rgds,
Aligahk06
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
h
Dear All, I have a workbook with sheet1 (name of sheet qty) and sheet2(name
of sheet price) I want in Sheet2(price) i.e multiplication of qty and price
cell by cell and then sum of each multiplication in a cell. i.e Qty.Sheet
price sheet Cell c6:c21 c6:c21 Cell d6:d21 d6:d21 ... upto Cell j6:j21
j6
can i use this formula to another sheet extract data from another sheet.
-- Forwarded message --
From: Anish Shrivastava
Date: Tue, Aug 25, 2009 at 3:32 PM
Subject: Re: $$Excel-Macros$$ Help regarding formula
To: excel-macros@googlegroups.com
Cc: vidyutm...@gmail.com
Hi Vidyut
plz find attd. excel file. i want formula for particular q.No. Mtrs on
particular date.
txn in advance.
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tu
32 matches
Mail list logo
