Re: $$Excel-Macros$$ Fwd: Need help on a formula
see if it helps On Sun, Aug 26, 2012 at 9:40 AM, hemant shah hemanthin...@gmail.com wrote: Dear Experts, I haven't yet received solution for my query below. Please help. Regards, -- Forwarded message -- From: hemant shah hemanthin...@gmail.com Date: Sun, Aug 19, 2012 at 12:56 PM Subject: Need help on a formula To: excel-macros excel-macros@googlegroups.com Dear Experts, I am stuck up which my work in an excel. I need a help on a formula in the attached sheet. I have given a complete details explanation in the attached sheet. Need your help to come out of this situation. For any question or details please revert back. Thanks in advance. Regards, Hemant -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Point Based formula.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Fwd: Need help on data
Yes i need user form in sheet1 and database should be storage in sheet2, as it is there in the cbre payplus sheet(i.e row wise). If it is possible help me on this. Regards Lokesh.M On Thu, May 10, 2012 at 1:49 AM, Asa Rossoff a...@lovetour.info wrote: Hello Bé Trần, I believe that is what Lokesh meant (sheet1 = data entry form; sheet2 = database record storage) -- but I am replying just to provide the suggestion that you type your replies at the top of messages -- I often have difficulty finding your comments, since they are buried down below the old messages. Also, the mailing list automatically puts the rules for the group at the bottom of all messages, further obscuring the location of your message replies. I think more people will notice your comments if you put them at the top of your messages :) ** ** Wishing you a great day! Asa ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Bé Tr?n Van *Sent:* Wednesday, May 09, 2012 8:40 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Fwd: Need help on data ** ** ** ** 2012/5/9 Lokesh Loki lokeshsmg2...@gmail.com Hai Anil, Thanks for resolving the query and thanks for advising me about the user form. Once again thank a lot experts. Regards Lokesh.M ** ** On Wed, May 9, 2012 at 2:42 PM, Anil Gawli gawlianil8...@gmail.com wrote: Attached is the workbook and go to Calculation worksheet. On Wed, May 9, 2012 at 6:01 AM, David Grugeon da...@grugeon.com.au wrote: Hi Lokesh ** ** I do not think you will get a reply from this group to to your question as it is. What you are asking for is more in the nature of application design and that is not a quick and simple answer to a question. This group exists to help people who are having problems with VBA in Excel. Whilst you may need VBA to fill your form (which is not a 'user form' but a spreadsheet set up as an input form) the design of the form and the linking of that form to the relevant spreadsheet is something you will need to do. If your company does not have the relevant skills to do this they may need to hire a contractor to do it. ** ** To give you a start, I would be looking at using a unique identifier (Employee ID for example) to identify the row on sheet two that you want to use in sheet 1. Then I would probably use a macro to copy the data for one line from Sheet 2 to the form, add a button for OK when the changes were done and copy it back to Sheet 2. ** ** We can help you with the macros but the design of the Beautiful form is entirely up to you ** ** You will need to think about what information a user can enter to identify the relevant row of sheet 2. ** ** You will need to think about what operations you need to do create buttons for. I would think Edit (Load), Add, Delete, OK and Cancel at least. ** ** You will also need to specify all the validation rules for any cell which needs them. ** ** When you have done as much work as you can on the form and have identified the answers to all the questions come back to the group for more help with the VBA. ** ** ** ** On 9 May 2012 00:29, Lokesh Loki lokeshsmg2...@gmail.com wrote: Hi Experts, Still i am not receiving any results in the group, could you please help on us for the below query. I need a beautiful form, when i am selecting the name it contains all the data which is already there in sheet2. So based on i need a user form in sheet1. Please do the needful. Thanks in advance. Regards Lokesh.M -- Forwarded message -- From: *Lokesh Loki* lokeshsmg2...@gmail.com Date: Sun, May 6, 2012 at 8:28 PM Subject: Need help on data To: excel-macros@googlegroups.com Hi Experts, Please find the attached excel sheet and i need user form for this team data. Here in the second sheet i have a data, i need user form in the first sheet. Regards Lokesh.M ** ** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Fwd: Need help on data
Hai Anil, Thanks for resolving the query and thanks for advising me about the user form. Once again thank a lot experts. Regards Lokesh.M On Wed, May 9, 2012 at 2:42 PM, Anil Gawli gawlianil8...@gmail.com wrote: Attached is the workbook and go to Calculation worksheet. On Wed, May 9, 2012 at 6:01 AM, David Grugeon da...@grugeon.com.auwrote: Hi Lokesh I do not think you will get a reply from this group to to your question as it is. What you are asking for is more in the nature of application design and that is not a quick and simple answer to a question. This group exists to help people who are having problems with VBA in Excel. Whilst you may need VBA to fill your form (which is not a 'user form' but a spreadsheet set up as an input form) the design of the form and the linking of that form to the relevant spreadsheet is something you will need to do. If your company does not have the relevant skills to do this they may need to hire a contractor to do it. To give you a start, I would be looking at using a unique identifier (Employee ID for example) to identify the row on sheet two that you want to use in sheet 1. Then I would probably use a macro to copy the data for one line from Sheet 2 to the form, add a button for OK when the changes were done and copy it back to Sheet 2. We can help you with the macros but the design of the Beautiful form is entirely up to you You will need to think about what information a user can enter to identify the relevant row of sheet 2. You will need to think about what operations you need to do create buttons for. I would think Edit (Load), Add, Delete, OK and Cancel at least. You will also need to specify all the validation rules for any cell which needs them. When you have done as much work as you can on the form and have identified the answers to all the questions come back to the group for more help with the VBA. On 9 May 2012 00:29, Lokesh Loki lokeshsmg2...@gmail.com wrote: Hi Experts, Still i am not receiving any results in the group, could you please help on us for the below query. I need a beautiful form, when i am selecting the name it contains all the data which is already there in sheet2. So based on i need a user form in sheet1. Please do the needful. Thanks in advance. Regards Lokesh.M -- Forwarded message -- From: Lokesh Loki lokeshsmg2...@gmail.com Date: Sun, May 6, 2012 at 8:28 PM Subject: Need help on data To: excel-macros@googlegroups.com Hi Experts, Please find the attached excel sheet and i need user form for this team data. Here in the second sheet i have a data, i need user form in the first sheet. Regards Lokesh.M -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- David Grugeon -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4)
Re: $$Excel-Macros$$ Fwd: Need help on data
2012/5/9 Lokesh Loki lokeshsmg2...@gmail.com Hai Anil, Thanks for resolving the query and thanks for advising me about the user form. Once again thank a lot experts. Regards Lokesh.M On Wed, May 9, 2012 at 2:42 PM, Anil Gawli gawlianil8...@gmail.comwrote: Attached is the workbook and go to Calculation worksheet. On Wed, May 9, 2012 at 6:01 AM, David Grugeon da...@grugeon.com.auwrote: Hi Lokesh I do not think you will get a reply from this group to to your question as it is. What you are asking for is more in the nature of application design and that is not a quick and simple answer to a question. This group exists to help people who are having problems with VBA in Excel. Whilst you may need VBA to fill your form (which is not a 'user form' but a spreadsheet set up as an input form) the design of the form and the linking of that form to the relevant spreadsheet is something you will need to do. If your company does not have the relevant skills to do this they may need to hire a contractor to do it. To give you a start, I would be looking at using a unique identifier (Employee ID for example) to identify the row on sheet two that you want to use in sheet 1. Then I would probably use a macro to copy the data for one line from Sheet 2 to the form, add a button for OK when the changes were done and copy it back to Sheet 2. We can help you with the macros but the design of the Beautiful form is entirely up to you You will need to think about what information a user can enter to identify the relevant row of sheet 2. You will need to think about what operations you need to do create buttons for. I would think Edit (Load), Add, Delete, OK and Cancel at least. You will also need to specify all the validation rules for any cell which needs them. When you have done as much work as you can on the form and have identified the answers to all the questions come back to the group for more help with the VBA. On 9 May 2012 00:29, Lokesh Loki lokeshsmg2...@gmail.com wrote: Hi Experts, Still i am not receiving any results in the group, could you please help on us for the below query. I need a beautiful form, when i am selecting the name it contains all the data which is already there in sheet2. So based on i need a user form in sheet1. Please do the needful. Thanks in advance. Regards Lokesh.M -- Forwarded message -- From: Lokesh Loki lokeshsmg2...@gmail.com Date: Sun, May 6, 2012 at 8:28 PM Subject: Need help on data To: excel-macros@googlegroups.com Hi Experts, Please find the attached excel sheet and i need user form for this team data. Here in the second sheet i have a data, i need user form in the first sheet. Regards Lokesh.M -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- David Grugeon -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking
RE: $$Excel-Macros$$ Fwd: Need help on data
Hello Bé Trần, I believe that is what Lokesh meant (sheet1 = data entry form; sheet2 = database record storage) -- but I am replying just to provide the suggestion that you type your replies at the top of messages -- I often have difficulty finding your comments, since they are buried down below the old messages. Also, the mailing list automatically puts the rules for the group at the bottom of all messages, further obscuring the location of your message replies. I think more people will notice your comments if you put them at the top of your messages :) Wishing you a great day! Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Bé Tr?n Van Sent: Wednesday, May 09, 2012 8:40 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Fwd: Need help on data 2012/5/9 Lokesh Loki lokeshsmg2...@gmail.com Hai Anil, Thanks for resolving the query and thanks for advising me about the user form. Once again thank a lot experts. Regards Lokesh.M On Wed, May 9, 2012 at 2:42 PM, Anil Gawli gawlianil8...@gmail.com wrote: Attached is the workbook and go to Calculation worksheet. On Wed, May 9, 2012 at 6:01 AM, David Grugeon da...@grugeon.com.au wrote: Hi Lokesh I do not think you will get a reply from this group to to your question as it is. What you are asking for is more in the nature of application design and that is not a quick and simple answer to a question. This group exists to help people who are having problems with VBA in Excel. Whilst you may need VBA to fill your form (which is not a 'user form' but a spreadsheet set up as an input form) the design of the form and the linking of that form to the relevant spreadsheet is something you will need to do. If your company does not have the relevant skills to do this they may need to hire a contractor to do it. To give you a start, I would be looking at using a unique identifier (Employee ID for example) to identify the row on sheet two that you want to use in sheet 1. Then I would probably use a macro to copy the data for one line from Sheet 2 to the form, add a button for OK when the changes were done and copy it back to Sheet 2. We can help you with the macros but the design of the Beautiful form is entirely up to you You will need to think about what information a user can enter to identify the relevant row of sheet 2. You will need to think about what operations you need to do create buttons for. I would think Edit (Load), Add, Delete, OK and Cancel at least. You will also need to specify all the validation rules for any cell which needs them. When you have done as much work as you can on the form and have identified the answers to all the questions come back to the group for more help with the VBA. On 9 May 2012 00:29, Lokesh Loki lokeshsmg2...@gmail.com wrote: Hi Experts, Still i am not receiving any results in the group, could you please help on us for the below query. I need a beautiful form, when i am selecting the name it contains all the data which is already there in sheet2. So based on i need a user form in sheet1. Please do the needful. Thanks in advance. Regards Lokesh.M -- Forwarded message -- From: Lokesh Loki lokeshsmg2...@gmail.com Date: Sun, May 6, 2012 at 8:28 PM Subject: Need help on data To: excel-macros@googlegroups.com Hi Experts, Please find the attached excel sheet and i need user form for this team data. Here in the second sheet i have a data, i need user form in the first sheet. Regards Lokesh.M -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- David Grugeon -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion
RE: $$Excel-Macros$$ Fwd: Need help on data
Hello Lokesh, You may want to try Debra Dalgleish and Dave Petersen's method detailed here: http://contextures.com/exceldataentryupdateform.html Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Lokesh Loki Sent: Tuesday, May 08, 2012 7:30 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Fwd: Need help on data Hi Experts, Still i am not receiving any results in the group, could you please help on us for the below query. I need a beautiful form, when i am selecting the name it contains all the data which is already there in sheet2. So based on i need a user form in sheet1. Please do the needful. Thanks in advance. Regards Lokesh.M -- Forwarded message -- From: Lokesh Loki lokeshsmg2...@gmail.com Date: Sun, May 6, 2012 at 8:28 PM Subject: Need help on data To: excel-macros@googlegroups.com Hi Experts, Please find the attached excel sheet and i need user form for this team data. Here in the second sheet i have a data, i need user form in the first sheet. Regards Lokesh.M -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Fwd: Need help on data
Hi Lokesh I do not think you will get a reply from this group to to your question as it is. What you are asking for is more in the nature of application design and that is not a quick and simple answer to a question. This group exists to help people who are having problems with VBA in Excel. Whilst you may need VBA to fill your form (which is not a 'user form' but a spreadsheet set up as an input form) the design of the form and the linking of that form to the relevant spreadsheet is something you will need to do. If your company does not have the relevant skills to do this they may need to hire a contractor to do it. To give you a start, I would be looking at using a unique identifier (Employee ID for example) to identify the row on sheet two that you want to use in sheet 1. Then I would probably use a macro to copy the data for one line from Sheet 2 to the form, add a button for OK when the changes were done and copy it back to Sheet 2. We can help you with the macros but the design of the Beautiful form is entirely up to you You will need to think about what information a user can enter to identify the relevant row of sheet 2. You will need to think about what operations you need to do create buttons for. I would think Edit (Load), Add, Delete, OK and Cancel at least. You will also need to specify all the validation rules for any cell which needs them. When you have done as much work as you can on the form and have identified the answers to all the questions come back to the group for more help with the VBA. On 9 May 2012 00:29, Lokesh Loki lokeshsmg2...@gmail.com wrote: Hi Experts, Still i am not receiving any results in the group, could you please help on us for the below query. I need a beautiful form, when i am selecting the name it contains all the data which is already there in sheet2. So based on i need a user form in sheet1. Please do the needful. Thanks in advance. Regards Lokesh.M -- Forwarded message -- From: Lokesh Loki lokeshsmg2...@gmail.com Date: Sun, May 6, 2012 at 8:28 PM Subject: Need help on data To: excel-macros@googlegroups.com Hi Experts, Please find the attached excel sheet and i need user form for this team data. Here in the second sheet i have a data, i need user form in the first sheet. Regards Lokesh.M -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- David Grugeon -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Fwd: Need help in building pivot using vba
Sorry for the late reply, Rajan could you explain your code for pivot table? where can i find / download the BU list.xlsx? 2012/1/23 rekha siri rekha.siri2...@gmail.com Rajan i could able to find out the root cause. i deleted sub delete module below and call delete function line now its working fine Thanks, Rekha On Sun, Jan 22, 2012 at 11:10 PM, rekha siri rekha.siri2...@gmail.comwrote: rajan i dint remove summary sheet and raw data sheet but still its not executing. only rest of sheets were deleted bt its opening bu list and stopping there On Sun, Jan 22, 2012 at 6:10 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Hi rekha. I clearly mention that don’t delete the summarySheet.. Rajan. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *rekha siri *Sent:* Jan/Sun/2012 04:47 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Fwd: Need help in building pivot using vba ** ** Rajan, ** ** i Tried removing the sheets and tried executing this macro bt it is not executing. ** ** Please fix this... ** ** Thanks alot for your help in this concern. On Sun, Jan 22, 2012 at 3:13 PM, Rajan_Verma rajanverma1...@gmail.com wrote: Hi Rekha See the attached sheet.. Don’t delete SUmmarySheet *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *rekha siri *Sent:* Jan/Sat/2012 08:51 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Fwd: Need help in building pivot using vba** ** can any one kindly help on this please. -- Forwarded message -- From: *rekha siri* rekha.siri2...@gmail.com Date: Wed, Jan 18, 2012 at 9:59 PM Subject: Need help in building pivot using vba To: excel-macros@googlegroups.com hi experts, Please provide the code to build pivot using vba this macro is provided to me in past by rajan really thank full for the concern. adding to that i need to prepare pivot for west bu from attached macro raw data sheet. pivot format is also attached it should be as per West december2011 file's pivot manner. attached are macro and west december workbooks which contain pivot ..*** * kindly help in this concern thanks. Rekha -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com ** ** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss
Re: $$Excel-Macros$$ Fwd: Need help in building pivot using vba
Rajan, i Tried removing the sheets and tried executing this macro bt it is not executing. Please fix this... Thanks alot for your help in this concern. On Sun, Jan 22, 2012 at 3:13 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Hi Rekha See the attached sheet.. Don’t delete SUmmarySheet ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *rekha siri *Sent:* Jan/Sat/2012 08:51 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Fwd: Need help in building pivot using vba ** ** can any one kindly help on this please. -- Forwarded message -- From: *rekha siri* rekha.siri2...@gmail.com Date: Wed, Jan 18, 2012 at 9:59 PM Subject: Need help in building pivot using vba To: excel-macros@googlegroups.com hi experts, ** ** Please provide the code to build pivot using vba ** ** this macro is provided to me in past by rajan really thank full for the concern. ** ** adding to that i need to prepare pivot for west bu from attached macro raw data sheet. ** ** pivot format is also attached it should be as per West december2011 file's pivot manner. ** ** attached are macro and west december workbooks which contain pivot .. ** ** ** ** ** ** kindly help in this concern thanks. ** ** Rekha ** ** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ Fwd: Need help in building pivot using vba
Hi rekha. I clearly mention that don't delete the summarySheet.. Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of rekha siri Sent: Jan/Sun/2012 04:47 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Fwd: Need help in building pivot using vba Rajan, i Tried removing the sheets and tried executing this macro bt it is not executing. Please fix this... Thanks alot for your help in this concern. On Sun, Jan 22, 2012 at 3:13 PM, Rajan_Verma rajanverma1...@gmail.com wrote: Hi Rekha See the attached sheet.. Don't delete SUmmarySheet From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of rekha siri Sent: Jan/Sat/2012 08:51 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Fwd: Need help in building pivot using vba can any one kindly help on this please. -- Forwarded message -- From: rekha siri rekha.siri2...@gmail.com Date: Wed, Jan 18, 2012 at 9:59 PM Subject: Need help in building pivot using vba To: excel-macros@googlegroups.com hi experts, Please provide the code to build pivot using vba this macro is provided to me in past by rajan really thank full for the concern. adding to that i need to prepare pivot for west bu from attached macro raw data sheet. pivot format is also attached it should be as per West december2011 file's pivot manner. attached are macro and west december workbooks which contain pivot .. kindly help in this concern thanks. Rekha -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros
Re: $$Excel-Macros$$ Fwd: Need help in building pivot using vba
rajan i dint remove summary sheet and raw data sheet but still its not executing. only rest of sheets were deleted bt its opening bu list and stopping there On Sun, Jan 22, 2012 at 6:10 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Hi rekha. I clearly mention that don’t delete the summarySheet.. Rajan. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *rekha siri *Sent:* Jan/Sun/2012 04:47 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Fwd: Need help in building pivot using vba ** ** Rajan, ** ** i Tried removing the sheets and tried executing this macro bt it is not executing. ** ** Please fix this... ** ** Thanks alot for your help in this concern. On Sun, Jan 22, 2012 at 3:13 PM, Rajan_Verma rajanverma1...@gmail.com wrote: Hi Rekha See the attached sheet.. Don’t delete SUmmarySheet *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *rekha siri *Sent:* Jan/Sat/2012 08:51 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Fwd: Need help in building pivot using vba can any one kindly help on this please. -- Forwarded message -- From: *rekha siri* rekha.siri2...@gmail.com Date: Wed, Jan 18, 2012 at 9:59 PM Subject: Need help in building pivot using vba To: excel-macros@googlegroups.com hi experts, Please provide the code to build pivot using vba this macro is provided to me in past by rajan really thank full for the concern. adding to that i need to prepare pivot for west bu from attached macro raw data sheet. pivot format is also attached it should be as per West december2011 file's pivot manner. attached are macro and west december workbooks which contain pivot .. kindly help in this concern thanks. Rekha -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com ** ** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't
Re: $$Excel-Macros$$ Fwd: Need help in building pivot using vba
Rajan i could able to find out the root cause. i deleted sub delete module below and call delete function line now its working fine Thanks, Rekha On Sun, Jan 22, 2012 at 11:10 PM, rekha siri rekha.siri2...@gmail.comwrote: rajan i dint remove summary sheet and raw data sheet but still its not executing. only rest of sheets were deleted bt its opening bu list and stopping there On Sun, Jan 22, 2012 at 6:10 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Hi rekha. I clearly mention that don’t delete the summarySheet.. Rajan. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *rekha siri *Sent:* Jan/Sun/2012 04:47 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Fwd: Need help in building pivot using vba ** ** Rajan, ** ** i Tried removing the sheets and tried executing this macro bt it is not executing. ** ** Please fix this... ** ** Thanks alot for your help in this concern. On Sun, Jan 22, 2012 at 3:13 PM, Rajan_Verma rajanverma1...@gmail.com wrote: Hi Rekha See the attached sheet.. Don’t delete SUmmarySheet *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *rekha siri *Sent:* Jan/Sat/2012 08:51 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Fwd: Need help in building pivot using vba*** * can any one kindly help on this please. -- Forwarded message -- From: *rekha siri* rekha.siri2...@gmail.com Date: Wed, Jan 18, 2012 at 9:59 PM Subject: Need help in building pivot using vba To: excel-macros@googlegroups.com hi experts, Please provide the code to build pivot using vba this macro is provided to me in past by rajan really thank full for the concern. adding to that i need to prepare pivot for west bu from attached macro raw data sheet. pivot format is also attached it should be as per West december2011 file's pivot manner. attached are macro and west december workbooks which contain pivot .. kindly help in this concern thanks. Rekha -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com ** ** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles
Re: $$Excel-Macros$$ Fwd: Need Help
Thanks alot Daniel On Mon, Apr 4, 2011 at 2:38 PM, Daniel dcolarde...@free.fr wrote: Hi, Paste this macro in the first workbook. Open it manually and run the “Test” macro. Sub test() Dim lgRow As Long, sh As Worksheet, c As Range, rg As Range Const strPath As String = D:\Donnees\Daniel\mpfe\Prathima R\ 'to be modified Dim inCalculationMode As Integer Application.ScreenUpdating = False inCalculationMode = Application.Calculation Application.Calculation = xlCalculationManual Set sh = Sheets(Data) lgRow = [Data!B65536].End(xlUp).Row + 1 Workbooks.Open strPath _ Supplier_Maintenance_170_Data_without_SAP_Document_Number.xls With Sheets(Data) .Range(.[Q3], .Cells(65536, 2).End(xlUp)).Copy sh.Cells(lgRow, 2) End With ActiveWorkbook.Close False With sh .Range(T1).EntireColumn.Insert .Range(T2).Value = Region .Range(T1).EntireColumn.WrapText = True End With 'Global Company Code List (3).xls Workbooks.Open strPath _ Global Company Code List (3).xls Set sh1 = Sheets(Markets_Comp Code) With sh1 Set rg = .Range(.[A2], .[C65536].End(xlUp)) For Each c In sh.Range(sh.[S3], sh.[S65536].End(xlUp)).Offset(, 1) c.Value = Application.VLookup(c.Offset(, -1) * 1, rg, 3, 0) Next c End With ActiveWorkbook.Close False Application.Calculation = inCalculationMode Application.ScreenUpdating = True End Sub Regards. Daniel *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] *De la part d**e* Prathima R *Envoyé :* lundi 4 avril 2011 13:16 *À :* excel-macros@googlegroups.com; ayush jain; ashish koul *Objet :* $$Excel-Macros$$ Fwd: Need Help Hi experts, I am not good at excel vba, i just tried recording macro but i am unsuccessful.. please help me i have two excel work books 1) SM_MV170R_Q0001_170_Data_with_SAP_Doc_Number 2) Supplier_Maintenance_170_Data_without_SAP_Document_Number i will first open the SM_MV170R_Q0001_170_Data_with_SAP_Doc_Number and go to end of the blank row then open the second work book Supplier_Maintenance_170_Data_without_SAP_Document_Number copy the entire data and paste it in first work book which is SM_MV170R_Q0001_170_Data_with_SAP_Doc_Number Then insert one column and name the column as Region after the company code format the excel sheet using wrap text and grid lines. Then using the company code will be pulling the Region name from Global Company Code List with help of Vlookup. Please help me in preparing the macro Thanks alot in advance. Regards, Prathima -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Fwd: need help
sorry ashish, the file is not working when i click on update it opens a pop up says read only, notify cancel... Regards, On Tue, Jan 18, 2011 at 8:56 PM, ashish koul koul.ash...@gmail.com wrote: check the attachment On Tue, Jan 18, 2011 at 12:20 PM, lucky singh lucky60...@gmail.comwrote: Hello, Guys Need your help urgently please Regrads -- Forwarded message -- From: lucky singh lucky60...@gmail.com Date: Tue, Jan 18, 2011 at 10:51 AM Subject: need help To: excel-macros@googlegroups.com Hi Guys need your help, I have 25 agenst overall I have to record listen to 12 calls per agent, While rating a call i'll put scores in sheet one automatically it should get updated in sheet 3 i.e. summary sheet all the scores shuld get accumulated... Thanx in advance Regards, Lucky -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Fwd: need help
check the attachment see if it helps On Sat, Jan 8, 2011 at 11:12 AM, Rajasekhar Praharaju rajasekhar.prahar...@gmail.com wrote: Please find the attached sheet i could able to build formula for single line item But i want if the criteria is having mulitple line items the results should display as Date description, Date description, Date description. Please help me in this concern, Thanks, Raj On Sat, Jan 8, 2011 at 10:49 AM, Rajasekhar Praharaju rajasekhar.prahar...@gmail.com wrote: Hi , Please help me in this concern, In this sheet i am trying to place vlookup for multiple fields yaar it should through the description and date in AG column basing on list of activities. but i should get this in horizontal basis.. can anyone plz help me in this concern. for example if one activity is performed twice which is shown on top left hand corner. IRS Publications activity has two line items then it should come as against the J102 which is IRS Publications it should through up the description and date in this manner pdf28 Monday, January 03, 2011,pdf24 Monday, January 03, 2011 -- -Thanks, Raj -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts query_with_formula(1).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Fwd: need help
Thanks alot ashish its excellent.. On Sat, Jan 8, 2011 at 3:10 PM, ashish koul koul.ash...@gmail.com wrote: check the attachment see if it helps On Sat, Jan 8, 2011 at 11:12 AM, Rajasekhar Praharaju rajasekhar.prahar...@gmail.com wrote: Please find the attached sheet i could able to build formula for single line item But i want if the criteria is having mulitple line items the results should display as Date description, Date description, Date description. Please help me in this concern, Thanks, Raj On Sat, Jan 8, 2011 at 10:49 AM, Rajasekhar Praharaju rajasekhar.prahar...@gmail.com wrote: Hi , Please help me in this concern, In this sheet i am trying to place vlookup for multiple fields yaar it should through the description and date in AG column basing on list of activities. but i should get this in horizontal basis.. can anyone plz help me in this concern. for example if one activity is performed twice which is shown on top left hand corner. IRS Publications activity has two line items then it should come as against the J102 which is IRS Publications it should through up the description and date in this manner pdf28 Monday, January 03, 2011,pdf24 Monday, January 03, 2011 -- -Thanks, Raj -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Fwd: need help
Please find the attached sheet i could able to build formula for single line item But i want if the criteria is having mulitple line items the results should display as Date description, Date description, Date description. Please help me in this concern, Thanks, Raj On Sat, Jan 8, 2011 at 10:49 AM, Rajasekhar Praharaju rajasekhar.prahar...@gmail.com wrote: Hi , Please help me in this concern, In this sheet i am trying to place vlookup for multiple fields yaar it should through the description and date in AG column basing on list of activities. but i should get this in horizontal basis.. can anyone plz help me in this concern. for example if one activity is performed twice which is shown on top left hand corner. IRS Publications activity has two line items then it should come as against the J102 which is IRS Publications it should through up the description and date in this manner pdf28 Monday, January 03, 2011,pdf24 Monday, January 03, 2011 -- -Thanks, Raj -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts query with formula.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet