date:20110619

$$Excel-Macros$$ HELP NEEDED FOR FORMULA

2011-06-19 Thread HARI NAIR

I WANT YOUR VALUE HELP TO PUT A FORMULA IN THE ATTACHED SHEET. PLEASE HELP
THANKS IN ADVANCE..

HARI

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


GIRISH.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Time running out on FREE Index/Match, Vlookup downloads

2011-06-19 Thread Ayush

Tomorrow is the last day to download the free Syntax Memory 
Cards to 
learn Index & Match formulas.
 
Good feedback received from the people already downloaded. :)
 
Regards
Ayush Jain

On Saturday, 18 June 2011 22:08:22 UTC+5:30, Ayush wrote:

> TWO DAYS LEFT :)
>
> On Friday, 17 June 2011 21:41:39 UTC+5:30, Ayush wrote:
>
>> Dear members, 
>>  
>> I saw that you didn't go and check out FREE Index/Match and Vlookup Syntax 
>> Memory Cards  that was 
>> released last week.
>>  
>> You should really go download them because they have gotten 100% positive 
>> feedback AND *Monday is the LAST day* you will be able to have access to 
>> them.
>>  
>> Get your FREE lookup downloads 
>> here
>>  
>> There are ALSO 3 free videos that you should really watch as well. They 
>> show you the logic of these "confusing" lookup formulas and show you some 
>> simple ways to operate them with success.
>>  
>> Get the free content HERE 
>>  
>> You should probably note as well that on Tuesday, June 21st John will be 
>> releasing his brand new Lookup training course and DISCUSSEXCEL group 
>> members will get special discount to buy the same. Keep watching this space. 
>> :)
>>  
>> So go to the page and check out all of the content!
>>  
>> Best Regards,
>> Ayush Jain
>> Group Manager
>>
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

RE: $$Excel-Macros$$ Use of Variabe in Array formula ---- urgent

2011-06-19 Thread Daniel

Hello,

This one works for me :

Selection.FormulaArray = _
"=RC[-4]:R[" & Z & "]C[-4]&RC[-3]:R[" & Z & "]C[-3]&RC[-2]:R[" & Z &
"]C[-2]"

Daniel

-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de hanumant shinde
Envoyé : dimanche 19 juin 2011 13:30
À : Excel Group
Objet : $$Excel-Macros$$ Use of Variabe in Array formula  urgent

Hi Friends,

I really need urgent help. i want to deliver smthing by tomorrow and i stuck
here.

Selection.FormulaArray =
"=RC[-4]:R[46]C[-4]&RC[-3]:R[46]C[-3]&RC[-2]:R[46]C[-2]"
I have this formula and instead of 46th row i want to use Variable "Z". i
tried below things but its not working 


'Selection.FormulaArray = _
'"=RC[-4]:R[" & Z & "]C[-4]&RC[-3]:R[ " & Z & " ]C[-3]&RC[-2]:R[" &
Z & 
"]C[-2]"

' Selection.FormulaArray = _
'"=RC[-4]:R[Z]C[-4]&RC[-3]:R[Z]C[-3]&RC[-2]:R[Z]C[-2]"

--

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip 2. Join our LinkedIN group @
http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and
Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

RE: $$Excel-Macros$$ HELP: Macro to PARSE Lines of Data

2011-06-19 Thread Daniel

Hello,

 

Try :

 

Sub test1()

Dim Enrgt As String

Close #1

Close #2

mypath = "d:\donnees\daniel\mpfe\" 'files path, please change

Open mypath & "RPTbamCommon Maintenance201106061432493.txt" For Input As #1

Open mypath & "Output.txt" For Output As #2

Do While Not EOF(1)

Line Input #1, Enrgt

If Left(Enrgt, 1) = "-" Or Left(Enrgt, 1) = " " Or Left(Enrgt, 1) = "B"
Or _

Len(Enrgt) = 0 Then

Print #2, Enrgt

End If

Loop

Close #2

End Sub

 

Regards.

Daniel

 

De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de uzoma ojemeni
Envoyé : dimanche 19 juin 2011 13:06
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ HELP: Macro to PARSE Lines of Data

 

Dear Friends,

See attached. I need help in developing an excel macro that can delete the
below lines of text

+++HW-Airbridge2011-06-06 14:31:47
O&M#2238404
"%%DSP CBTSCFG: BTSID=200, CFGID=CBTSSECTORCARRIER;%%"
RETCODE = 0  Execution succeeded

BTS SECTOR CARRIER CONFIGURATION

(Number of results = 15)

#NAME?

