$$Excel-Macros$$ Macro for data indexing
Dear friends, I attached a sheet it has a data set A I need to convert data into data set B for cleaning (value is comma separated) after cleaning and unique i have to put that data into same format as data set A i.e. comma separated on appropriate serial number i have a huge data set to clean i know it is best possible with the macro Kindly help me out to complete this and to learn Regards, Deepak -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Book1.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ All text box need to be enter
Dear Team, I am creating one tool in user form, it contains 3 textboxes, need help on fallowing If textbox3 fill with information then check for textbox4, if filled with information then check for textbox5. If all textbox 3, 4 5 are filled with information then go to remaining process. If any of 1 from these textbox is empty then prompt with the msgbox(“textbox (name)”). -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
RE: $$Excel-Macros$$ VBA Code to Import Excel table in Word file
Try this file -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Wednesday, April 02, 2014 12:22 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravinder Actually it show like Missing: Microsoft Word 14.0 Object Library Attached screen shot here Regards Amar On Wed, Apr 2, 2014 at 12:09 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Press alt + F11 then go in tools then reference select Microsoft Word 14.0 Object Library library number can b 12.0 or else. Please see attached excel file. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Wednesday, April 02, 2014 10:50 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravinder Thanks for reply but how to do it.Pls give me guidance or give modified code. Regards Amar On Tue, Apr 1, 2014 at 9:31 PM, ravinder negi ravindervbacli...@gmail.com wrote: have u added the library word object library in vba On Mon, Mar 31, 2014 at 10:02 PM, amar takale amartak...@gmail.com wrote: Dear Ravinder VBA Code not working.Attached Error Screen shot here.Pls see guide me.I have no knowledge of VBA. In excel there are no show Microsoft Word library in Tools-reference option but show it as Microsoft Word 11.0 Object library Pls look in this issue. Regards Amar On Mon, Mar 31, 2014 at 5:39 PM, Ravinder ravindervbacli...@gmail.com wrote: Note:- add word library Microsoft Word library This is simply copy and paste value from excel to word and you need to select range (will be asked by program) which you want to transfer in word Sub Button1_Click() Dim wrd As New Word.Application Dim doc As Word.Document Dim RNG As Range Set RNG = Application.InputBox(Please Select Range to Transfer in Word:, Type:=8) Set doc = wrd.documents.Add wrd.Visible = True 'if you dont want to show wrd application then just use false instead of true RNG.Copy wrd.Selection.Paste Set tbl = doc.Tables(1) doc.SaveAs2 ThisWorkbook.Path \ ActiveSheet.Name .doc 'change save as path as per ur requirement End Sub -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, March 31, 2014 3:35 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ashish Sir, I learned many VBA work from your Code which is a lot of time saving easy to do. Before one week on our excel forum one topic discussed as (Macro to Import Word Tables to Excel from a folder). I got code from word to excel but I required excel to word.I use excel 2003. Can you share code excel to word table as proper in one sheet with respective sheet name. I would appreciate very much if you can help me on this. Regards -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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
Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file
Dear Ravinder Perfect,You are done it. I am really thankful for its wonderful coding. I have some other query regarding this issue topic (If you have sufficient time regarding my query) Single Excel sheet more than 2 tables 1) I will create button click then automatic table copy paste in word.(First data range fixed of table).there are more than two table with different range.I want all table copy paste in one word file one by one below after one click button. Single Excel sheet one table 1) I will create button click then automatic table copy paste in word.(First data range fixed of table).code not asking for select range. As always Thank you all for your help. I greatly appreciated it. Regards Amar On Wed, Apr 2, 2014 at 12:31 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Try this file -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Wednesday, April 02, 2014 12:22 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravinder Actually it show like Missing: Microsoft Word 14.0 Object Library Attached screen shot here Regards Amar On Wed, Apr 2, 2014 at 12:09 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Press alt + F11 then go in tools then reference select Microsoft Word 14.0 Object Library library number can b 12.0 or else. Please see attached excel file. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Wednesday, April 02, 2014 10:50 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravinder Thanks for reply but how to do it.Pls give me guidance or give modified code. Regards Amar On Tue, Apr 1, 2014 at 9:31 PM, ravinder negi ravindervbacli...@gmail.com wrote: have u added the library word object library in vba On Mon, Mar 31, 2014 at 10:02 PM, amar takale amartak...@gmail.com wrote: Dear Ravinder VBA Code not working.Attached Error Screen shot here.Pls see guide me.I have no knowledge of VBA. In excel there are no show Microsoft Word library in Tools-reference option but show it as Microsoft Word 11.0 Object library Pls look in this issue. Regards Amar On Mon, Mar 31, 2014 at 5:39 PM, Ravinder ravindervbacli...@gmail.com wrote: Note:- add word library Microsoft Word library This is simply copy and paste value from excel to word and you need to select range (will be asked by program) which you want to transfer in word Sub Button1_Click() Dim wrd As New Word.Application Dim doc As Word.Document Dim RNG As Range Set RNG = Application.InputBox(Please Select Range to Transfer in Word:, Type:=8) Set doc = wrd.documents.Add wrd.Visible = True 'if you dont want to show wrd application then just use false instead of true RNG.Copy wrd.Selection.Paste Set tbl = doc.Tables(1) doc.SaveAs2 ThisWorkbook.Path \ ActiveSheet.Name .doc 'change save as path as per ur requirement End Sub -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, March 31, 2014 3:35 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ashish Sir, I learned many VBA work from your Code which is a lot of time saving easy to do. Before one week on our excel forum one topic discussed as (Macro to Import Word Tables to Excel from a folder). I got code from word to excel but I required excel to word.I use excel 2003. Can you share code excel to word table as proper in one sheet with respective sheet name. I would appreciate very much if you can help me on this. Regards -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to
RE: $$Excel-Macros$$ Macro for data indexing
pfa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Deepak Rawat Sent: Wednesday, April 02, 2014 11:51 AM To: excel-macros Subject: $$Excel-Macros$$ Macro for data indexing Dear friends, I attached a sheet it has a data set A I need to convert data into data set B for cleaning (value is comma separated) after cleaning and unique i have to put that data into same format as data set A i.e. comma separated on appropriate serial number i have a huge data set to clean i know it is best possible with the macro Kindly help me out to complete this and to learn Regards, Deepak -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. buyer list.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
RE: $$Excel-Macros$$ Need macro for repetative formatting
Provid any data and your 10 steps which u want to do after download data from software From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Suyog Kulkarni Sent: Tuesday, April 01, 2014 7:18 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need macro for repetative formatting Hello All, Pl advice on mail below. Am I asking something very difficult ? If anybody can help that can save my lots of time. Pl do the needful. Regards, Suyog On Tuesday, 25 March 2014 11:59:37 UTC+5:30, Suyog Kulkarni wrote: Hello Vicky, I'm not at all coping data from any where otherwise I would have used the paste special. I'm pulling data from software which some times finish within 10 rows 10 columns sometimes it's cross 30 columns 100 plus rows. If somehow I want to tell excel that follow my 10 steps upto last row last column which is having text. It may be row 10 column 10 or row 85 or column 60 or anything. Sometimes it's come so hectic to just waste time on formatting only. Pl help solve this problem. With Regards, Suyog On Tuesday, 25 March 2014 01:49:38 UTC+5:30, Vicky wrote: Hi Suyog, My understanding is you would like to have same format for all data so my logic is rather formating each line of data I have saved your format in Format tab in attached sheet and then that format will be applied to your copied data in Original Sheet. Same as we do in Excel using Paste special + Paste+Formats. Hope this makes sense. Regards, On Mon, Mar 24, 2014 at 7:29 PM, Suyog Kulkarni nash...@gmail.com wrote: Hello All, Greetings for the day. Pl refer attached excel, I'm using one database software when I pull out different reports from that I need to do 10 steps for each report every time. I've tried to record macro also but I don't know how to find out last cell which contains text sometimes report may finish in F column 30th row or sometimes it cross P column 150th row. Refer attached excel, I've added my steps, sample of original report sample of expected report. If I got answer of this, this will increase my productivity can save lots of time. With Regards, Suyog -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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,
$$Excel-Macros$$ Re: All text box need to be enter
Dear Team, Forget to attached excel sheet. Please help on this Regards, Rameshwari :) On Wednesday, April 2, 2014 10:26:11 AM UTC+4, Rameshwari wrote: Dear Team, I am creating one tool in user form, it contains 3 textboxes, need help on fallowing If textbox3 fill with information then check for textbox4, if filled with information then check for textbox5. If all textbox 3, 4 5 are filled with information then go to remaining process. If any of 1 from these textbox is empty then prompt with the msgbox(“textbox (name)”). -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Book1.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Re: All text box need to be enter
Hi Rameshwari, Please find the attached file. Regards, Ganesh N On Wed, Apr 2, 2014 at 3:41 PM, Rameshwari rameshwarish...@gmail.comwrote: Dear Team, Forget to attached excel sheet. Please help on this Regards, Rameshwari :) On Wednesday, April 2, 2014 10:26:11 AM UTC+4, Rameshwari wrote: Dear Team, I am creating one tool in user form, it contains 3 textboxes, need help on fallowing If textbox3 fill with information then check for textbox4, if filled with information then check for textbox5. If all textbox 3, 4 5 are filled with information then go to remaining process. If any of 1 from these textbox is empty then prompt with the msgbox(textbox (name)). -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Book1.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Macro for data indexing
hi thanx for your reply but its not working correctly On Wed, Apr 2, 2014 at 2:42 PM, Ravinder ravinderexcelgr...@gmail.comwrote: pfa *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Deepak Rawat *Sent:* Wednesday, April 02, 2014 11:51 AM *To:* excel-macros *Subject:* $$Excel-Macros$$ Macro for data indexing Dear friends, I attached a sheet it has a data set A I need to convert data into data set B for cleaning (value is comma separated) after cleaning and unique i have to put that data into same format as data set A i.e. comma separated on appropriate serial number i have a huge data set to clean i know it is best possible with the macro Kindly help me out to complete this and to learn Regards, Deepak -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Fwd: $$Excel-Macros$$ Show links which to other Data source
-- Forwarded message -- From: Ashish Bhalara ashishbhalar...@gmail.com Date: Tue, Apr 1, 2014 at 1:23 PM Subject: $$Excel-Macros$$ Show links which to other Data source To: excel-macros@googlegroups com excel-macros@googlegroups.com Dear experts, My workbook containing large no. of sheets formulas, but I want to show those formulas which containing links to other data source of file. Kindly know me how to check it. -- Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Macro for data indexing
Dear Ravinder, i was making mistake in selection but its working correct, kindly give me a code to reverse it my point is after doing all words in one line i could make them unique but after that i need to put in that form again Regards, Deepak Rawat On Wed, Apr 2, 2014 at 2:42 PM, Ravinder ravinderexcelgr...@gmail.comwrote: pfa *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Deepak Rawat *Sent:* Wednesday, April 02, 2014 11:51 AM *To:* excel-macros *Subject:* $$Excel-Macros$$ Macro for data indexing Dear friends, I attached a sheet it has a data set A I need to convert data into data set B for cleaning (value is comma separated) after cleaning and unique i have to put that data into same format as data set A i.e. comma separated on appropriate serial number i have a huge data set to clean i know it is best possible with the macro Kindly help me out to complete this and to learn Regards, Deepak -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Re: All text box need to be enter
Dear Ganesh, Thank you very much for quick reply. Once enter the data in all textbox after that hit the submit button. and after transfer the data to excel sheet all textbox need to be blank. as this very confidential data of user not suppose to be duplicate. Please help. Regards, Rameshwari :) On Wed, Apr 2, 2014 at 2:32 PM, Ganesh N ganeshg...@gmail.com wrote: Hi Rameshwari, Please find the attached file. Regards, Ganesh N On Wed, Apr 2, 2014 at 3:41 PM, Rameshwari rameshwarish...@gmail.comwrote: Dear Team, Forget to attached excel sheet. Please help on this Regards, Rameshwari :) On Wednesday, April 2, 2014 10:26:11 AM UTC+4, Rameshwari wrote: Dear Team, I am creating one tool in user form, it contains 3 textboxes, need help on fallowing If textbox3 fill with information then check for textbox4, if filled with information then check for textbox5. If all textbox 3, 4 5 are filled with information then go to remaining process. If any of 1 from these textbox is empty then prompt with the msgbox(textbox (name)). -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Re: All text box need to be enter
Dear Ganesh, Thank you very much for quick reply. Once enter the data in all textbox after that hit the submit button. and after transfer the data to excel sheet all textbox need to be blank. as this very confidential data of user not suppose to be duplicate. Please help. Regards, Rameshwari :) On Wed, Apr 2, 2014 at 2:47 PM, rameshwari shyam rameshwarish...@gmail.comwrote: Dear Ganesh, Thank you very much for quick reply. Once enter the data in all textbox after that hit the submit button. and after transfer the data to excel sheet all textbox need to be blank. as this very confidential data of user not suppose to be duplicate. Please help. Regards, Rameshwari :) On Wed, Apr 2, 2014 at 2:32 PM, Ganesh N ganeshg...@gmail.com wrote: Hi Rameshwari, Please find the attached file. Regards, Ganesh N On Wed, Apr 2, 2014 at 3:41 PM, Rameshwari rameshwarish...@gmail.comwrote: Dear Team, Forget to attached excel sheet. Please help on this Regards, Rameshwari :) On Wednesday, April 2, 2014 10:26:11 AM UTC+4, Rameshwari wrote: Dear Team, I am creating one tool in user form, it contains 3 textboxes, need help on fallowing If textbox3 fill with information then check for textbox4, if filled with information then check for textbox5. If all textbox 3, 4 5 are filled with information then go to remaining process. If any of 1 from these textbox is empty then prompt with the msgbox(textbox (name)). -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to
Re: $$Excel-Macros$$ Re: All text box need to be enter
Hi rameshwari, Please find the updated one. Regards, Ganesh N On Wed, Apr 2, 2014 at 4:18 PM, rameshwari shyam rameshwarish...@gmail.comwrote: Dear Ganesh, Thank you very much for quick reply. Once enter the data in all textbox after that hit the submit button. and after transfer the data to excel sheet all textbox need to be blank. as this very confidential data of user not suppose to be duplicate. Please help. Regards, Rameshwari :) On Wed, Apr 2, 2014 at 2:47 PM, rameshwari shyam rameshwarish...@gmail.com wrote: Dear Ganesh, Thank you very much for quick reply. Once enter the data in all textbox after that hit the submit button. and after transfer the data to excel sheet all textbox need to be blank. as this very confidential data of user not suppose to be duplicate. Please help. Regards, Rameshwari :) On Wed, Apr 2, 2014 at 2:32 PM, Ganesh N ganeshg...@gmail.com wrote: Hi Rameshwari, Please find the attached file. Regards, Ganesh N On Wed, Apr 2, 2014 at 3:41 PM, Rameshwari rameshwarish...@gmail.comwrote: Dear Team, Forget to attached excel sheet. Please help on this Regards, Rameshwari :) On Wednesday, April 2, 2014 10:26:11 AM UTC+4, Rameshwari wrote: Dear Team, I am creating one tool in user form, it contains 3 textboxes, need help on fallowing If textbox3 fill with information then check for textbox4, if filled with information then check for textbox5. If all textbox 3, 4 5 are filled with information then go to remaining process. If any of 1 from these textbox is empty then prompt with the msgbox(textbox (name)). -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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
$$Excel-Macros$$ Copy Data from next Column and Repeat Paste as per the Values
Dear All, I am using Excel 2010. I have attached a sample file with my problem. Please see before and after Any macro help would be appreciate. Regards Rashid -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Copy Data from Column on the right.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Help Required Urgent
Dear experts, Kindly find the attached sheet. --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Book4.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Re: All text box need to be enter
Dear Ganesh, Here active cell will be different, data need to fill as per textbox3 value in colostrum A first empty row textbox4 value in column B first empty row textbox5 value in column C first empty row Please help Regards, Rameshwari :) On Wed, Apr 2, 2014 at 3:04 PM, Ganesh N ganeshg...@gmail.com wrote: Hi rameshwari, Please find the updated one. Regards, Ganesh N On Wed, Apr 2, 2014 at 4:18 PM, rameshwari shyam rameshwarish...@gmail.com wrote: Dear Ganesh, Thank you very much for quick reply. Once enter the data in all textbox after that hit the submit button. and after transfer the data to excel sheet all textbox need to be blank. as this very confidential data of user not suppose to be duplicate. Please help. Regards, Rameshwari :) On Wed, Apr 2, 2014 at 2:47 PM, rameshwari shyam rameshwarish...@gmail.com wrote: Dear Ganesh, Thank you very much for quick reply. Once enter the data in all textbox after that hit the submit button. and after transfer the data to excel sheet all textbox need to be blank. as this very confidential data of user not suppose to be duplicate. Please help. Regards, Rameshwari :) On Wed, Apr 2, 2014 at 2:32 PM, Ganesh N ganeshg...@gmail.com wrote: Hi Rameshwari, Please find the attached file. Regards, Ganesh N On Wed, Apr 2, 2014 at 3:41 PM, Rameshwari rameshwarish...@gmail.comwrote: Dear Team, Forget to attached excel sheet. Please help on this Regards, Rameshwari :) On Wednesday, April 2, 2014 10:26:11 AM UTC+4, Rameshwari wrote: Dear Team, I am creating one tool in user form, it contains 3 textboxes, need help on fallowing If textbox3 fill with information then check for textbox4, if filled with information then check for textbox5. If all textbox 3, 4 5 are filled with information then go to remaining process. If any of 1 from these textbox is empty then prompt with the msgbox(textbox (name)). -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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)
RE: $$Excel-Macros$$ Help Required Urgent
PFA From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Neeraj Chauhan Sent: Wednesday, April 02, 2014 4:43 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help Required Urgent Dear experts, Kindly find the attached sheet. _ http://www.avast.com/ This email is free from viruses and malware because avast! Antivirus http://www.avast.com/ protection is active. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. OK NOT OK.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
RE: $$Excel-Macros$$ Help Required Urgent
Thanks Ravinder From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ravinder Sent: Wednesday, April 02, 2014 5:11 PM To: excel-macros@googlegroups.com Cc: Soum Subject: RE: $$Excel-Macros$$ Help Required Urgent PFA From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Neeraj Chauhan Sent: Wednesday, April 02, 2014 4:43 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help Required Urgent Dear experts, Kindly find the attached sheet. _ http://www.avast.com/ This email is free from viruses and malware because avast! http://www.avast.com/ Antivirus protection is active. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Macro for IF AND condition
Olá Basole, obrigada pela resposta. Ainda não é isso Rs* Acontece que a célula somente deve mudar para o status DELAYED caso ela possua o status ON TRACK *E SE *a data do deadline for menor que a data atual (Se for igual o status deve continuar ON TRACK). Caso eu manualmente mude o status para COMPLETED ou CANCELLED, ainda que a data de deadline seja menor que a data atual, a célula deve permanecer com esses status sem mudar para DELAYED... O racional é que mesmo em atraso uma determinada pessoa pode completar uma determinada tarefa e desta forma ela estará completa ainda que tenha ficado atrasada em determinado período. Esse é um Dashboard de tarefas, estas que podem ser completas ou canceladas por alguma razão e por isso eu preciso ter a flexibilidade nas células de colocar o status COMPLETED ou CANCELLED quando aplicável, alterando-se somente de ON TRACK para DELAYED caso o deadline já tenha sido ultrapassado. Não sei se ficou muito claro! Obrigada. Em terça-feira, 1 de abril de 2014 14h39min06s UTC-3, Basole escreveu: Olá Renata Torquato boa tarde, Veja no anexo que é isso que voce está querendo. Eu só fiz para duas condiçoes se for menor ou se for maior a data. No caso de a data for igual, qual seria o status? Saudaçoes. Basole. 2014-04-01 10:19 GMT-03:00 Renata Torquato renataa...@gmail.comjavascript: : Thanks. Please find attached the file (Sorry but it's not in english). SHEET ACTION PLANS: You will find the column P where I have all the deadlines and column R with the status (Completed, On Track, Cancelled and Delayed). I would like the ON TRACK status to automatically turn to DELAYED if the deadline (Column P) is than the current date (CELL K2 - SHEET DATA). Column R is under data validation and all the status are manually established because we need to change to COMPLETED if the action has been implemented. Thanks. Em domingo, 30 de março de 2014 14h21min17s UTC-3, ashish escreveu: can u share a sample file? On Sun, Mar 30, 2014 at 9:44 PM, Renata Torquato renataa...@gmail.comwrote: Thanks. That's exactly what I tried before but it doesn't work ... =/ Em domingo, 30 de março de 2014 12h29min52s UTC-3, ashish escreveu: Sub test() With Sheets(Sheet1) If .Range(a2).Value VBA.Date And UCase(.Range(a1).Value) = UCase(ON TRACK ) Then .Range(a1).Value = DELAYED End If End With End Sub On Sun, Mar 30, 2014 at 8:32 PM, Renata Torquato renataa...@gmail.com wrote: I have the following situation: I would like the range (A1) to change to the status DELAYED if this range shows the status ON TRACK and if the deadline date on range A2 has passed the current date (Formula TODAY in another sheet). If the condition is false I would like range A1 to keep its status (DELAYED, ON TRACK, COMPLETED or ON TRACK), which means that nothing will change with the Macro. I have tried the code however it is not working. I was wondering if maybe it's due to the fact that all the conditions on range A1 are under data validation list? Which code should I try? Thanks. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread
Re: $$Excel-Macros$$ Show links which to other Data source
Sub find_links() Dim extlinks Dim j As Long, k As Long Dim wkb As Workbook Dim rng As Range, cl As Range Dim links1 As String Dim wk As Worksheet Set wkb = Workbooks.Add wkb.Sheets(1).Range(a1).Value = Sheet Name wkb.Sheets(1).Range(b1).Value = Cell Address wkb.Sheets(1).Range(c1).Value = Formula wkb.Sheets(1).Range(d1).Value = External Link k = 2 extlinks = ThisWorkbook.LinkSources(xlExcelLinks) For Each wk In ThisWorkbook.Sheets On Error Resume Next Set rng = wk.UsedRange.SpecialCells(xlCellTypeFormulas) If Not rng Is Nothing Then For j = LBound(extlinks) To UBound(extlinks) links1 = Left(extlinks(j), InStrRev(extlinks(j), \)) [ Right(extlinks(j), Len(extlinks(j)) - InStrRev(extlinks(j), \)) MsgBox links1 For Each cl In rng If InStr( cl.Formula, links1) 0 Then wkb.Sheets(1).Range(a k).Value = wk.Name wkb.Sheets(1).Range(b k).Value = cl.Address wkb.Sheets(1).Range(c k).Value = ' cl.Formula wkb.Sheets(1).Range(d k).Value = extlinks(j) k = k + 1 End If Next Next End If Err.Clear Set rng = Nothing Next End Sub On Wed, Apr 2, 2014 at 4:10 PM, Ashish Bhalara ashishbhalar...@gmail.comwrote: -- Forwarded message -- From: Ashish Bhalara ashishbhalar...@gmail.com Date: Tue, Apr 1, 2014 at 1:23 PM Subject: $$Excel-Macros$$ Show links which to other Data source To: excel-macros@googlegroups com excel-macros@googlegroups.com Dear experts, My workbook containing large no. of sheets formulas, but I want to show those formulas which containing links to other data source of file. Kindly know me how to check it. -- Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you
Re: $$Excel-Macros$$ Convert PDF to Excel - single file with 12000 pages
Pls. share your PDF file, so I can adjust the code in this format. Regards, Basole. 2014-04-02 1:37 GMT-03:00 Abhishek Jain abhishek@gmail.com: I tried saving the PDF as Text and importing it in Excel, it didn't work. Do you have a sample macro or something that I can try? Thanks. On Tue, Apr 1, 2014 at 11:24 PM, Ricardo(R) ricardo...@gmail.com wrote: Hi Abhishek Jain, If the formatting of the PDF files is standardized, you can create a macro to convert to TXT and then import into excel and then save in xlsx format automatically for all pages. Regards, Basole. 2014-04-01 11:30 GMT-03:00 Abhishek Jain abhishek@gmail.com: Hi Friends, I have a PDF file with some 11800+ pages in it (around 28 MB). Is there a way I can convert it in Excel format using a macro or a tool? Many thanks for help. Regards, Abhishek -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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
Re: $$Excel-Macros$$ Macro for IF AND condition
Olá, boa tarde. Muito obrigada. Vou testar no arquivo original para ver como roda. Muito obrigada. Att. Em quarta-feira, 2 de abril de 2014 15h19min18s UTC-3, Basole escreveu: Olá Renata boa tarde, Veja agora no anexo, se entendi o que voce quer. Saudações, Basole. 2014-04-02 9:42 GMT-03:00 Renata Torquato renataa...@gmail.comjavascript: : Olá Basole, obrigada pela resposta. Ainda não é isso Rs* Acontece que a célula somente deve mudar para o status DELAYED caso ela possua o status ON TRACK *E SE *a data do deadline for menor que a data atual (Se for igual o status deve continuar ON TRACK). Caso eu manualmente mude o status para COMPLETED ou CANCELLED, ainda que a data de deadline seja menor que a data atual, a célula deve permanecer com esses status sem mudar para DELAYED... O racional é que mesmo em atraso uma determinada pessoa pode completar uma determinada tarefa e desta forma ela estará completa ainda que tenha ficado atrasada em determinado período. Esse é um Dashboard de tarefas, estas que podem ser completas ou canceladas por alguma razão e por isso eu preciso ter a flexibilidade nas células de colocar o status COMPLETED ou CANCELLED quando aplicável, alterando-se somente de ON TRACK para DELAYED caso o deadline já tenha sido ultrapassado. Não sei se ficou muito claro! Obrigada. Em terça-feira, 1 de abril de 2014 14h39min06s UTC-3, Basole escreveu: Olá Renata Torquato boa tarde, Veja no anexo que é isso que voce está querendo. Eu só fiz para duas condiçoes se for menor ou se for maior a data. No caso de a data for igual, qual seria o status? Saudaçoes. Basole. 2014-04-01 10:19 GMT-03:00 Renata Torquato renataa...@gmail.com: Thanks. Please find attached the file (Sorry but it's not in english). SHEET ACTION PLANS: You will find the column P where I have all the deadlines and column R with the status (Completed, On Track, Cancelled and Delayed). I would like the ON TRACK status to automatically turn to DELAYED if the deadline (Column P) is than the current date (CELL K2 - SHEET DATA). Column R is under data validation and all the status are manually established because we need to change to COMPLETED if the action has been implemented. Thanks. Em domingo, 30 de março de 2014 14h21min17s UTC-3, ashish escreveu: can u share a sample file? On Sun, Mar 30, 2014 at 9:44 PM, Renata Torquato renataa...@gmail.com wrote: Thanks. That's exactly what I tried before but it doesn't work ... =/ Em domingo, 30 de março de 2014 12h29min52s UTC-3, ashish escreveu: Sub test() With Sheets(Sheet1) If .Range(a2).Value VBA.Date And UCase(.Range(a1).Value) = UCase(ON TRACK ) Then .Range(a1).Value = DELAYED End If End With End Sub On Sun, Mar 30, 2014 at 8:32 PM, Renata Torquato renataa...@gmail.com wrote: I have the following situation: I would like the range (A1) to change to the status DELAYED if this range shows the status ON TRACK and if the deadline date on range A2 has passed the current date (Formula TODAY in another sheet). If the condition is false I would like range A1 to keep its status (DELAYED, ON TRACK, COMPLETED or ON TRACK), which means that nothing will change with the Macro. I have tried the code however it is not working. I was wondering if maybe it's due to the fact that all the conditions on range A1 are under data validation list? Which code should I try? Thanks. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
Re: $$Excel-Macros$$ Copy Data from next Column and Repeat Paste as per the Values
Rashid Sir, Hope attached will help? On Wed, Apr 2, 2014 at 4:39 PM, Rashid Khan prkha...@gmail.com wrote: Dear All, I am using Excel 2010. I have attached a sample file with my problem. Please see before and after Any macro help would be appreciate. Regards Rashid -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Copy Data from Column on the right.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ Re: Macro for data indexing
Hello, what I propose will involve Word (or any other word processor) besides excel but will work pretty fast: Copy the column with the data to Word, paste it as unformatted text. Run a replacement searching for commas and replacing them with ^p for paragraph. Copy the data to excel and it should be ok. Quarta-feira, 2 de Abril de 2014 7:21:16 UTC+1, Deepak Rawat escreveu: Dear friends, I attached a sheet it has a data set A I need to convert data into data set B for cleaning (value is comma separated) after cleaning and unique i have to put that data into same format as data set A i.e. comma separated on appropriate serial number i have a huge data set to clean i know it is best possible with the macro Kindly help me out to complete this and to learn Regards, Deepak -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Strange .visble Issue
Hi All, Chanced upon a strange error and unable to find any threads on it. Private Sub SWS_CB_Click() 'SWS_CB is a checkbox while SWS_LB is a listbox If Sheet2.SWS_CB.value = True Then Sheet2.SWS_LB.Visible = True 'Sheet2.SWS_LB.Enabled = True Else Sheet2.SWS_LB.Visible = False End If End Sub When I use this .visible = true; the listbox becomes unselectable; the cross cursor does not change to an arrow. Things tried: 1. All properties (enabled, locked) of the list box changed ... no avail 2. .Enabled does not work too However this code works initially and on other projects as well. It just appears and I managed to find the erroneous line of code. Any suggestions / hints? Thanks in advance ywz -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Validation on button click
Hello Experts, I need your kind, I have attache sheet with my requirement, Please find in attachment. -- Thanks and Regards, Rp. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Validation_On_Button_Click.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
RE: $$Excel-Macros$$ Copy Data from next Column and Repeat Paste as per the Values
pfa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Bipin Singh Sent: Thursday, April 03, 2014 1:33 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Copy Data from next Column and Repeat Paste as per the Values Rashid Sir, Hope attached will help? On Wed, Apr 2, 2014 at 4:39 PM, Rashid Khan prkha...@gmail.com wrote: Dear All, I am using Excel 2010. I have attached a sample file with my problem. Please see before and after Any macro help would be appreciate. Regards Rashid -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Copy Data from Column on the right.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Fwd: $$Excel-Macros$$ Show links which to other Data source
-- Forwarded message -- From: Ashish Bhalara ashishbhalar...@gmail.com Date: Wed, Apr 2, 2014 at 4:10 PM Subject: Fwd: $$Excel-Macros$$ Show links which to other Data source To: excel-macros@googlegroups com excel-macros@googlegroups.com -- Forwarded message -- From: Ashish Bhalara ashishbhalar...@gmail.com Date: Tue, Apr 1, 2014 at 1:23 PM Subject: $$Excel-Macros$$ Show links which to other Data source To: excel-macros@googlegroups com excel-macros@googlegroups.com Dear experts, My workbook containing large no. of sheets formulas, but I want to show those formulas which containing links to other data source of file. Kindly know me how to check it. -- Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ All text box need to be enter
please share the sample file On Wed, Apr 2, 2014 at 11:56 AM, Rameshwari rameshwarish...@gmail.comwrote: Dear Team, I am creating one tool in user form, it contains 3 textboxes, need help on fallowing If textbox3 fill with information then check for textbox4, if filled with information then check for textbox5. If all textbox 3, 4 5 are filled with information then go to remaining process. If any of 1 from these textbox is empty then prompt with the msgbox(textbox (name)). -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Arrow solution
Dear Expert team I required arrow solution in excel for UP Down Constant.Pls see attached sheet. Regards Amar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. arrow.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet