Re: $$Excel-Macros$$ Event - Worksheet Change
solved your query now --- On Mon, 11/19/12, Raj Mahapatra rajexcelma...@gmail.com wrote: From: Raj Mahapatra rajexcelma...@gmail.com Subject: $$Excel-Macros$$ Event - Worksheet Change To: excel-macros@googlegroups.com Date: Monday, November 19, 2012, 11:15 PM Dear Friends, kindly help out on below macro, i am not able to get output. I Wants to auto change Cell color Range F13 to Blue when Range F11 is as 1 City and cell color Range F13 to Yellow when range F11 is as 2 City. I have also attached xls for your reference. Private Sub Worksheet_Change(ByVal Target As Excel.Range) Set Target = Range(F11) If Target.Value = 1 City Then Range(F13).Interior.ColorIndex = 5ElseIf Target.Value = 2 City Then Range(F13).Interior.ColorIndex = 6 End If End Sub -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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. Visit this group at http://groups.google.com/group/excel-macros?hl=en. Event_worksheet change.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ Request Macro for Merge Text file
Dear All, Please find below is my request to create excel macro. I have a list of files in local directory and file list located in A column and need to merge text file based on the B column listed files. A1---B1 C:\1.txt --- C:\Merge\1.txt C:\2.txt --- C:\3.txt --- C:\4.txt --- C:\Merge\4.txt C:\5.txt --- C:\6.txt --- C:\7.txt --- C:\8.txt --- C:\9.txt --- C:\Merge\9.txt C:\10.txt --- Result: C:\Merge\ 1.txt + Here 1.txt, 2.txt and 3.txt combined and named in 1.txt 4.txt 9.txt Kindly help us to get solution for my request. Thanks Regards Ganesh -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ VBA vlookup issue
when i use C:\test\[WSO_Record.xls]Record, the script can run propriety, but if change to network pathThisWorkbook.Path \[WSO_Record.xls]Record, i will get error 1004, what is the error in my script? Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 2 And Target.Row 2 And Not IsEmpty(Target) Then Cells(Target.Row, 4) = =VLOOKUP( Target.Address ,' ThisWorkbook.Path \[WSO_Record.xls]Record'!$A:$H,3,0) End If If IsEmpty(Target) Then Range(Cells(Target.Row, 2), Cells(Target.Row, 8)).Clear End If End Sub -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ VBA vlookup issue
Dear teow, can u share a workbook with us?? Regards, Gawli Anil On Wed, Nov 21, 2012 at 4:34 PM, Teow teow...@gmail.com wrote: when i use C:\test\[WSO_Record.xls]Record, the script can run propriety, but if change to network pathThisWorkbook.Path \[WSO_Record.xls]Record, i will get error 1004, what is the error in my script? Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 2 And Target.Row 2 And Not IsEmpty(Target) Then Cells(Target.Row, 4) = =VLOOKUP( Target.Address ,' ThisWorkbook.Path \[WSO_Record.xls]Record'!$A:$H,3,0) End If If IsEmpty(Target) Then Range(Cells(Target.Row, 2), Cells(Target.Row, 8)).Clear End If End Sub -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Re: VBA vlookup issue
Hi Teow, Can you ple share your Both WorkBook eg. WSO_Record.xls and the one inwhich ur writing formula. Regards Prince On Wednesday, November 21, 2012 4:34:54 PM UTC+5:30, Teow wrote: when i use C:\test\[WSO_Record.xls]Record, the script can run propriety, but if change to network pathThisWorkbook.Path \[WSO_Record.xls]Record, i will get error 1004, what is the error in my script? Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 2 And Target.Row 2 And Not IsEmpty(Target) Then Cells(Target.Row, 4) = =VLOOKUP( Target.Address ,' ThisWorkbook.Path \[WSO_Record.xls]Record'!$A:$H,3,0) End If If IsEmpty(Target) Then Range(Cells(Target.Row, 2), Cells(Target.Row, 8)).Clear End If End Sub -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: Mandatory Field
Thanks prince and Natron On Tue, Nov 20, 2012 at 9:37 PM, Prince prince141...@gmail.com wrote: Hi Shrini, I think without macro it is not possible to do as formulas can not control objects and a workbook is an object. But you can do one thing by using conditional formatting you can intimate user to fill the cell B1 if there is any value into cell A1. Regards Prince. On Monday, November 19, 2012 11:12:23 AM UTC+5:30, shrini wrote: Dear All Please help me for following problem. I want to make a Cell B1 mandatory based on Cell A1. Means if there is any value in Cell A1 then Cell B1 can not empty there should be some value . Eg. In Cell A1 I will Enter Name of te person then Age should compulsary enter in cell B1 System should not allow me to close the file without entering the age in Cell B1 is it possible without macro? Thanks in advance -- Shrini -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Shrini -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Please help - How to export specific range by ID to other excel file.
Glad it worked for you. On Tuesday, November 20, 2012 1:29:45 PM UTC-5, Mangesh wrote: Thank you so much Natron. You have made my work very easy. Thanks again. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: Please help - How to export specific range by ID to other excel file.
My apologies Anoop, I hope you can understand my code, I tried to comment it at key locations. I attached a workbook the second go around. On Tuesday, November 20, 2012 9:38:32 PM UTC-5, Enrique Martin wrote: It's better to attach the file and put you query there. No one gonna study this code as different people have different logic. Regards, Anoop -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Dynamic calendar quiz : There is a prize for the winner. *
SUBMITTED On Mon, Nov 19, 2012 at 12:32 PM, Deba Ranjan drdeva...@gmail.com wrote: [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (drdeva...@gmail.com) Add cleanup rulehttps://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DEKHSAhYSpVdqIvgzo%252Bejh8UJ1Z0bGRO147r3YAntH6v4pwyVQpiL5LwUiPiqQiOaxSof0YmX7%252FQDZi6WUbPTsLaL7JsMDorRfgtPweNrFxMfJe0CRRhuhu1EZt7HGQ7oGa9Tjuyw42Q%253D%26key%3DKd92UajgVSfypTKPMQSo8RftiiII3wDaJutbc5d4PGk%253Dtc=12933389615_1611928100| More infohttp://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=12933389615_1611928100 Done !! Regards, Debaranjan Thanks Regards, *Deba ranjan* On Sun, Nov 18, 2012 at 9:53 PM, Ayush Jain jainayus...@gmail.com wrote: Dear members, Let's get set for the new year 2013 Here is inviting you to participate in a quiz to make calendar for the new year in excel. There are some rules to be followed : 1) No macros to be used and should be formula based, only xlsx file to be submitted. 2) The calendar should be dynamic for any year, if you change the year , the calendar should update automatically. 3) The calendar should be in one sheet only 4) The leap year should be considered. 5) Last date to submit the calendar is 2nd December 2012 6) Make sure you create calendar yourself and do not download from anywhere 7) Send your calendar to my email id - jainayush85[at]gmail.com. If you post in the forum, there are chances people take reference from your calendar. 8) Once you send the calendar, you can reply to this post for the confirmation. The following will add points to your calendar : 1) Highlight current date 2) Highlight bank/public holidays 3) Calendar formatting and user friendliness There is a prize for the best calendar and recognition for the runner up. Sponsors for the prize are invited, you can contact me if you want to be sponsor. Looking forward to your active participation in the quiz. Let me know if you have any queries. Many thanks for your contribution to this group. Keep it up Regards Ayush Jain Group Manager -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received
Re: $$Excel-Macros$$ dear experts is there any solution for pick the step value in certain table
Hi! jeet singh, Thanks i am expecting this only thanks a lot On Wednesday, 21 November 2012 11:20:48 UTC+5:30, jeet singh wrote: PFA On Tue, Nov 20, 2012 at 10:20 PM, renuka chari jva@gmail.comjavascript: wrote: hi Excel beginner, i don't know your name? but you gave me a wonderful solution thanks allot. but is there any easy formula for that.. this mega formula usage in my sheet every time is difficult for me... is there any alternate solution for that... i mean that make it simple. but any way thanks allot..:) Hi Paul, thanks for speed response. i am expecting this only... On Tuesday, 20 November 2012 01:15:43 UTC+5:30, Excel Beginner wrote: Hi Renu, please find the attachment. -- *Regards,* * * *Excel Beginner* * * On Mon, Nov 19, 2012 at 10:35 PM, Renukachari Kasee jva@gmail.comwrote: Dear experts, is there any solution for pick the step value in certain table? please see above attached workbook here i need formula for pick the value thanks -- Join official Facebook page of this forum @ https://www.facebook.com/** discussexcel https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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-...@googlegroups.com. To unsubscribe from this group, send email to excel-macros...@** googlegroups.com. Visit this group at http://groups.google.com/**group/excel-macros?hl=enhttp://groups.google.com/group/excel-macros?hl=en . -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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-...@googlegroups.comjavascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Duplicate line based on column
Hi Viswanathan, Pls find the attachment. -- *Regards,* * * *Excel Beginner* * * On Wed, Nov 21, 2012 at 2:43 AM, Viswanathan Yoganathan viswanathan.yoganat...@asia.xchanging.com wrote: HI, ** ** In the attached excel, I need to remove the duplicate lines based on the “Column E”. ** ** Example: ** ** The first line and the second line have same value in the “Column E”. The first line should remain same and second line should be deleted, no matter what the other cell value has in the same line. ** ** Thanks, Vishwa. ** ** ** ** CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also be privileged. If you are not the intended recipient of this e-mail you may not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you are not the intended recipient please telephone or e-mail the sender and delete this message and any attachment from your system. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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. Visit this group at http://groups.google.com/group/excel-macros?hl=en. Book3 (Solved).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ dear experts is there any solution for pick the step value in certain table
Hi Renu, Please find the attachment. -- *Regards,* * * *Excel Beginner* * * On Tue, Nov 20, 2012 at 10:20 PM, renuka chari jva.ch...@gmail.com wrote: hi Excel beginner, i don't know your name? but you gave me a wonderful solution thanks allot. but is there any easy formula for that.. this mega formula usage in my sheet every time is difficult for me... is there any alternate solution for that... i mean that make it simple. but any way thanks allot..:) Hi Paul, thanks for speed response. i am expecting this only... On Tuesday, 20 November 2012 01:15:43 UTC+5:30, Excel Beginner wrote: Hi Renu, please find the attachment. -- *Regards,* * * *Excel Beginner* * * On Mon, Nov 19, 2012 at 10:35 PM, Renukachari Kasee jva@gmail.comwrote: Dear experts, is there any solution for pick the step value in certain table? please see above attached workbook here i need formula for pick the value thanks -- Join official Facebook page of this forum @ https://www.facebook.com/** discussexcel https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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-...@googlegroups.com. To unsubscribe from this group, send email to excel-macros...@** googlegroups.com. Visit this group at http://groups.google.com/**group/excel-macros?hl=enhttp://groups.google.com/group/excel-macros?hl=en . -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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. Visit this group at http://groups.google.com/group/excel-macros?hl=en. All1(Alternate).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Re: VBA vlookup issue
thx your reply, here is the excel file, is use Publish.xlsm connect WSO_Record.xls -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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. Visit this group at http://groups.google.com/group/excel-macros?hl=en. test.rar Description: application/rar
$$Excel-Macros$$ Re: VBA vlookup issue
both files is under same server, but if i want set give a path value in Publish.xlsm, in worksheet Data_Set, C2 is path and D2 is target file and sheet name to connect the blue color script if i add will solve the issue? C2 = \\Server\Plan Delivery D2 = [WSO_Record]Record Private Sub Workbook_Open() Dim strNowPath As String Dim strFileName As String 'Dim strFileExt As String Dim strPath As String strNowPath = ThisWorkbook.Worksheets(Data_Register).Range(C2) strFileName = ThisWorkbook.Worksheets(Data_Register).Range(D2) 'strFileExt = *.xls If Trim(strNowPath) = Then strNowPath = ThisWorkbook.Path End If If Right(strNowPath, 1) = \ Then strPath = Dir(strNowPath \ strFileName, vbDirectory) Else strPath = Dir(strNowPath \ strFileName \, vbDirectory) End If End Sub Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 2 And Target.Row 2 And Not IsEmpty(Target) Then Cells(Target.Row, 4) = =VLOOKUP( Target.Address ,' strPath '!$A:$H,3,0) End If If IsEmpty(Target) Then Range(Cells(Target.Row, 2), Cells(Target.Row, 8)).Clear End If End Sub now is strPath = empty value, why? -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Re: dear experts is there any solution for pick the step value in certain table
Hi Renuka, Please find one more solution from my side : =INDIRECT(CHAR(65+ROW(A1))ROW(B3)-1) Regards Prince On Monday, November 19, 2012 10:35:49 PM UTC+5:30, renuka chari wrote: Dear experts, is there any solution for pick the step value in certain table? please see above attached workbook here i need formula for pick the value thanks -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Re: VBA vlookup issue
Both files in same server, but I wish can add the path but use a cell value in worksheet Data_Set on the Publish.xlsm file Below blue color script is a new add modify, but still come out error 1004 C2 = \\Server\Plan Delivery D2 = [WSO_Record]Record Private Sub Worksheet_Change(ByVal Target As Range) Dim strNowPath As String Dim strFileName As String 'Dim strFileExt As String Dim strPath As String strNowPath = ThisWorkbook.Worksheets(Data_Register).Range(B2) strFileName = ThisWorkbook.Worksheets(Data_Register).Range(C2) 'strFileExt = *.xls If Trim(strNowPath) = Then strNowPath = ThisWorkbook.Path End If If Right(strNowPath, 1) = \ Then strPath = strNowPath strFileName Else strPath = strNowPath strFileName \ End If If Target.Column = 2 And Target.Row 2 And Not IsEmpty(Target) Then 'On Error Resume Next Cells(Target.Row, 4) = =VLOOKUP( Target.Address ,' strPath '!$A:$H,3,0) End If If IsEmpty(Target) Then Range(Cells(Target.Row, 2), Cells(Target.Row, 8)).Clear End If End Sub But I don't know why pop up open windows ask me open the excel file for update source? -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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. Visit this group at http://groups.google.com/group/excel-macros?hl=en. test2.rar Description: application/rar
Re: $$Excel-Macros$$ Lookup
Hi all.. i have a doubt in excel qt General: Ex: in one folder its have five(5) different work book are there like a',b,c,d,e and each work it has 3 sheets same data . how to get page setup in all work book at the same thanking you -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