+++HW-Airbridge2011-06-06 14:31:47
O&M#2238405
"%%DSP CBTSCFG: BTSID=200, CFGID=CBTSSECTORCARRIER;%%"
RETCODE = 0  Execution succeeded

BTS SECTOR CARRIER CONFIGURATION


The expected result should be a table as shown below

 BTS Name  BTS ID   Local Cell ID   Local Sector ID   Carrier ID
TRM ID   CE Pool ID   HPB Flag   PN Sharing Carrier Mode  

 Lekki Ph 2 - 2_SWAP   200  200 0 10
10NO NULL 
 Lekki Ph 2 - 2_SWAP   200  200 0 11
01NO NULL 
 Lekki Ph 2 - 2_SWAP   200  200 0 12
10NO NULL 
 Lekki Ph 2 - 2_SWAP   200  200 1 10
30NO NULL 
 Lekki Ph 2 - 2_SWAP   200  200 1 11
21NO NULL 
 Lekki Ph 2 - 2_SWAP   200  200 1 12
30NO NULL 
 Lekki Ph 2 - 2_SWAP   200  200 2 10
50NO NULL 
 Lekki Ph 2 - 2_SWAP   200  200 2 11
41NO NULL 
 Lekki Ph 2 - 2_SWAP   200  200 2 12
50NO NULL 
 Lekki Ph 2 - 2_SWAP   200  22000 14
14NO NULL 
 Lekki Ph 2 - 2_SWAP   200  22000 15
04NO NULL 
 Lekki Ph 2 - 2_SWAP   200  22001 14
34NO NULL 
 Lekki Ph 2 - 2_SWAP   200  22001 15
24NO NULL 
 Lekki Ph 2 - 2_SWAP   200  22002 14
54NO NULL 
 Lekki Ph 2 - 2_SWAP   200  22002 15
44NO NULL

I would appreciate a prompt response.

Thank you and keep up the wonderful work.

uzoma

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

RE: $$Excel-Macros$$ My first calendar

2011-06-19 Thread Daniel

Hello,

Is the comma your decimal symbol ?

Regards.
Daniel

-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de F4b10cut3r
Envoyé : dimanche 19 juin 2011 16:43
À : MS EXCEL AND VBA MACROS
Objet : $$Excel-Macros$$ My first calendar

Hi everybody,

I´m newbie in the group and I´m trying to create my first calendar.

I´m following step by step this video in youtube:

http://www.youtube.com/watch?v=YA7-d3sadc0

but just in the beginning of the process my formula isn´t working

=Date(B1,B2,1)

and I´m just copying exactly as I´m seeing it on the video.

Does anyone knows what I´m doing wrong.

Thanks a lot in advance.

--

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip 2. Join our LinkedIN group @
http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and
Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ My first calendar

2011-06-19 Thread F4b10cut3r

Hi everybody,

I´m newbie in the group and I´m trying to create my first calendar.

I´m following step by step this video in youtube:

http://www.youtube.com/watch?v=YA7-d3sadc0

but just in the beginning of the process my formula isn´t working

=Date(B1,B2,1)

and I´m just copying exactly as I´m seeing it on the video.

Does anyone knows what I´m doing wrong.

Thanks a lot in advance.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Excel Pop-ups

2011-06-19 Thread Mahreen Ellahi

Hey thanks it worked. Perfect solution

Mahreen

On Sun, Jun 19, 2011 at 11:59 AM, STDEV(i) wrote:

> please check this vba code, hope it helps..
>
> -Standard Module
>
> Sub ExpiryWarning()
>   ' siti Vi // Jakarta, 19 Jan 2011
>   '
>   Dim dTable As Range, t As String
>   Dim R As Long, N As Long, I As Integer
>
>   Set dTable = Cells(1).CurrentRegion
>   N = dTable.Rows.Count
>
>   For R = 2 To N
>  If IsDate(dTable(R, 5)) Then
> I = dTable(R, 5) - Date
> If I <= 15 Then
> If I > 0 Then
>dTable(R, 1).Resize(1, dTable.Columns.Count).Select
>t = "Name  : " & dTable(R, 2) & vbCr & vbCr
>t = t & "Expiry Date : " & Format(dTable(R, 5),
> "dd-mmm-") & vbCr & vbCr
>t = t & "Number of days to come : " & Format(I, "0") & vbCr
>MsgBox t, 48, "Warning"
> End If
> End If
>  End If
>   Next
>   Cells(1).Activate
> End Sub
>
> -Module Sheet1
>
> Private Sub Worksheet_Activate()
>   ExpiryWarning
> End Sub
>
> -Tiisworkbook Module
>
> Private Sub Workbook_Open()
>   ExpiryWarning
> End Sub
>
>
>
> On Sun, Jun 19, 2011 at 12:25 AM, Mahreen Ellahi
>  wrote:
> > Hii
> >
> > I have a some data with limits expiry on different dates. I want to have
> > popup window to appear whenever the limit is about to expire like 15 to
> 30
> > days earlier. Can anyone help me for VBA coding.
> >
> > Regards
> > Mahreen
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Sorting option in Filter Disable-Shortcut Key.Excel 2007

