$$Excel-Macros$$ Re: Cap Gains calculation on shares, on FIFO basis
thanks tushar On Sat, Oct 10, 2009 at 10:43 PM, tushar patki wrote: > Hi Prabhakar, > > The transactions pertaining to capital gains are not so straight forward, > say for eg whether the STT is paid on the same or what about the exemptions > available etc. There may be many other angles attached to such > transactions. Hence what I propose you that excel will never be sufficiant > to handle such complexities. Such trannsactions can only be handled with > good database ( remember excel is not a good database but a good flat file > system and an spreadsheet). > > So you can try these things on Access or SQL etc. But in such cases you > need to have a good knowledeg of database and database concepts, such as > normalisation, primary key foreign key etc . > Sorry... dont get nervous.but I think these are the words of > experience. > > Tushar > > On Sat, Oct 10, 2009 at 4:20 PM, prabhakar jain wrote: > >> how can we calculate closing balance in quantity and in value. >> >> On Fri, Oct 9, 2009 at 7:05 PM, Prashant Bhawar < >> prashant.aca...@gmail.com> wrote: >> >>> hi Chinmay here i attached a file hope that its help u. im working on it >>> to make it more simple. >>> >>> >>> On Fri, Oct 9, 2009 at 5:13 AM, RolfJ wrote: >>> You are describing exactly what I had proposed. Should be straightforward to implement. Have fun, Rolf On Oct 8, 7:45 am, chinmay kamat wrote: > Thank you sir, but unfortunately this does not solve the problem. > > The data is in the following format (example): > > For purchases: > Date Quantity Amount Rate > 01/04/08 150/- 85050/-567/- > 05/04/08 100/- 61000/-610/- > 09/04/0825/- 15125/-605/- > 10/04/09 200/-13/-650/- > > For sales: > Date QuantityAmount Rate > 10/04/08 100/- 59000/- 590/- > 07/04/09 175/-117250/- 670/- > 10/04/09 200/-16/- 800/- > > > > Analysis of the data: > > the sale made of 10/04/08 is entirely short term. The cost of 100 > shares sold are selected as follows: 100 out of purchases of 01/04/08. > Profit is (100*590) - (100*567)= 2300/- > > > > The sale made on 02/04/09 is one year later, and the cost for the 175 > shares sold is selected as follows: 50 out of purchases made on > 01/04/08 and 100 out of purchases made on 05/04/08 and 25 out of > purchases made on 06/04/08. > > Profit is (175*670) - ((50*567) + (100*610)+(25*605))= 12775/- > > out of which (150*670) - ((50*567)+(100*610))= 11150/- is long term > > and > > (25*670)-(25*605)=1625/- is short term. > > > > > The sale made on 10/04/09 is speculative because both the sale and > purchased occurred on the same day for all the shares. (as all the > earlier purchases were exhausted) > > > > so the program should not only calculate the profit by subtracting the > cost of shares on FIFO basis (that is identify the earliest existing > stock) but also tell if that was short term, long term or speculative. > > the second problem can easily be solved using the DATEIF function as > explained by you. but since the data does not readily give me the > correlation between the purchases and sales on FIFO basis, the first > problem remains. > > Interesting problem, isnt it..?? > > <><><><><><><><><><><><><><><><> > I have an idea of how to go about the problem, but i do not know how > to implement it. > > See, the data is as follows: > Date of each transaction, Quantity bought/sold in each transaction, > total amount > > we convert that data into: > Date of purchase/sale of each share, Quantity=1 (always), Rate per > share. > > So we will end up with data spreading across many rows, as each > transaction is split into several rows depending on the number of > shares involved. > > We do this for both purchase data and sale data. > > then we place the data side by side, and voila.. just subtract the > selling rate from purchase rate to get profit, then compare the dates > to categorise the transaction. > > You think it may be possible in excel?? or would it be possible in any > other manner??? >>> >>> >>> -- >>> Warm Regard >>> >>> Prashant Bhawar >>> >>> ( CA Final ) >>> >>> >> >> >> -- >> Prabhakar Jain >> Mumbai >> >> > > > -- > Regards > Tushar S Patki > > Contact Details - > 2106, Sadashiv Peth, > Dattaprasad Apartment, > Pune - 411030. > State: Maharashtra
$$Excel-Macros$$ Re: Running Mecro automatically
*Below code will help*
*
*
*Sub waitt()*
*For i = 1 To 5 'will run 5 times*
*'ur code*
*Application.Wait Now + TimeValue("00:00:05") '''will wait for 5 seconds*
*Next*
*End Sub*
Thanks & Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Sun, Oct 11, 2009 at 2:29 PM, Manish Pansari wrote:
>
> Hello Friends,
>
> I want to run a macro continuously after every five minutes. Is there
> any option, by using that I can set macro run time and can run macro
> automatically?
>
> Thanks,
> Manish
>
> >
>
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---
$$Excel-Macros$$ Macro to insert additional row in previous record with new information
A database of customers includes complete information except the email addresses. A new sheet "sheet 2 " is added with Email Addresses in one column "b" with Unique Customer Code in Column "A". Records for some customers use 2 rows and some use more rows. Printing size restricts addition of columns Is it possilbe for a macro to insert a new row after each customer record in the main sheet and copy email address from the new sheet and insert it at the correct customer code. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Macro to insert additional row in previous record with new information
yes, it's possible. the question is: how do you identify the beginning of the "customer record"? What I would do is: Read the email addresses from the second sheet and store them (by customer ID) in a "Dictionary Object". then, set up a loop that starts at the LAST row and works backward (store the 'last row' as the email_row) loop back to the beginning of the record. Determine the customer id, insert a row at the "email_row", and add the email from the Dictionary Object. then set the "email_row" to the current customer row, and proceed backward to the previous customer and repeat the process. I threw this together: From: Hassan Tariq To: MS EXCEL AND VBA MACROS Sent: Monday, October 12, 2009 4:34:24 AM Subject: $$Excel-Macros$$ Macro to insert additional row in previous record with new information A database of customers includes complete information except the email addresses. A new sheet "sheet 2 " is added with Email Addresses in one column "b" with Unique Customer Code in Column "A". Records for some customers use 2 rows and some use more rows. Printing size restricts addition of columns Is it possilbe for a macro to insert a new row after each customer record in the main sheet and copy email address from the new sheet and insert it at the correct customer code. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Macro to insert additional row in previous record with new information
ok... I'm not sure what happened to my last email,
but I'll try again...
I threw this together.
It saves the email addresses into a "Dictionary Object".
(I like using them because they are very fast)
It then determines the last entry in the Data sheet
and works it's way backwords, looking for the string "CustCode:" in
the first column. It then inserts a row and then fills the
new row with the email info.
not elegant, but it works.
( I tested it with 2,000 email addresses and 22,000 "fields")
hope this helps,
Paul
'===
Sub Add_Address()
Dim nRows, curRow, i, AddRow, CustCode
Dim Dict_Addr
'---
' Load Dictionary Object
'---
nRows =
Application.WorksheetFunction.CountA(Sheets("User_Addr").Range("A1:A65000"))
Set Dict_Addr = CreateObject("Scripting.Dictionary")
Dict_Addr.RemoveAll
For i = 2 To nRows
Dict_Addr.Add Sheets("User_Addr")..Cells(i, 1).Value,
Sheets("User_Addr").Cells(i, 2).Value
Next i
'---
' Loop through Data and add email
'---
nRows =
Application.WorksheetFunction.CountA(Sheets("Data").Range("A1:A65000"))
AddRow = nRows + 1
Application.ScreenUpdating = False
For i = nRows To 1 Step -1
If i Mod 25 = 0 Then Application.StatusBar = i
If (UCase(Sheets("Data").Cells(i, 1).Value) = UCase("CustCode:")) Then
CustCode = Cells(i, 2).Value
Rows(AddRow).Insert Shift:=xlDown,
CopyOrigin:=xlFormatFromLeftOrAbove
Sheets("Data").Cells(AddRow, 1) = "email:"
Sheets("Data").Cells(AddRow, 2) = Dict_Addr.Item(CustCode)
AddRow = i
End If
Next i
Application.ScreenUpdating = False
Application.StatusBar = False
End Sub
From: Hassan Tariq
To: MS EXCEL AND VBA MACROS
Sent: Monday, October 12, 2009 4:34:24 AM
Subject: $$Excel-Macros$$ Macro to insert additional row in previous record
with new information
A database of customers includes complete information except the email
addresses. A new sheet "sheet 2 " is added with Email Addresses in one
column "b" with Unique Customer Code in Column "A".
Records for some customers use 2 rows and some use more rows.
Printing size restricts addition of columns
Is it possilbe for a macro to insert a new row after each customer
record in the main sheet and copy email address from the new sheet and
insert it at the correct customer code.
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Plz Help
Hi Prashant Please find the attached solution Hemant Hegde 2009/10/11 Prashant Bhawar > > Plz help here i attached a problem file with required ans. plz help me > -- > Warm Regard > > Prashant Bhawar > > ( CA Final ) > > > > -- Hemant Hegde --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- PROBLEM.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Multiples eMails through Excel with attachment
Following code was sent by someone in one of the group emails recently. I want to send attachment to multiple people, one at a time, using excel lists and path info. please modify the below code for this. regards Haresh Sub SendMail() Dim objOut As Outlook.Application Dim objMail As Outlook.MailItem Dim strTo As String Dim strCC As String Dim strSubject As String Dim strBody As String Dim firstTo As String, secondTo As String firstTo = "johnsm...@usa.com" secondTo = "john...@usa.com" Dim firstCC As String, secondCC As String firstCC = "johnad...@usa.com" secondCC = "jimsm...@usa.com" On Error Resume Next Application.DisplayAlerts = False Set objOut = New Outlook.Application Set objMail = objOut.CreateItem(olMailItem) strTo = firstTo & ";" & secondTo strCC = firstCC & ";" & secondCC strSubject = "Test" strBody = "Your call" strBody = strBody & vbCrLf & "Second line" strBody = strBody & vbCrLf & vbCrLf & "Best regards" With objMail .To = strTo .CC = strCC .Body = strBody .Subject = strSubject .Send End With Set objOut = Nothing Application.DisplayAlerts = True End Sub _ Hotmail: Trusted email with powerful SPAM protection. http://clk.atdmt.com/GBL/go/177141665/direct/01/ --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: PDF password CRACKER
you can use the software Elcomsoft Advanced PDF Password Recovery v4.00 from website vikas gupta On Wed, Sep 30, 2009 at 9:47 PM, Mog Obahor wrote: > > send it to me vivek I will help u crack it. > > On 9/30/09, vivek agrawal wrote: > > Hi There.. > > > > I have downloaded a pdf file which is PASSWORD PROTECTED. > > > > CAn anyone PLEASE help crack the password. IF YES, then pls tell me so > that > > i can mail the pdf file to the concerned person. > > > > I would be very oblidged for the help. > > > > Thanks in advance > > > > > > Thanks and Regards, > > Vivek Agrawal > > Skype ID - vivek.agrawal83 > > > > GoogleMoonlight.com - Saving energy-Save Earth > > > > > > > > > > -- > ** > Omoghene Obahor > www.obahor.com > Cell: 214-493-7403 > Fax: 866-338-1397 > "As a Man Thinks So is He" > ** > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Finding a word within a range
Hi, I have a rectangular range of cells, each one with one word. I have several rows with words and I would like to find if these words match one of the words in the range, and if positive, in which cell of the range. How can I accomplish this ? (if only with functions the better) Thanks/Brgds João --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Pdf Password
Hi All, Can some body help me in cracking a PDF password. I have down loaded a PDF file which is zipped and has a password. I have also downloaded a password cracker also, but I am unable to unzip the file. The password cracker can crack the password only in the PDF file. Please Help Me Regards Umesh Dev --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: heyerlinking many cells
If I correctly understand Nader's requirement he would like to hyperlink each cell in one sheet to the corresponding cell in a second sheet (not all cells to cell A1 of the second sheet). I am not aware of a simple copy and paste route that would accomplish that, but can offer the following macro which accomplishes this for the selected range: Const TARGETSHEET = "Sheet1" Sub LinkToCellsInAnotherSheet() If ActiveSheet.Name = TARGETSHEET Then Exit Sub Dim rCell As Range Dim txtToDisplay As String For Each rCell In Selection If IsEmpty(rCell) Then txtToDisplay = " " Else txtToDisplay = rCell.Value End If ActiveSheet.Hyperlinks.Add Anchor:=rCell, Address:="", SubAddress:=TARGETSHEET & "!" & rCell.Address, TextToDisplay:=txtToDisplay Next rCell End Sub Hope this helped, Rolf On Oct 9, 8:51 pm, "Upendra Singh" wrote: > Hi Nader, > > You can do this in one Go. > Activate the second sheet. In the Cell A1, write "=" without double quotes > and then go to Sheet 1 and select A1. > Press enter. > Press F5 and enter the last cell till where you want to hyperlink (say M500) > Press Shift Enter. > Press F2 and Ctrl+Enter. > This will hyperlink all the cell from A1 to M500 > > Thanks and Regards, > > Upendra Singh > +91-9910227325 > > > > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] > > On Behalf Of nader > Sent: Friday, October 09, 2009 7:54 PM > To: MS EXCEL AND VBA MACROS > Subject: $$Excel-Macros$$ heyerlinking many cells > > Hello, > > I am trying to hyperlink many cells from one sheet to another one in > the same excel file but I can not copy and paste the first hyperlinked > cell to other cell because it always goes to the first cell. > E.g. I want to hyperlink cell A1 in first sheet to cell A1 in second > sheet and then A2 to A2, .. A500 to A500. > > Anybody knows how to do this? > I really appreciate your help > Nader- Hide quoted text - > > - Show quoted text - --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
Fwd: $$Excel-Macros$$ Running Mecro automatically
Thanks & Regards,
Harmeet Singh
Sent via BlackBerry Wireless
-- Forwarded message --
From: Harmeet Singh
Date: Mon, Oct 12, 2009 at 7:28 PM
Subject: Re: $$Excel-Macros$$ Running Mecro automatically
To: Manish Pansari
Here u go
Thanks & Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Mon, Oct 12, 2009 at 1:43 PM, Manish Pansari wrote:
> Thanks Harmeet,
>
> But I am not be able to do it. Can you pls send me a sample mecro file for
> the same.
>
> Thanks in advance buddy !! ! :)
>
> -
> Manish Pansari
>
> On Mon, Oct 12, 2009 at 2:24 PM, Harmeet Singh
> wrote:
>
>> *Below code will help*
>> *
>> *
>> *Sub waitt()*
>> *For i = 1 To 5 'will run 5 times*
>> *'ur code*
>> *Application.Wait Now + TimeValue("00:00:05") '''will wait for 5 seconds*
>> *Next*
>> *End Sub*
>>
>> Thanks & Regards,
>>
>> Harmeet Singh
>>
>> Sent via BlackBerry Wireless
>>
>>
>> On Sun, Oct 11, 2009 at 2:29 PM, Manish Pansari > > wrote:
>>
>>>
>>> Hello Friends,
>>>
>>> I want to run a macro continuously after every five minutes. Is there
>>> any option, by using that I can set macro run time and can run macro
>>> automatically?
>>>
>>> Thanks,
>>> Manish
>>>
>>> >>>
>>>
>>
>
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---
Book1.xls
Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Finding a word within a range
I don't think I can do it using "standard" Excel functions. but I threw together this function: Option Explicit Public Function Find_Str(Search_Text, Data_Array As Range) Dim Data, fflag fflag = False For Each Data In Data_Array If (UCase(Data.Value) = UCase(Search_Text)) Then fflag = True Find_Str = Data.Address Exit For End If Next Data If Not fflag Then Find_Str = "Not Found" End Function if you put it in a VBA module, you can then use it like: =Find_str(A1,Sheet1!A1:C6) Paul From: Joao To: MS EXCEL AND VBA MACROS Sent: Monday, October 12, 2009 7:23:45 AM Subject: $$Excel-Macros$$ Finding a word within a range Hi, I have a rectangular range of cells, each one with one word. I have several rows with words and I would like to find if these words match one of the words in the range, and if positive, in which cell of the range. How can I accomplish this ? (if only with functions the better) Thanks/Brgds João --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ excel 2007 test score
hello, hope you can help,have a worksheet with 2 sheets,class,table.in m1:r1 subject headings and m2:m8 will be pupils names and test scores for that class subject, same for rest with different names for different subjects.anyhow i will have a2:f2 poulated randomly from the lists in m2:r8 ei(a2 will have a name from between m2:m8,ei p lyons 57) p lyons been student name 57 been test score.what i would like is for to pick 3 top test results from a2:f2 and then convert each of them to a 1 and then from that transfer them to table sheet.if anyone is interested in helping i will gladly send a copy for you to examine.as really is a bit complicated to explain.thanks. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Where can I learn about ActiveX Libraries?
I have an Excel based application that references Microsoft ActiveX Data Objects 2.8 Lib. I am about to push this application out to multiple users within our company, but some of them only have Microsoft ActiveX Data Objects 2.5 Lib. Will my application run properly if a user has an older version of the Microsoft ActiveX Data Objects Lib? Where can I go to learn what exactly is included in the Microsoft ActiveX Data Objects Lib and what are the differences between each version? Thank you, --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: filtering dates within this week
If you don't have Excel2007 it gets a bit more complicated. Here is one way to accomplish what you would like to do (for the sake of simplicity I am assuming that your dates are in column A, and that column B can be used as helper column and that you have a header in the first row (cell A1)): Step 1: Enter the following formula in cell B2 which checks whether the date in A2 falls within the same workweek (it's ugly, I know; can't wait to see a simpler solution posted): =IF(ABS(A2-DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW(>7,FALSE(),IF (A2>NOW(),IF(WEEKDAY(A2)>WEEKDAY(NOW()),TRUE(),FALSE()),IF(A2<=NOW(),IF (WEEKDAY(A2) wrote: > I have a series of dates. How can i filter dates that are within this > week? > > thanks --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Managing decimal places
As long as you DON'T try to do any calculations with cell B5 (for the
reason explained by Paul) you would use the following formula in cell
B5:
=IF(B1="USD K",CONCATENATE("USD ",TEXT(B11,"#,###")),CONCATENATE("INR
",TEXT(B10,"#.#")))
If you do need to do calculations with the value in cell B5 I would
suggestion using a different cell to do the calculation with. You
could e.g. use cell C5 and place your own formula in it:
=If(B1="INR Crs",B10,B11)
In case it troubles you (or the users of your workbook) to see cell C5
you could turn it invisible e.g. by choosing white as the font
color...
Hope this helped,
Rolf
On Oct 9, 4:09 am, Radhe Sham L wrote:
> Hi ,
>
> I have a requirement for a solution regarding the display of decimal place
>
> I have a report which displays data in 2 currencies - USD K & INR Crores
>
> Based on the Currency selected from the drop box. The Value in the
> respective currency is required to be displayed in the same cell
>
> for example
> The drop Box for currency selection is in cell B1 (with options "INR Crs" &
> "USD K"
>
> The data is to be displayed in cell B5
>
> The INR value(INR Crs) is stored in cell B10 -> 6.1
> The USD value(USD K) is stored in cell B11 -> 1220
>
> The formula i would use is =If(B1="INR Crs",B10,B11).
>
> Now, what is required is when the currency is INR Crs, the display has to be
> 1.6 (ie with one decimal place) else if it is USD the the display should be
> 1,220 (ie without a decimal place)
>
> Tried using "Fixed" formula , but though it seems to solve my problem by
> what is displayed, the data is in text format due to which calculations are
> not possible
>
> Can any one kindly help me in giving a formula which would display a number
> with one decimal place for "INR Crs" and with no decimal place for USD K
>
> Many thanks in advance
>
> Best regards
> Radhe
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---
$$Excel-Macros$$ How to close vbproject while the workbook is closed.
Hi, I have prepared a macro to get the report done using dao object. what the macro is doing, it is getting data from the same workbook using DAO object from different sheet using SQL. Every thing goes well but the problem comes when I closed the final report in excel application, the VB project remains open in vbe window for that report and I am not getting the way to close this out. becasue after that VBE prompting for error "Device O/I". Please advice. Thanks and Regards Rakesh --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Need help in Excle macro
If you are REALLY concerned about the users of your workbook using
specific commands you could also turn them off by using the OnKey
method in the Workbook_Open event handler. Here's the code on how to
do that for "CTRL+X":
Private Sub Workbook_Open()
Application.OnKey "^{x}", ""
End Sub
Check out http://msdn.microsoft.com/en-us/library/aa195807(office.11).aspx
to find out how to use the OnKey method for other keys.
Hope this helped,
Rolf
On Oct 8, 10:00 pm, Manish Pansari wrote:
> Hello Friends,
>
> I am very new in Excel Macros...
>
> I am triying to devlope a ms excel file with some useful macros..
>
> I want a pop-up window whenever I open the ms excel file. In tht pop-
> up window i want to highlight the instruction like dont use command
> like "Ctrl+X" or edit in "green field only".
>
> Any one can pls help me tht how can I devlope the same. If any one can
> attach a sample file, than it will be more easy for me to learn and
> understand.
>
> Thanks a ton...
>
> -
> Manish
> pansari.man...@gmail.com
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Write numbers in word
Hi Zaheer, Solution is enhanced to accommodate the requirement and attached herewith. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/10/09, ~ Z A H E E R ~ wrote: > > Hi Dilip, > > Thanx for your help yaar. > > Only one problem i faced in "Fils" section is, when i enter amount as > 1250.350 then in words its showing *"Fils .35/1000 Only" *it should be *"Fils > 350/1000 Only"* > * > Once again thanx for your efforts to help me. > > Regards, > ZAHEER > * > > On Fri, Oct 9, 2009 at 8:51 PM, Dilip Pandey wrote: > >> Hi Zaheer, >> >> I have modified the code which I had suggested earlier. Please find the >> attached file with the required modifications done. >> >> Best Regards, >> -- >> DILIP KUMAR PANDEY >>MBA-HR,B COM(Hons.),BCA >> Mobile: +91 9810929744 >> dilipan...@gmail.com >> dilipan...@yahoo.com >> New Delhi - 110062 >> >> >> On 10/8/09, ~ Z A H E E R ~ wrote: >>> >>> hello Dilip, >>> >>> I found the answer, but i dose not match my requirements. and dont knw >>> even "A" of coding. So Plz help me. >>> >>> i need the answer in following format (1,250.365) >>> >>> *Kuwaiti Dinars One Thousand Two Hundred Fifty & Fils 365/1000 Only* >>> ** >>> ** >>> Regards, >>> ZAHEER >>> >>> >>> >>> On Fri, Oct 2, 2009 at 4:20 PM, ~ Z A H E E R ~ wrote: >>> Dear group members, Please help to to write numbers into words automatically. for. eg. if i enter "1,250/365" in any cell then formula or code should give me asnswer in words in any other cell "[Currency Name] Öne Thousand Two Hundred Fifty & [Currency Name for change] 365/1000 Only" i.e Kuwaiti Dinars One Thousand Two Hundred Fifty & Fils 365/1000 Only. Number could be answer of any formula. Please help me. Thanx in advance. >>> >>> >>> >>> >> >> > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- Amount in Word (Kuwaiti Dinars) -rev- By DILipandey.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Write numbers in word
Hi Rajeev, Attached solution is customized to meet your requirements as well. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/10/09, Rajeev Nandan wrote: > > Hi Mr.Dilip, > I want to write amount in words in Million style e.g. AED.12,120,545.50 > (Dirham- Twelve Millions One Hundred Twenty Thousand Five Hundred Forty Five > and Fifty Fills Only.) > > Please help. > Rajeev Nandan > Dubai. > > > On Fri, Oct 9, 2009 at 10:05 PM, Dilip Pandey wrote: > >> Hi Chandra Gupt, >> >> I have modified the code which is suggested earlier, to suit indian >> currency style. Modified code along with an example is attached herewith. >> Thanks. >> >> -- >> DILIP KUMAR PANDEY >>MBA-HR,B COM(Hons.),BCA >> Mobile: +91 9810929744 >> dilipan...@gmail.com >> dilipan...@yahoo.com >> New Delhi - 110062 >> >> >> On 10/4/09, Chandra Gupt Kumar wrote: >>> >>> Dear Dilip, >>> >>> I am not as good as you are. So, could you pls modify the Macro to suite >>> Indian Curreny i.e. Rupees (Rs) and Paisa. >>> >>> Thanks >>> >>> >>> On Sun, Oct 4, 2009 at 4:58 PM, Dilip Pandey wrote: >>> Hi Zaheer, Just answered this one a while ago. Check out and let me know if you did'nt find that email. Thanks, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/2/09, ~ Z A H E E R ~ wrote: > > Dear group members, > > Please help to to write numbers into words automatically. > > for. eg. if i enter "1,250/365" in any cell then formula or code should > give me asnswer in words in any other cell "[Currency Name] Öne Thousand > Two > Hundred Fifty & [Currency Name for change] 365/1000 Only" > > i.e Kuwaiti Dinars One Thousand Two Hundred Fifty & Fils 365/1000 Only. > > Number could be answer of any formula. > > Please help me. > > Thanx in advance. > > >>> >>> >> >> >> > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- Amount in Word-Mill-(Kuwaiti Dinars)- By DILipandey.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Name Matching In Excel
Hi Michael, Actually, if the name of sheet 2 is matching in the list in Sheet 1, then I am saying as "Found". Further to this, I have fetched those names which are matched considering full name and only the first name. Please look at the attached file for further understanding. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/9/09, MD18358 wrote: > > Hi Dilip, > > Is there a way to make the formula kick back the actual matched name? > Even better, I liked the "found"/"not found" column so on the next > column over can I get the actual matched name? > > Thanks for your contribution. You are great!!! > > regards, > Michael > > On Sep 22, 6:18 am, Dilip Pandey wrote: > > Hi Sonal, > > > > The query attached by you has been solved per your expectations and > attached > > herewith. Thanks. > > > > -- > > DILIP KUMAR PANDEY > >MBA-HR,B COM(Hons.),BCA > > Mobile: +91 9810929744 > > dilipan...@gmail.com > > dilipan...@yahoo.com > > New Delhi - 110062 > > > > On 9/21/09, Sonal Gadgil wrote: > > > > > > > > > > > > > Hi... > > > > > I am new in this group. > > > > > I am facing one proble while working in the excel. > > > > > I am having two excel files where i have to map the customer based on > > > customer name by matching customer name manually. > > > > > Now, in case there is any macro available which help me to search & map > > > names this will be great help to me & other users > > > > > Example: > > > > > > > > Name Maching - By DILipandey.xls > > 19KViewDownload- Hide quoted text - > > > > - Show quoted text - --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- Name Maching -rev- By DILipandey.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Macro to insert additional row in previous record with new information
its not working,
is it possible i can send you the data sheet
On Oct 12, 7:10 pm, Paul Schreiner wrote:
> ok... I'm not sure what happened to my last email,
> but I'll try again...
>
> I threw this together.
>
> It saves the email addresses into a "Dictionary Object".
> (I like using them because they are very fast)
>
> It then determines the last entry in the Data sheet
> and works it's way backwords, looking for the string "CustCode:" in
> the first column. It then inserts a row and then fills the
> new row with the email info.
>
> not elegant, but it works.
> ( I tested it with 2,000 email addresses and 22,000 "fields")
>
> hope this helps,
>
> Paul
> '===
>
> Sub Add_Address()
> Dim nRows, curRow, i, AddRow, CustCode
> Dim Dict_Addr
> '---
> ' Load Dictionary Object
> '---
> nRows =
> Application.WorksheetFunction.CountA(Sheets("User_Addr").Range("A1:A65000"))
> Set Dict_Addr = CreateObject("Scripting.Dictionary")
> Dict_Addr.RemoveAll
> For i = 2 To nRows
> Dict_Addr.Add Sheets("User_Addr")..Cells(i, 1).Value,
> Sheets("User_Addr").Cells(i, 2).Value
> Next i
> '---
> ' Loop through Data and add email
> '---
> nRows =
> Application.WorksheetFunction.CountA(Sheets("Data").Range("A1:A65000"))
> AddRow = nRows + 1
> Application.ScreenUpdating = False
> For i = nRows To 1 Step -1
> If i Mod 25 = 0 Then Application.StatusBar = i
> If (UCase(Sheets("Data").Cells(i, 1).Value) = UCase("CustCode:")) Then
> CustCode = Cells(i, 2).Value
> Rows(AddRow).Insert Shift:=xlDown,
> CopyOrigin:=xlFormatFromLeftOrAbove
> Sheets("Data").Cells(AddRow, 1) = "email:"
> Sheets("Data").Cells(AddRow, 2) = Dict_Addr.Item(CustCode)
> AddRow = i
> End If
> Next i
> Application.ScreenUpdating = False
> Application.StatusBar = False
> End Sub
>
>
> From: Hassan Tariq
> To: MS EXCEL AND VBA MACROS
> Sent: Monday, October 12, 2009 4:34:24 AM
> Subject: $$Excel-Macros$$ Macro to insert additional row in previous record
> with new information
>
> A database of customers includes complete information except the email
> addresses. A new sheet "sheet 2 " is added with Email Addresses in one
> column "b" with Unique Customer Code in Column "A".
>
> Records for some customers use 2 rows and some use more rows.
>
> Printing size restricts addition of columns
>
> Is it possilbe for a macro to insert a new row after each customer
> record in the main sheet and copy email address from the new sheet and
> insert it at the correct customer code.
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---
