$$Excel-Macros$$ Help Required!
Hi Team Members, I have a query with regard to outlook email. Can anyone please suggest or advice me how to proceed with this. Requirement: An email should be send automatically with below subject and body to the mentioned address. Copying the left most sheet in the attached excel in a separate workbook.(Please refer attached excel sheet) Details: To:= amrahs...@gmail.com CC:= amra...@gmail.com Subject:= Incoming Status! Body:= Tracker have been updated and Job card is generated for the same. Please check the attachment for more details. Thanks in Advance, Regards, Sharma -- -- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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 Sample.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Lookup Multiple values and display horizontally
See if this helps.
Regards,
Bruno
2010/8/24 ҉Shine
> Thank you Ashish. I appreciate your effort and time you spent for it. But
> I am looking for a combination function that can do the job. VBA cannot be
> used
>
> Thank you
>
> Best Regards
> Shine
>
>
> On 23 August 2010 20:52, ashish koul wrote:
>
>> hi sort your data on item basis first
>>
>> try this
>>
>>
>> Sub Macro1()
>> Dim i, z, k, t As Long
>> t = 2
>> z = Application.WorksheetFunction.CountA(ActiveSheet.Range("a:a"))
>> k = 2
>>
>> For i = 2 To z
>>
>> If Range("a" & i + 1).Value <> Range("a" & i).Value Then
>>
>>
>> Range("B" & k & ":B" & i).Select
>> Selection.Copy
>>
>> Range("E" & t).Select
>> Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone,
>> SkipBlanks:= _
>> False, Transpose:=True
>> Range("A" & i).Select
>> Application.CutCopyMode = False
>> Selection.Copy
>> Range("D" & t).Select
>> ActiveSheet.Paste
>> k = i + 1
>>t = t + 1
>> End If
>>
>> Next i
>>
>> End Sub
>>
>>
>>
>> regards
>> ashish koul
>> akoul.blogspot.com
>>
>>
>>
>>
>>
>> On Mon, Aug 23, 2010 at 5:32 PM, wrote:
>>
>>> Attached: Lookup Multiple values and display horizontally
>>> Message from shin...@gmail.com:
>>>
>>> Hi
>>>
>>> It would be helpful if someone can provide a solution without using VBA
>>>
>>> I have a series of data as shown on left side of the sheet. I want to get a
>>> summary of it as shown on right side. What I am trying to get is a
>>> combination function that looks up for multiple values and display it
>>> horizontally. Requesting you to help me out.
>>>
>>> Thanks
>>> Shine
>>>
>>>
>>>
>>> Google Docs makes it easy to create, store and share online documents,
>>> spreadsheets and presentations.
>>> [image: Logo for Google Docs]
>>>
>>> --
>>>
>>> --
>>> 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
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> HELP US GROW !!
>>>
>>> We reach over 7000 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
>>>
>>
>> --
>>
>> --
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 7000 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
>>
>
>
>
> -
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 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
>
--
--
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@google
Re: $$Excel-Macros$$ Urgent: SUMIF +
Thanks Paul. Unfortunately the formula is too long for Excel. That's the error I got. But I certainly appreciate the effort because it does work when it's shortened. I've come up with another solution using a pivot table but it makes the file larger and more cumbersome. But, hey, it's a solution. :) Maybe someone else will have an idea that's easier to use. From: Paul Schreiner To: excel-macros@googlegroups.com Sent: Tue, August 24, 2010 12:07:33 PM Subject: Re: $$Excel-Macros$$ Urgent: SUMIF + it might be a problem with the length of the function! depending your your version of Excel, it MAY have a 256 character limit. Each sumif statement is nearly than 50 characters, so 21 of them would be 1050 characters!... you may have a problem... it may mean you need to separate it into several cells, or use a VBA function to handle the calculations! Paul From: None To: excel-macros@googlegroups.com Sent: Tue, August 24, 2010 1:45:31 PM Subject: Re: $$Excel-Macros$$ Urgent: SUMIF + Can this work having about 21 SUMIF formulas in one cell? From: None To: excel-macros@googlegroups.com Sent: Tue, August 24, 2010 10:26:55 AM Subject: Re: $$Excel-Macros$$ Urgent: SUMIF + Paul: Thank you! Your "a" solution works and I'm sorry the sample was wrong. I can't thank you enough for your assistance. From: Paul Schreiner To: excel-macros@googlegroups.com Sent: Tue, August 24, 2010 9:00:11 AM Subject: Re: $$Excel-Macros$$ Urgent: SUMIF + Well... I've got "A" solution: =SUMIF(Payment!EA:EA,RIGHT($A2,6),Payment!$P:$P) +SUMIF(Payment!EB:EB,RIGHT($A2,6),Payment!$U:$U) +SUMIF(Payment!EC:EC,RIGHT($A2,6),Payment!$Z:$Z) ... btw: your sample result is incorrect. rows 6 and 7 are 167891 instead of 567891, yet you included them in your calculation. this isn't the best way... I'd probably write it as VBA and loop through... hope this helps, Paul From: None To: excel-macros@googlegroups.com Sent: Tue, August 24, 2010 10:50:51 AM Subject: $$Excel-Macros$$ Urgent: SUMIF + I sent this yesterday and didn't hear back and have a deadline looming. I'm really hoping someone has a solution to this dilemma. As this data changes often, manually adding up the numbers just doesn't make sense but I may have to break down and do that. Does anyone have any ideas on how to do this with a formula? Thanks for any and all ideas. Sorry for the rush on this. - Forwarded Message From: None To: excel-macros@googlegroups.com Sent: Mon, August 23, 2010 7:40:05 AM Subject: $$Excel-Macros$$ I need a multiple SUMIF type formula. In the attached book, there is a Log sheet that needs the formula in cells M2 and M3. The formula in cell M2 needs to look in Payment in columns EA-EU for the last 6 digits in cell M2 in the Log. If it finds it, it needs to sum the corresponding amounts in columns P, U, etc. In the Log sheet in cells O2 and O3 I've given what amount the formula should return. I'm hoping someone can help with this. Thanks so much. -- -- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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 -- -- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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 -- -- Some important links for excel users: 1. Follow us on TWITTER fo
Re: $$Excel-Macros$$ Urgent: SUMIF +
it might be a problem with the length of the function! depending your your version of Excel, it MAY have a 256 character limit. Each sumif statement is nearly than 50 characters, so 21 of them would be 1050 characters!... you may have a problem... it may mean you need to separate it into several cells, or use a VBA function to handle the calculations! Paul From: None To: excel-macros@googlegroups.com Sent: Tue, August 24, 2010 1:45:31 PM Subject: Re: $$Excel-Macros$$ Urgent: SUMIF + Can this work having about 21 SUMIF formulas in one cell? From: None To: excel-macros@googlegroups.com Sent: Tue, August 24, 2010 10:26:55 AM Subject: Re: $$Excel-Macros$$ Urgent: SUMIF + Paul: Thank you! Your "a" solution works and I'm sorry the sample was wrong. I can't thank you enough for your assistance. From: Paul Schreiner To: excel-macros@googlegroups.com Sent: Tue, August 24, 2010 9:00:11 AM Subject: Re: $$Excel-Macros$$ Urgent: SUMIF + Well... I've got "A" solution: =SUMIF(Payment!EA:EA,RIGHT($A2,6),Payment!$P:$P) +SUMIF(Payment!EB:EB,RIGHT($A2,6),Payment!$U:$U) +SUMIF(Payment!EC:EC,RIGHT($A2,6),Payment!$Z:$Z) ... btw: your sample result is incorrect. rows 6 and 7 are 167891 instead of 567891, yet you included them in your calculation. this isn't the best way... I'd probably write it as VBA and loop through... hope this helps, Paul From: None To: excel-macros@googlegroups.com Sent: Tue, August 24, 2010 10:50:51 AM Subject: $$Excel-Macros$$ Urgent: SUMIF + I sent this yesterday and didn't hear back and have a deadline looming. I'm really hoping someone has a solution to this dilemma. As this data changes often, manually adding up the numbers just doesn't make sense but I may have to break down and do that. Does anyone have any ideas on how to do this with a formula? Thanks for any and all ideas. Sorry for the rush on this. - Forwarded Message From: None To: excel-macros@googlegroups.com Sent: Mon, August 23, 2010 7:40:05 AM Subject: $$Excel-Macros$$ I need a multiple SUMIF type formula. In the attached book, there is a Log sheet that needs the formula in cells M2 and M3. The formula in cell M2 needs to look in Payment in columns EA-EU for the last 6 digits in cell M2 in the Log. If it finds it, it needs to sum the corresponding amounts in columns P, U, etc. In the Log sheet in cells O2 and O3 I've given what amount the formula should return. I'm hoping someone can help with this. Thanks so much. -- -- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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 -- -- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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 -- -- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the
Re: $$Excel-Macros$$ Urgent: SUMIF +
No problem. It's not an "elegant" solution, but it works. VBA would be better (and more fun) Paul From: None To: excel-macros@googlegroups.com Sent: Tue, August 24, 2010 1:26:55 PM Subject: Re: $$Excel-Macros$$ Urgent: SUMIF + Paul: Thank you! Your "a" solution works and I'm sorry the sample was wrong. I can't thank you enough for your assistance. From: Paul Schreiner To: excel-macros@googlegroups.com Sent: Tue, August 24, 2010 9:00:11 AM Subject: Re: $$Excel-Macros$$ Urgent: SUMIF + Well... I've got "A" solution: =SUMIF(Payment!EA:EA,RIGHT($A2,6),Payment!$P:$P) +SUMIF(Payment!EB:EB,RIGHT($A2,6),Payment!$U:$U) +SUMIF(Payment!EC:EC,RIGHT($A2,6),Payment!$Z:$Z) ... btw: your sample result is incorrect. rows 6 and 7 are 167891 instead of 567891, yet you included them in your calculation. this isn't the best way... I'd probably write it as VBA and loop through... hope this helps, Paul From: None To: excel-macros@googlegroups.com Sent: Tue, August 24, 2010 10:50:51 AM Subject: $$Excel-Macros$$ Urgent: SUMIF + I sent this yesterday and didn't hear back and have a deadline looming. I'm really hoping someone has a solution to this dilemma. As this data changes often, manually adding up the numbers just doesn't make sense but I may have to break down and do that. Does anyone have any ideas on how to do this with a formula? Thanks for any and all ideas. Sorry for the rush on this. - Forwarded Message From: None To: excel-macros@googlegroups.com Sent: Mon, August 23, 2010 7:40:05 AM Subject: $$Excel-Macros$$ I need a multiple SUMIF type formula. In the attached book, there is a Log sheet that needs the formula in cells M2 and M3. The formula in cell M2 needs to look in Payment in columns EA-EU for the last 6 digits in cell M2 in the Log. If it finds it, it needs to sum the corresponding amounts in columns P, U, etc. In the Log sheet in cells O2 and O3 I've given what amount the formula should return. I'm hoping someone can help with this. Thanks so much. -- -- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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 -- -- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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 -- -- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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 -- -- 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 h
Re: $$Excel-Macros$$ Urgent: SUMIF +
Can this work having about 21 SUMIF formulas in one cell? From: None To: excel-macros@googlegroups.com Sent: Tue, August 24, 2010 10:26:55 AM Subject: Re: $$Excel-Macros$$ Urgent: SUMIF + Paul: Thank you! Your "a" solution works and I'm sorry the sample was wrong. I can't thank you enough for your assistance. From: Paul Schreiner To: excel-macros@googlegroups.com Sent: Tue, August 24, 2010 9:00:11 AM Subject: Re: $$Excel-Macros$$ Urgent: SUMIF + Well... I've got "A" solution: =SUMIF(Payment!EA:EA,RIGHT($A2,6),Payment!$P:$P) +SUMIF(Payment!EB:EB,RIGHT($A2,6),Payment!$U:$U) +SUMIF(Payment!EC:EC,RIGHT($A2,6),Payment!$Z:$Z) ... btw: your sample result is incorrect. rows 6 and 7 are 167891 instead of 567891, yet you included them in your calculation. this isn't the best way... I'd probably write it as VBA and loop through... hope this helps, Paul From: None To: excel-macros@googlegroups.com Sent: Tue, August 24, 2010 10:50:51 AM Subject: $$Excel-Macros$$ Urgent: SUMIF + I sent this yesterday and didn't hear back and have a deadline looming. I'm really hoping someone has a solution to this dilemma. As this data changes often, manually adding up the numbers just doesn't make sense but I may have to break down and do that. Does anyone have any ideas on how to do this with a formula? Thanks for any and all ideas. Sorry for the rush on this. - Forwarded Message From: None To: excel-macros@googlegroups.com Sent: Mon, August 23, 2010 7:40:05 AM Subject: $$Excel-Macros$$ I need a multiple SUMIF type formula. In the attached book, there is a Log sheet that needs the formula in cells M2 and M3. The formula in cell M2 needs to look in Payment in columns EA-EU for the last 6 digits in cell M2 in the Log. If it finds it, it needs to sum the corresponding amounts in columns P, U, etc. In the Log sheet in cells O2 and O3 I've given what amount the formula should return. I'm hoping someone can help with this. Thanks so much. -- -- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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 -- -- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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 -- -- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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 -- -- 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
Re: $$Excel-Macros$$ Lookup Multiple values and display horizontally
HI
see if this helps you
regards
ashish koul
akoul.blogspot.com
2010/8/24 ҉Shine
> Thank you Ashish. I appreciate your effort and time you spent for it. But
> I am looking for a combination function that can do the job. VBA cannot be
> used
>
> Thank you
>
> Best Regards
> Shine
>
>
> On 23 August 2010 20:52, ashish koul wrote:
>
>> hi sort your data on item basis first
>>
>> try this
>>
>>
>> Sub Macro1()
>> Dim i, z, k, t As Long
>> t = 2
>> z = Application.WorksheetFunction.CountA(ActiveSheet.Range("a:a"))
>> k = 2
>>
>> For i = 2 To z
>>
>> If Range("a" & i + 1).Value <> Range("a" & i).Value Then
>>
>>
>> Range("B" & k & ":B" & i).Select
>> Selection.Copy
>>
>> Range("E" & t).Select
>> Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone,
>> SkipBlanks:= _
>> False, Transpose:=True
>> Range("A" & i).Select
>> Application.CutCopyMode = False
>> Selection.Copy
>> Range("D" & t).Select
>> ActiveSheet.Paste
>> k = i + 1
>>t = t + 1
>> End If
>>
>> Next i
>>
>> End Sub
>>
>>
>>
>> regards
>> ashish koul
>> akoul.blogspot.com
>>
>>
>>
>>
>>
>> On Mon, Aug 23, 2010 at 5:32 PM, wrote:
>>
>>> Attached: Lookup Multiple values and display horizontally
>>> Message from shin...@gmail.com:
>>>
>>> Hi
>>>
>>> It would be helpful if someone can provide a solution without using VBA
>>>
>>> I have a series of data as shown on left side of the sheet. I want to get a
>>> summary of it as shown on right side. What I am trying to get is a
>>> combination function that looks up for multiple values and display it
>>> horizontally. Requesting you to help me out.
>>>
>>> Thanks
>>> Shine
>>>
>>>
>>>
>>> Google Docs makes it easy to create, store and share online documents,
>>> spreadsheets and presentations.
>>> [image: Logo for Google Docs]
>>>
>>> --
>>>
>>> --
>>> 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
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> HELP US GROW !!
>>>
>>> We reach over 7000 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
>>>
>>
>> --
>>
>> --
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 7000 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
>>
>
>
>
> -
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 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
>
--
--
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,
Re: $$Excel-Macros$$ Urgent: SUMIF +
Paul: Thank you! Your "a" solution works and I'm sorry the sample was wrong. I can't thank you enough for your assistance. From: Paul Schreiner To: excel-macros@googlegroups.com Sent: Tue, August 24, 2010 9:00:11 AM Subject: Re: $$Excel-Macros$$ Urgent: SUMIF + Well... I've got "A" solution: =SUMIF(Payment!EA:EA,RIGHT($A2,6),Payment!$P:$P) +SUMIF(Payment!EB:EB,RIGHT($A2,6),Payment!$U:$U) +SUMIF(Payment!EC:EC,RIGHT($A2,6),Payment!$Z:$Z) ... btw: your sample result is incorrect. rows 6 and 7 are 167891 instead of 567891, yet you included them in your calculation. this isn't the best way... I'd probably write it as VBA and loop through... hope this helps, Paul From: None To: excel-macros@googlegroups.com Sent: Tue, August 24, 2010 10:50:51 AM Subject: $$Excel-Macros$$ Urgent: SUMIF + I sent this yesterday and didn't hear back and have a deadline looming. I'm really hoping someone has a solution to this dilemma. As this data changes often, manually adding up the numbers just doesn't make sense but I may have to break down and do that. Does anyone have any ideas on how to do this with a formula? Thanks for any and all ideas. Sorry for the rush on this. - Forwarded Message From: None To: excel-macros@googlegroups.com Sent: Mon, August 23, 2010 7:40:05 AM Subject: $$Excel-Macros$$ I need a multiple SUMIF type formula. In the attached book, there is a Log sheet that needs the formula in cells M2 and M3. The formula in cell M2 needs to look in Payment in columns EA-EU for the last 6 digits in cell M2 in the Log. If it finds it, it needs to sum the corresponding amounts in columns P, U, etc. In the Log sheet in cells O2 and O3 I've given what amount the formula should return. I'm hoping someone can help with this. Thanks so much. -- -- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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 -- -- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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 -- -- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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 -- -- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers wor
Re: $$Excel-Macros$$ Urgent: SUMIF +
Well... I've got "A" solution: =SUMIF(Payment!EA:EA,RIGHT($A2,6),Payment!$P:$P) +SUMIF(Payment!EB:EB,RIGHT($A2,6),Payment!$U:$U) +SUMIF(Payment!EC:EC,RIGHT($A2,6),Payment!$Z:$Z) ... btw: your sample result is incorrect. rows 6 and 7 are 167891 instead of 567891, yet you included them in your calculation. this isn't the best way... I'd probably write it as VBA and loop through... hope this helps, Paul From: None To: excel-macros@googlegroups.com Sent: Tue, August 24, 2010 10:50:51 AM Subject: $$Excel-Macros$$ Urgent: SUMIF + I sent this yesterday and didn't hear back and have a deadline looming. I'm really hoping someone has a solution to this dilemma. As this data changes often, manually adding up the numbers just doesn't make sense but I may have to break down and do that. Does anyone have any ideas on how to do this with a formula? Thanks for any and all ideas. Sorry for the rush on this. - Forwarded Message From: None To: excel-macros@googlegroups.com Sent: Mon, August 23, 2010 7:40:05 AM Subject: $$Excel-Macros$$ I need a multiple SUMIF type formula. In the attached book, there is a Log sheet that needs the formula in cells M2 and M3. The formula in cell M2 needs to look in Payment in columns EA-EU for the last 6 digits in cell M2 in the Log. If it finds it, it needs to sum the corresponding amounts in columns P, U, etc. In the Log sheet in cells O2 and O3 I've given what amount the formula should return. I'm hoping someone can help with this. Thanks so much. -- -- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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 -- -- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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 -- -- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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$$ Lookup Multiple values and display horizontally
Thank you Ashish. I appreciate your effort and time you spent for it. But I
am looking for a combination function that can do the job. VBA cannot be
used
Thank you
Best Regards
Shine
On 23 August 2010 20:52, ashish koul wrote:
> hi sort your data on item basis first
>
> try this
>
>
> Sub Macro1()
> Dim i, z, k, t As Long
> t = 2
> z = Application.WorksheetFunction.CountA(ActiveSheet.Range("a:a"))
> k = 2
>
> For i = 2 To z
>
> If Range("a" & i + 1).Value <> Range("a" & i).Value Then
>
>
> Range("B" & k & ":B" & i).Select
> Selection.Copy
>
> Range("E" & t).Select
> Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone,
> SkipBlanks:= _
> False, Transpose:=True
> Range("A" & i).Select
> Application.CutCopyMode = False
> Selection.Copy
> Range("D" & t).Select
> ActiveSheet.Paste
> k = i + 1
>t = t + 1
> End If
>
> Next i
>
> End Sub
>
>
>
> regards
> ashish koul
> akoul.blogspot.com
>
>
>
>
>
> On Mon, Aug 23, 2010 at 5:32 PM, wrote:
>
>> Attached: Lookup Multiple values and display horizontally
>> Message from shin...@gmail.com:
>>
>> Hi
>>
>> It would be helpful if someone can provide a solution without using VBA
>>
>> I have a series of data as shown on left side of the sheet. I want to get a
>> summary of it as shown on right side. What I am trying to get is a
>> combination function that looks up for multiple values and display it
>> horizontally. Requesting you to help me out.
>>
>> Thanks
>> Shine
>>
>>
>>
>> Google Docs makes it easy to create, store and share online documents,
>> spreadsheets and presentations.
>> [image: Logo for Google Docs]
>>
>> --
>>
>> --
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 7000 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
>>
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 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
>
-
--
--
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
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 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$$ XmlHttp Object
Hi, I want to login to facebook.com using XmlHtpp Object. How can i do so??If not do any one has examples to login to any other websites??? Thanks -- -- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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$$ Digest for excel-macros@googlegroups.com - 8Messages in 6 Topics
Sent via BlackBerry by AT&T
-Original Message-
From: excel-macros+nore...@googlegroups.com
Sender: excel-macros@googlegroups.com
Date: Sun, 22 Aug 2010 23:39:03
To: Digest Recipients
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 8
Messages in 6 Topics
=
Today's Topic Summary
=
Group: excel-macros@googlegroups.com
Url: http://groups.google.com/group/excel-macros/topics
- paths between cells [1 Update]
http://groups.google.com/group/excel-macros/t/433b8f3fdcbe9b46
- what is coding of previous and next button in excel [1 Update]
http://groups.google.com/group/excel-macros/t/f7999c9df1fadf53
- Need Help in Cross tab [2 Updates]
http://groups.google.com/group/excel-macros/t/c595c4f3ae07243c
- converting 2003 to 2010xl [1 Update]
http://groups.google.com/group/excel-macros/t/f4bd67525121a4b1
- Moving from 2003 to 2010 xl [1 Update]
http://groups.google.com/group/excel-macros/t/363ae54e85decf5
- Ageing of data [2 Updates]
http://groups.google.com/group/excel-macros/t/5eb3701b28d42bf3
=
Topic: paths between cells
Url: http://groups.google.com/group/excel-macros/t/433b8f3fdcbe9b46
=
-- 1 of 1 --
From: n3wsgr0ups
Date: Aug 22 07:32AM -0700
Url: http://groups.google.com/group/excel-macros/msg/7c77ab9f0c3d6939
Need you brains guys!
Suppose I have a defined range on my worksheet, and within that range
I have numbers or blank cells. i'm trying to write some vba code that
given 2 cells as a start and stop point, finds all the blank cell
"paths" between those two numbers.
ie suppose 1 is at a1 and 5 is at c4 and the range is a1 to e6, i need
to produce a list of non blank cell paths between the 1 and 5. a path
being a way to traverse the cells between the two numbers by "walking"
on non-blank cells including cells that touch at corners.
Thanks in anticipation.
=
Topic: what is coding of previous and next button in excel
Url: http://groups.google.com/group/excel-macros/t/f7999c9df1fadf53
=
-- 1 of 1 --
From: neil johnson
Date: Aug 22 02:25PM +0530
Url: http://groups.google.com/group/excel-macros/msg/aa01e6965ecef686
Hi Everyone,
I make user form in excel. But I don't know how to run *"Previous button and
next Button" in *excel by making vba code. Please help .
What is Syntax of this button ?
I know only Syntax = dim lastrow
lastrow = range("A65550").end(xlup).row+1
range("A" &lastrow).value = textbox1.text
range("B" & lastrow).value = textbox2.text
Thanks
=
Topic: Need Help in Cross tab
Url: http://groups.google.com/group/excel-macros/t/c595c4f3ae07243c
=
-- 1 of 2 --
From: Dave Bonallack
Date: Aug 22 03:10PM +0800
Url: http://groups.google.com/group/excel-macros/msg/2fb14d7887ea9ebd
Hi,
I have re-done your sheet using VBA.
It will accommodate as many rows as needed on the report sheet, and up to
10,000 rows on the DATA sheet (although this can easily be increased)
The button can be moved to any convenient spot on the worksheet. Just
right-click, then drag it.
Regards - Dave.
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need Help in Cross tab
From: shariqcoo...@gmail.com
Date: Sat, 21 Aug 2010 10:19:33 +
Yes Dave..the solution is very good..but I want to do this by clicking
the bottom and the data could me any length n the only constant thing is the
hours which is not more then 22 but can be less
Sent on my BlackBerry® from Vodafone
From: Dave Bonallack
Sender: excel-macros@googlegroups.com
Date: Sat, 21 Aug 2010 18:16:12 +0800
To: excel-macros@googlegroups.com
ReplyTo: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Need Help in Cross tab
Thanks Andy. You're welcome.
Regards - Dave.
Date: Sat, 21 Aug 2010 15:33:03 +0530
Subject: Re: $$Excel-Macros$$ Need Help in Cross tab
From: aind...@gmail.com
To: excel-macros@googlegroups.com
Hey Dave,
This is great!! you never stop amazing me with your simple solutions to complex
problems..
Keep it up man!!
You are a pillar of our group...
Cheers!!!
Andy
On Sat, Aug 21, 2010 at 2:45 PM, Dave Bonallack
wrote:
Hi Shariq
I've done this with worksheet functions, not VBA.
The original formula is in B3 on the Report sheet. It's then just copied down,
then copied across.
If you really need it in VBA, it can be done easily eno