2011-06-19 Thread Mahesh parab

Hi Saravanan

check whether this help

http://www.rondebruin.nl/key.htm

Thanks
Mahesh

On Fri, Jun 17, 2011 at 8:35 PM, saravanan R  wrote:

> Hi Excelates,
>
> I need an Urgent help on disabling the Sort in the filter dropdown.
> Is there a way to disable only the short cut key i.e only the letter s
> & a in the Filter Drop down list.(available in the Excell 2007)
>
> thanks & regards,
> Saravanan
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Re: Use of Variabe in Array formula ---- urgent

2011-06-19 Thread GoldenLance

Selection.FormulaArray = "=RC[-4]:R[" & z & "]C[-4]&RC[-3]:R[" & z &
"]C[-3]&RC[-2]:R[" & z & "]C[-2]"

On Jun 19, 4:29 pm, hanumant shinde  wrote:
> Hi Friends,
>
> I really need urgent help. i want to deliver smthing by tomorrow and i stuck
> here.
>
> Selection.FormulaArray =  
> "=RC[-4]:R[46]C[-4]&RC[-3]:R[46]C[-3]&RC[-2]:R[46]C[-2]"
> I have this formula and instead of 46th row i want to use Variable "Z". i 
> tried
> below things but its not working
>
> '    Selection.FormulaArray = _
> '        "=RC[-4]:R[" & Z & "]C[-4]&RC[-3]:R[ " & Z & " ]C[-3]&RC[-2]:R[" & Z 
> &
> "]C[-2]"
>
> ' Selection.FormulaArray = _
> '        "=RC[-4]:R[Z]C[-4]&RC[-3]:R[Z]C[-3]&RC[-2]:R[Z]C[-2]"

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ how to print at a time more than 5 filess excel and word gather

2011-06-19 Thread Azeem Quraishi (HAB5)

Dear Experts


I need your help how to print at a time more than 5 files excel and word
gather.  I will be very obliged if anybody can support me as earlier as
possible.




 

 

 

 

Best Regards

 

Azeem Quraishi

 

 

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Use of Variabe in Array formula ---- urgent

2011-06-19 Thread hanumant shinde

Hi Friends,

I really need urgent help. i want to deliver smthing by tomorrow and i stuck 
here.

Selection.FormulaArray =  
"=RC[-4]:R[46]C[-4]&RC[-3]:R[46]C[-3]&RC[-2]:R[46]C[-2]"
I have this formula and instead of 46th row i want to use Variable "Z". i tried 
below things but its not working 


'Selection.FormulaArray = _
'"=RC[-4]:R[" & Z & "]C[-4]&RC[-3]:R[ " & Z & " ]C[-3]&RC[-2]:R[" & Z & 
"]C[-2]"

' Selection.FormulaArray = _
'"=RC[-4]:R[Z]C[-4]&RC[-3]:R[Z]C[-3]&RC[-2]:R[Z]C[-2]"

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Leave tracker help required

2011-06-19 Thread maulik desai

Hi All,

I am having 1 Excel sheet which contains 3 sheets
In sheet1 main database  i have to update in every month for Leave
calculation
In Sheet2 I have to find out the total leaves taken in that month with dates
of "IL & "NCNS" Staus from Sheet 1 (details given in attached sheet)
In sheet3 i have to update the candidates details as per his leave dates
(format & details given in attached sheet)
Request you to kindly provide the solution with the help of formulas & macro

For more details kindly find the attached file.

-- 
Thanks & Regards,
Maulik Desai
9967363926

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Leave Tracker.xls
Description: MS-Excel spreadsheet

RE: $$Excel-Macros$$ vba beginner question: manipulating array data

2011-06-19 Thread Daniel

I need a 0 in A1, data starting in A2:B2. Starting date in D1 (calendar one
eg. 12/1/2008), end date in D2.
Formula for a is  (array formula, validate with Ctrl+Shift+Enter) :
=SUMPRODUCT((A2:A1001>=D1)*(A2:A1001<=D2)*IF(DAY(A2:A1001)=D1)*(A2:A1001<=D2)*IF(DAY(A2:A1001)=D1)*(A2:A1001<=D2)*(IF(DAY(A2:A1001)15,1,0)*IF(DAY(A1:A1000)<=15,1,0*B2:B1001)/SUMPROD
UCT((A2:A1001>=D1)*(A2:A1001<=D2)*(IF(DAY(A2:A1001)15,1,0)*IF(DAY(A1:A1000)<=15,1,0)
(not so easy)
With VBA, there are 3 ways to do it :
1. Use "Evaluate" and the formula.
2. Use autofilter
3. Loop through the data and test each date.
Evaluate is the shortest :
ResultForA =
Evaluate("SUMPRODUCT((A2:A1001>=D1)*(A2:A1001<=D2)*IF(DAY(A2:A1001)=D1)*(A2:A1001<=D2)*IF(DAY(A2:A100
1)mailto:excel-macros@googlegroups.com] De
la part de eggman2001
Envoyé : samedi 18 juin 2011 22:40
À : MS EXCEL AND VBA MACROS
Objet : $$Excel-Macros$$ vba beginner question: manipulating array data

I'm just beginning to learn VBA (have experience with Ruby and PHP) and I'm
wondering how you would go about doing the following:

I have paired data in 2 columns - daily historical stock data with the date
in column A and the closing value in column B, and assume I have
10 years worth of data. I'd like to figure out
a) what is the average close price for the earliest day of each month over a
given date range. The earliest day of each month obviously isn't necessarily
the 1st or the 2nd or 3rd of the month since there would be no data for days
that are weekends or national holidays.
b) what is the average close price for the the earliest day of each month
and the earliest day after the 15th of each month (collectively and not
separately) given a date range.

I assume that this is something that is the kind of thing that Excel and VBA
can do fairly easily, as that's why I'm learning it, but haven't quite
gotten that far yet in the book I'm reading.

I appreciate any help with this. Also, if there is some good documentation
for doing these kinds of operations, I'd be much obliged.

--

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip 2. Join our LinkedIN group @
http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and
Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Excel Pop-ups

2011-06-19 Thread STDEV(i)

please check this vba code, hope it helps..

-Standard Module

Sub ExpiryWarning()
  ' siti Vi // Jakarta, 19 Jan 2011
  '
  Dim dTable As Range, t As String
  Dim R As Long, N As Long, I As Integer

  Set dTable = Cells(1).CurrentRegion
  N = dTable.Rows.Count

  For R = 2 To N
     If IsDate(dTable(R, 5)) Then
        I = dTable(R, 5) - Date
        If I <= 15 Then
        If I > 0 Then
           dTable(R, 1).Resize(1, dTable.Columns.Count).Select
           t = "Name  : " & dTable(R, 2) & vbCr & vbCr
           t = t & "Expiry Date : " & Format(dTable(R, 5),
"dd-mmm-") & vbCr & vbCr
           t = t & "Number of days to come : " & Format(I, "0") & vbCr
           MsgBox t, 48, "Warning"
        End If
        End If
     End If
  Next
  Cells(1).Activate
End Sub

-Module Sheet1

Private Sub Worksheet_Activate()
   ExpiryWarning
End Sub

-Tiisworkbook Module

Private Sub Workbook_Open()
   ExpiryWarning
End Sub



On Sun, Jun 19, 2011 at 12:25 AM, Mahreen Ellahi
 wrote:
> Hii
>
> I have a some data with limits expiry on different dates. I want to have
> popup window to appear whenever the limit is about to expire like 15 to 30
> days earlier. Can anyone help me for VBA coding.
>
> Regards
> Mahreen

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


ctv_Excel MsgBox.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ HELP NEEDED FOR FORMULA

$$Excel-Macros$$ Re: Time running out on FREE Index/Match, Vlookup downloads

RE: $$Excel-Macros$$ Use of Variabe in Array formula ---- urgent

RE: $$Excel-Macros$$ HELP: Macro to PARSE Lines of Data

RE: $$Excel-Macros$$ My first calendar

$$Excel-Macros$$ My first calendar

Re: $$Excel-Macros$$ Excel Pop-ups

Re: $$Excel-Macros$$ Sorting option in Filter Disable-Shortcut Key.Excel 2007

$$Excel-Macros$$ Re: Use of Variabe in Array formula ---- urgent

$$Excel-Macros$$ how to print at a time more than 5 filess excel and word gather

$$Excel-Macros$$ Use of Variabe in Array formula ---- urgent

$$Excel-Macros$$ Leave tracker help required

RE: $$Excel-Macros$$ vba beginner question: manipulating array data

Re: $$Excel-Macros$$ Excel Pop-ups

14 matches

Site Navigation

Mail list logo

Footer information