$$Excel-Macros$$
Hi Team, Kindly help me in writing macro for a vlookup formula, since I have line item more thant 50k lines so I want get macro for this. Regards, Shilpa -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Test.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ for vlookup
Apologize, with subject matter now. Please help. On Sun, Jan 24, 2010 at 9:57 PM, Shilpa Rao wrote: > Hi Team, > > Kindly help me in writing macro for a vlookup formula, since I have line > item more thant 50k lines so I want get macro for this. > > Regards, > Shilpa > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 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 > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,700 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- Regards, Shilpa -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Re:
Ayush, I can do that but my working file is too big and each time when i change any value/past data for the next month it takes long time to process as there are other formulas in my master file. Can you plz help in getting short macro? Regards, Shilpa On Sun, Jan 24, 2010 at 10:07 PM, Ayush wrote: > Hi Shilpa, > > There is no need of Macro for this...Just drag the formula for 50k > lines and it will automatically change the refernce. > Use autofill & it should work.. > > Let us know if you have doubts. > > Best regards, > Ayush Jain > > On Jan 24, 9:27 pm, Shilpa Rao wrote: > > Hi Team, > > > > Kindly help me in writing macro for a vlookup formula, since I have line > > item more thant 50k lines so I want get macro for this. > > > > Regards, > > Shilpa > > > > Test.xlsx > > 11KViewDownload > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 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 > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,700 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- Regards, Shilpa -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$
Thankyou Dave, Mahesh Ashish for all your help. Thankyou all members in
this group..
On Mon, Jan 25, 2010 at 6:43 AM, Dave Bonallack
wrote:
> Hi Shilpa,
> If you really want to do this with VBA, use the code below.
>
> Sub VlookupVBA()
> A = 1 'Start Row
> Do Until Cells(A, 1) = ""
> With Sheets("Sheet2").Range("A1:A6")
> Set c = .Find(Cells(A, 1), LookIn:=xlFormulas, lookat:=xlWhole)
> If Not c Is Nothing Then Cells(A, 2) =
> Sheets("sheet2").Cells(c.Row, 2)
> A = A + 1
> End With
> Loop
> End Sub
>
> I have also attached a workbook with this code. Just click on the "Update"
> button.
> The code assumes that the data on sheet1 has no gaps. A blank cell in
> Column A is the trigger for it to stop. This can be changed if necessary.
> Remember to enable macros.
> Regards - c.
>
> --
> Date: Sun, 24 Jan 2010 21:57:28 +0530
> Subject: $$Excel-Macros$$
> From: shilpa...@gmail.com
>
> To: excel-macros@googlegroups.com
>
> Hi Team,
>
> Kindly help me in writing macro for a vlookup formula, since I have line
> item more thant 50k lines so I want get macro for this.
>
> Regards,
> Shilpa
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 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
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,700 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
> --
> If It Exists, You'll Find it on SEEK Shopping Trolley
> Mechanic
Re: $$Excel-Macros$$
Hello,
Please provide me any material to learn VBA codings. Advance thanks to all
the experts for your help. .
Regards,
Shilpa
On Mon, Jan 25, 2010 at 4:39 PM, Shilpa Rao wrote:
> Thankyou Dave, Mahesh Ashish for all your help. Thankyou all members in
> this group..
>
> On Mon, Jan 25, 2010 at 6:43 AM, Dave Bonallack > wrote:
>
>> Hi Shilpa,
>> If you really want to do this with VBA, use the code below.
>>
>> Sub VlookupVBA()
>> A = 1 'Start Row
>> Do Until Cells(A, 1) = ""
>> With Sheets("Sheet2").Range("A1:A6")
>> Set c = .Find(Cells(A, 1), LookIn:=xlFormulas,
>> lookat:=xlWhole)
>> If Not c Is Nothing Then Cells(A, 2) =
>> Sheets("sheet2").Cells(c.Row, 2)
>> A = A + 1
>> End With
>> Loop
>> End Sub
>>
>> I have also attached a workbook with this code. Just click on the "Update"
>> button.
>> The code assumes that the data on sheet1 has no gaps. A blank cell in
>> Column A is the trigger for it to stop. This can be changed if necessary.
>> Remember to enable macros.
>> Regards - c.
>>
>>
>> --
>> Date: Sun, 24 Jan 2010 21:57:28 +0530
>> Subject: $$Excel-Macros$$
>> From: shilpa...@gmail.com
>>
>> To: excel-macros@googlegroups.com
>>
>> Hi Team,
>>
>> Kindly help me in writing macro for a vlookup formula, since I have line
>> item more thant 50k lines so I want get macro for this.
>>
>> Regards,
>> Shilpa
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>> http://www.excelitems.com
>> 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
>> If you find any spam message in the group, please send an email to:
>> Ayush Jain @ jainayus...@gmail.com
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,700 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>> --
>> If It Exists, You'll Find it on SEEK Shopping Trolley
>> Mechanic<http://clk.atdmt.com/NMN/go/157639755/direct/01/>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>> http://www.excelitems.com
>> 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
>> If you find any spam message in the group, please send an email to:
>> Ayush Jain @ jainayus...@gmail.com
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,700 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
>
>
> --
> Regards,
> Shilpa
>
--
Regards,
Shilpa
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,700 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ need help
Hi, Do we have any tools to automate financial reports? -- Regards, Shilpa -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.
Re: $$Excel-Macros$$ need help
HI any automation tools getting graphs in excel or any other automation tools in excel to get report or any free softwares to get report automated. On Sat, Mar 20, 2010 at 2:47 PM, yogananda muthaiah < yogananda.mutha...@gmail.com> wrote: > Hi, > > Kindly specify your requirements for automating the reports. > > > Regards > Yogananda.Muthaiah > Ph : 9731237267 > > On 3/19/10, Shilpa Rao wrote: > > Hi, > > > > Do we have any tools to automate financial reports? > > > > > > > > -- > > Regards, > > Shilpa > > > > -- > > > -- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > > http://twitter.com/exceldailytip > > 2. Join our Facebook Group @ > > http://www.facebook.com/group.php?gid=287779555678 > > 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 > > > > <><><><><><><><><><><><><><><><><><><><><><> > > HELP US GROW !! > > > > We reach over 6,800 subscribers worldwide and receive many nice notes > about > > the learning and support from the group.Let friends and co-workers know > they > > can subscribe to group at > > http://groups.google.com/group/excel-macros/subscribe > > > > To unsubscribe from this group, send email to > > excel-macros+unsubscribegooglegroups.com or reply to this email with the > > words "REMOVE ME" as the subject. > > > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our Facebook Group @ > http://www.facebook.com/group.php?gid=287779555678 > 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 > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > > To unsubscribe from this group, send email to excel-macros+ > unsubscribegooglegroups.com or reply to this email with the words "REMOVE > ME" as the subject. > -- Regards, Shilpa -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ need help in excel
Hi Friends, I have 2 excel file having 12 sheets in it, what I want is to merge two file into one. I tried using move or copy but it din't work. Is there any method. Please not that i have formula in both file -- Regards, Shilpa -- -- 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
