Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA
On Tue, 4/4/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 1:42 AM On Mon, 4/3/17, 'Derrick Andrew' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Monday, April 3, 2017, 5:12 PM On Mon, 4/3/17, 'Hopkins Ruben' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Monday, April 3, 2017, 4:59 PM On Mon, 4/3/17, 'Karleen Biggs' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Monday, April 3, 2017, 1:53 PM On Mon, 4/3/17, Hitesh Kr. Aoul wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: "MS EXCEL AND VBA MACROS" Date: Monday, April 3, 2017, 5:44 AM Hello Guys, Can anyone have any idea how to do the perfect Coding for this type of software... Waiting for the positive reply... On Wednesday, March 29, 2017 at 5:32:50 PM UTC+5:30, Hitesh Kr. Aoul wrote:Hello Learner, Thanks for the reply. Please find the attachment, for material IN form i need subform as there are 100 items in Per Invoice to be enter. Kindly check and if anything else required please discuss. Regards,Hitesh On Wednesday, March 29, 2017 at 2:58:11 PM UTC+5:30, learner wrote:Hi Hitesh, There are many solutions for inventory data. If you want customized solution, you need to specify input and output data and the report forms to be generated. Attach a file giving basic structure Learner On Tue, Mar 28, 2017 at 12:30 PM, Hitesh Kr. Aoul wrote: Hello Guys, Can anyone have any idea how to do the Coding for this type of software... Waiting for the positive reply... -- 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 https://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)
Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA
On Tue, 4/4/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 1:42 AM On Mon, 4/3/17, 'Derrick Andrew' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Monday, April 3, 2017, 5:12 PM On Mon, 4/3/17, 'Hopkins Ruben' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Monday, April 3, 2017, 4:59 PM On Mon, 4/3/17, 'Karleen Biggs' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Monday, April 3, 2017, 1:53 PM On Mon, 4/3/17, Hitesh Kr. Aoul wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: "MS EXCEL AND VBA MACROS" Date: Monday, April 3, 2017, 5:44 AM Hello Guys, Can anyone have any idea how to do the perfect Coding for this type of software... Waiting for the positive reply... On Wednesday, March 29, 2017 at 5:32:50 PM UTC+5:30, Hitesh Kr. Aoul wrote:Hello Learner, Thanks for the reply. Please find the attachment, for material IN form i need subform as there are 100 items in Per Invoice to be enter. Kindly check and if anything else required please discuss. Regards,Hitesh On Wednesday, March 29, 2017 at 2:58:11 PM UTC+5:30, learner wrote:Hi Hitesh, There are many solutions for inventory data. If you want customized solution, you need to specify input and output data and the report forms to be generated. Attach a file giving basic structure Learner On Tue, Mar 28, 2017 at 12:30 PM, Hitesh Kr. Aoul wrote: Hello Guys, Can anyone have any idea how to do the Coding for this type of software... Waiting for the positive reply... -- 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 https://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)
Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA
On Tue, 4/4/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 9:21 AM On Tue, 4/4/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 8:01 AM On Tue, 4/4/17, 'Yu Spain' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 5:48 AM On Tue, 4/4/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 1:42 AM On Mon, 4/3/17, 'Derrick Andrew' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Monday, April 3, 2017, 5:12 PM On Mon, 4/3/17, 'Hopkins Ruben' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Monday, April 3, 2017, 4:59 PM On Mon, 4/3/17, 'Karleen Biggs' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Monday, April 3, 2017, 1:53 PM On Mon, 4/3/17, Hitesh Kr. Aoul wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: "MS EXCEL AND VBA MACROS" Date: Monday, April 3, 2017, 5:44 AM Hello Guys, Can anyone have any idea how to do the perfect Coding for this type of software... Waiting for the positive reply... On Wednesday, March 29, 2017 at 5:32:50 PM UTC+5:30, Hitesh Kr. Aoul wrote:Hello Learner, Thanks for the reply. Please find the attachment, for material IN form i need subform as there are 100 items in Per Invoice to be enter. Kindly check and if anything else required please discuss. Regards,Hitesh On Wednesday, March 29, 2017 at 2:58:11 PM UTC+5:30, learner wrote:Hi Hitesh, There are many solutions for inventory data. If you want customized solution, you need to specify input and output data and the report forms to be generated. Attach a file giving basic structure Learner On Tue, Mar 28, 2017 at 12:30 PM, Hitesh Kr. Aoul wrote: Hello Guys, Can anyone have any idea how to do the Coding for this type of software... Waiting for the positive reply... -- 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
Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA
On Wed, 4/5/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 7:21 AM On Wed, 4/5/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 6:25 AM On Wed, 4/5/17, 'Hopkins Ruben' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 5:28 AM On Wed, 4/5/17, 'Carmelita Cronin' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 4:19 AM On Wed, 4/5/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 3:39 AM On Wed, 4/5/17, 'Carmelita Cronin' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 1:26 AM On Wed, 4/5/17, 'Kenyatta Freed' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 1:15 AM On Tue, 4/4/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 9:37 PM On Tue, 4/4/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 6:09 PM -------------------- On Tue, 4/4/17, 'Yu Spain' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 10:38 AM On Tue, 4/4/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 9:21 AM On Tue, 4/4/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 8:01 AM -------------------- On Tue, 4/4/17, 'Yu Spain' via MS EXCEL AND VBA MACROS
Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA
On Wed, 4/5/17, 'Yu Spain' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 2:27 PM On Wed, 4/5/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 7:21 AM On Wed, 4/5/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 6:25 AM On Wed, 4/5/17, 'Hopkins Ruben' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 5:28 AM On Wed, 4/5/17, 'Carmelita Cronin' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 4:19 AM On Wed, 4/5/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 3:39 AM On Wed, 4/5/17, 'Carmelita Cronin' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 1:26 AM On Wed, 4/5/17, 'Kenyatta Freed' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 1:15 AM On Tue, 4/4/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 9:37 PM On Tue, 4/4/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 6:09 PM -------------------- On Tue, 4/4/17, 'Yu Spain' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 10:38 AM On Tue, 4/4/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 9:21 AM On Tue, 4/4/17,
Re: $$Excel-Macros$$ Re: Macros for screenshot
On Sat, 4/8/17, 'Julienne Schindler' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Saturday, April 8, 2017, 7:49 PM On Sat, 4/8/17, 'Julienne Schindler' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Saturday, April 8, 2017, 8:18 PM On Sat, 4/8/17, 'Karleen Biggs' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Saturday, April 8, 2017, 5:28 PM On Sat, 4/8/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Saturday, April 8, 2017, 2:57 PM On Sat, 4/8/17, 'Derrick Andrew' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Saturday, April 8, 2017, 2:53 PM On Sat, 4/8/17, 'Carmelita Cronin' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Saturday, April 8, 2017, 10:13 AM On Sat, 4/8/17, priti verma wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Saturday, April 8, 2017, 9:03 AM first you need to open that excel file and activate that particular excel file by using application.actiavte "workbbok name" and paste into excel file in desired range. On Fri, Mar 31, 2017 at 4:40 PM, suresh k wrote: Experts any inputs for the below requirement? On 23-Mar-2017 1:43 pm, "suresh k" wrote: Hi All, I have 10 files in my c drive. I have to capture other applications screenshot and paste in all 10 files. I am able to capture screenshot, but not able to paste in 10 excel file. Please suggest macro to paste screenshot in all files Regards, Suresh -- 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+unsubscribe@ googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://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
Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB
On Thu, 4/13/17, 'Hopkins Ruben' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB To: excel-macros@googlegroups.com Date: Thursday, April 13, 2017, 7:02 PM On Thu, 4/13/17, 'Liberty Stringer' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB To: excel-macros@googlegroups.com Date: Thursday, April 13, 2017, 4:49 PM On Thu, 4/13/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB To: "excel-macros@googlegroups.com" Date: Thursday, April 13, 2017, 2:49 PM Here's the approach I took:I defined a "public" Dictionary object called Dict_Category.I created a function to load the Dict_Category with the category listing from the "DATA" sheet. Being a "public" variable, the values are retained while the workbook is open. I created two worksheet events:Worksheet_SelectionChangeWorksheet_Change I created two events so that the Comments update when the cell is selected, and also if you were to copy/paste several cells into column "A". Personally, I think the Change event is the only one that is required. The Update_Comments function does things like:- Clears the comments from cells that are blank- Shows a message if a value is entered that is not in the Dictionary hope this gives you something to work from. Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - On Thursday, April 13, 2017 5:26 AM, sunil lobo wrote: hi [U][SIZE=5]just want to have comments populate when the cell is selected based on the lookup/vlookup function through VB[/SIZE][/U]two sheet 1) master_sheet 2 )data sheet masters sheet being dynamic data sheet is staticmaster sheet continuosly changing now when a particular cell is activated by using mouse or keyboard comments should pop-up getting the value from the next data sheet eg: master sheet , cell a2= 1 cell a3=2 cell a4=4so on and so forth in data sheet , cell a2= 5 , cell b2= present a3=2, cell b3= absent a4= 3,cell b4= leave a5= 1, cell b5= leftnow when i select a3 cell in master_sheet i need to populate a comment as [B]absent[/B], when the cell a3 changes to value [B]1[/B] i should get a comment display of value [B]left[/B]also when the cell value changes it chsould clear the previous comment basically it should popup comments based on the value from the data sheet !:) attaching herewith the sample data for ur reference -- 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 https://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 for
Re: $$Excel-Macros$$ Need help in Macro to convert table into dump.
On Thu, 6/1/17, 'Martin George' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Need help in Macro to convert table into dump. To: excel-macros@googlegroups.com Date: Thursday, June 1, 2017, 6:30 PM On Thu, 6/1/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ Need help in Macro to convert table into dump. To: "excel-macros@googlegroups.com" Date: Thursday, June 1, 2017, 4:47 PM There is no standard format for "Raw Data".It depends on the original Application used to CREATE the source of data.Some systems output ASCII (text) files Some are tab delimited.Others are comma delimited (csv). The mechanism you used to read in the "raw data" used known characteristics of the data to determine how it is to be interpreted. Without knowing the characteristics of the "raw data", it would be impossible to reverse-engineer the file. It's like saying: "I'm standing outside of my home, tell me how I got here"The answer requires first knowing where you started and what options are available to get from the start to the end.Lots of options are AVAILABLE, but if your starting point is two streets away, the use of an airplane is unlikely. Teleportation is WAY cooler, and should remain in consideration for that reason! :) More details are required. Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - On Thursday, June 1, 2017 10:20 AM, Secret Shot wrote: Dear Team, I have one very large excel table which i made from Raw data, accidentally raw data has been deleted and the only option i have is that table to convert back in raw data. Its about my job so pls help, i have attached of the sample of what i am talking about. if anyone can me in writing a macro which can create raw data basis on the count in front of number and considering their header. Please help -- Pankaj Pandey Bhopal -- 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 https://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 https://groups.google
Re: $$Excel-Macros$$ Urgent Opening for Ab-initio with AWS JAVA back ground : Richmond VA
On Fri, 6/23/17, 'Julienne Schindler' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Urgent Opening for Ab-initio with AWS JAVA back ground : Richmond VA To: excel-macros@googlegroups.com Date: Friday, June 23, 2017, 4:53 PM On Fri, 6/23/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ Urgent Opening for Ab-initio with AWS JAVA back ground : Richmond VA To: "excel-macros@googlegroups.com" Date: Friday, June 23, 2017, 1:20 AM Sir: I realize you are new...But if you read the Forum RULES, #4 specifically states:4) Jobs posting is not allowed. I have nearly 100 users that I've had to block from my email because they joined for the sole purpose of head-hunting.That's not what this site is about and not why I joined the site and I resent spending the time managing my blocked email list when I could be helping users with legitimate issues. If you are in need of assistance with Excel macros, then welcome!If you're looking for employees, well it ought to make a potential employee wonder if he/she can trust a company that cannot be bothered to follow the rules... Just an observation... Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - On Thursday, June 22, 2017 5:39 PM, Kamal Paul wrote: Hi All ,i have an urgent Opening for ab-initio with Java Back ground. please find the details for the Position and Reply me if you have available consultant for the same. Title : Ab-nitio with AWS java Job Type : Contractual location : Richmond VADuration : 6 months · Work involves transferring from DDE to AWS using Ab Initio – Need candidates with strong Ab Initio background with java skills· Need folks with AWS knowledge with scripting to create infrastructure, should have Java background Kamal PaulTechnical Recruiter (Desk):610-590-1511 Gtalk : recruiter.kp...@gmail.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 https://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.
Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value
On Tue, 7/4/17, Puttu * wrote: Subject: Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value To: "MS EXCEL AND VBA MACROS" Date: Tuesday, July 4, 2017, 10:03 AM Thanks Sir, Formula match exactly my requirement, however I have more than 50 columns, quite difficult to input formula for every column. Thus the reason I am looking for macro. Please help On Tue, Jul 4, 2017 at 11:21 AM, Swapnil Palande wrote: Hi, No need of macro, you can do it using formulas also. Attached is the excel for your reference. Regards, Swapnil On Tue, Jul 4, 2017 at 10:36 AM, Puttu * wrote: Experts, Any help on this will be much appreciated On Mon, Jul 3, 2017 at 10:33 PM, Puttu * wrote: Hi Experts Please help on this. Thanks Putta On Mon, Jul 3, 2017 at 9:42 PM, Puttu * wrote: Hi Experts, I am not a vba expert and need your help me on the attached requirement. I have list of columns and from that I need to know based on the Model No. column filter if the other columns have any duplicate values, if yes then it should display comments column as Column Name + duplicate value (Ex: Category_description having duplicate value) 2. If the any of the column is blank it should print Column Name is blank (Ex: Parent Category ID has blank value). Attached is the sample spread sheet. Please review and help me on it. -- Putta -- 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/discu ssexcel 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+unsubscribe@googl egroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/grou p/excel-macros. For more options, visit https://groups.google.com/d/op tout. -- Putta -- Putta -- 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/discu ssexcel 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+unsubscribe@googl egroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/grou p/excel-macros. For more options, visit https://groups.google.com/d/op tout. -- 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 recei
Re: $$Excel-Macros$$ Help on Week Formula
On Sun, 7/30/17, 'Martinez David' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Help on Week Formula To: excel-macros@googlegroups.com Date: Sunday, July 30, 2017, 8:42 PM On Sun, 7/30/17, 'Hopkins Ruben' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Help on Week Formula To: excel-macros@googlegroups.com Date: Sunday, July 30, 2017, 3:31 PM On Sun, 7/30/17, Chandra Shekar wrote: Subject: Re: $$Excel-Macros$$ Help on Week Formula To: excel-macros@googlegroups.com Date: Sunday, July 30, 2017, 2:57 PM Hello Paul, For Ex: If I mention date as 07/01/2017(Sat) formula should give Week 1 from there every week it should increase by 1.1) 07-01-2017 to 07-07-2017 = Week12) 22-01-2017 to 28-07-2017 = Week43) 29-07-2017 - 04-08-2017 = Week5 Regards, Chandru On Tue, Jul 25, 2017 at 4:31 PM, Paul Schreiner wrote: I think you'll need to be more specific on how you want the "weeks" calculated.For instance, in August (2017) August 1 is on a Tuesday. so, the weeks are handled: but, July 1 is on a Saturday,so, does Week 1 only have a single day? Or is July 1 counted as part of week 5 of June.If so, what is the minimum number of days counted in a week 1? Or are you wanting a simple count of days:Week 1 = first 7 daysWeek 2 = Second 7 daysetc. Paul-- --- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -- --- On Tuesday, July 25, 2017 3:34 AM, Chandra Shekar wrote: Hello Team, Could you please help me in attached week formula. Regards, Chandru -- 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+unsubscribe@ googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://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+unsubscribe@ googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/ gr
Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 4 updates in 3 topics
On Wed, 12/20/17, 'Karleen Biggs' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 4 updates in 3 topics To: excel-macros@googlegroups.com Date: Wednesday, December 20, 2017, 9:19 PM On Wed, 12/20/17, David Lanman wrote: Subject: Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 4 updates in 3 topics To: excel-macros@googlegroups.com Date: Wednesday, December 20, 2017, 1:56 AM How about simply copy and paste values and do it to the the whole sheet?Sub CopyPastVal() Cells.Copy Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues Application.CutCopyMode = FalseEnd SubThanks, David On Tue, Dec 19, 2017 at 3:31 PM, wrote: excel-macros@googlegroups.com Google Groups Topic digest View all topics Urgent Need Business Analyst 2 (Columbus OH) 06+ Months - 1 Update Excel Macro Help - 2 Updates Help with replacing formula with value over large range - 1 Update Urgent Need Business Analyst 2 (Columbus OH) 06+ Months Javeed Khan : Dec 19 01:53PM -0500 Please share profile on ja...@nestarit.com Direct contact number: (201) 448 1184 This is *Javed Khan* from *NESTAR TECHNOLOGIES/ AESPATECH LLC* and we have an immediate requirement with our client where we have excellent hold and can close the positions pretty quick. If you find yourself comfortable with the requirement please reply back with your updated resume and I will get back to you or I would really appreciate if you can give me a call back at my contact number. We have a Requirement *Business Analyst 2 / BA2* position in *Columbus OH*. If you have any matching resumes for the below mentioned position. VERY URGENT AND IMMEDIATE NEED Job Title: Business Analyst 2 / BA2 Location: *Columbus OH (Local)* Duration: 06+ Months Contract *Interview: INTERVIEW ONSITE ON WEDNESDAY* The Business Analyst is responsible for the set of tasks and techniques used to work as a liaison among stakeholders in order to understand the structure, policies, and operations of an organization, and to recommend solutions that enable the organization to achieve its goals. *Requirements:* • *Four to six years of experience with the following:* • Experience creating and coordinating technical documentation preparation and distribution for processes, projects and procedures. • Experience gathering, analyzing information needs and functional requirements from stakeholders, business owners, and customers. • Experience analyzing user needs and existing functions to determine business requirements, screen and interface design, use cases. • Experience providing ongoing system maintenance and evaluation of systems. • Experience delivering project artifacts. • Experience analyzing business requirements using interviews, document analysis, and workshops. • Analyzes, reviews, and recommends possible solutions to identified business problems. • Develop test scripts, test cases, for User Acceptance Testing (UAT) based on requirements. • Act liaison between business units, customers (internal and external) and various stakeholders. • Assist Project Manager in project planning and developing project task plans, leading JAD sessions. • Work experience in creating and coordinating technical, functional and business requirements for processes, projects and procedures. • Excellent communication both oral and written.- REQUIRED -- --- *Warm Regards,* Javed Khan (Sr. Technical Recruiter) *NESTAR TECHNOLOGIES/ AESPATECH LLC*
Re: $$Excel-Macros$$ Re: concatenate in one cell
On Sat, 12/30/17, 'Kenyatta Freed' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: concatenate in one cell To: excel-macros@googlegroups.com Date: Saturday, December 30, 2017, 10:18 AM On Fri, 12/29/17, 'Kenyatta Freed' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: concatenate in one cell To: excel-macros@googlegroups.com Date: Friday, December 29, 2017, 3:34 AM On Thu, 12/28/17, N.Shivkumar wrote: Subject: Re: $$Excel-Macros$$ Re: concatenate in one cell To: excel-macros@googlegroups.com Date: Thursday, December 28, 2017, 8:14 AM see attached solution On 25 December 2017 at 14:35, Aamir Shahzad wrote: this is manual formula & need select cells one by one I want to use entire range e.g. A1:HL1 On Mon, Dec 25, 2017 at 4:40 AM, who wrote: =trim(C4)&trim(D4)&trim(E4)&tr im(F4)&trim(G4) Try the above, assuming the data is in the addresses used. Thanks, David On Saturday, December 23, 2017 at 1:39:57 AM UTC-8, Aamir Shahzad wrote:Friends, I want to concatenate all below data in one cell without any space. Formula please. data148351,183776,032290, result148351,183776,032290 Regards, Aamir Shahzad -- 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/discu ssexcel 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+unsubscribe@googl egroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/grou p/excel-macros. For more options, visit https://groups.google.com/d/op tout. -- Regards,Aamir Shahzad -- 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+unsubscribe@ googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://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 n