Re: $$Excel-Macros$$ Weekend rates to place in range
Hi Sleek, Use below condition in cell A3 to get output as per your requirement. =IF(OR(WEEKDAY(A3,2)=6,WEEKDAY(A3,2)=7),$L$4,150) Regards Ashish Bhalara On Sat, Apr 29, 2017 at 7:29 PM, 'Sleek' via MS EXCEL AND VBA MACROS < excel-macros@googlegroups.com> wrote: > Is there a simpler way to input weekend rates ? > see my worksheet !! > I used conditional formatting to highlight weekends but to input range of > dates seems like i have to do in quite a bit of typing !! > I suspect probably using advanced filtering may help here !! > > > > > > -- > 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.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ IF Function
Hi Vinod, Use the below formula. =AVERAGE(MIN(G3:G5),LARGE(G3:G5,2)) Regards Ashish Bhalara On Fri, Jun 24, 2016 at 12:57 PM, Vinod Kumar wrote: > Good Afternoon, > > Please help, how to calculate the average price between the lowest and > second lowest price, when there is 5 different price for one item. > > -- > 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.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ sharing a template for accounting
Hi Izhar, I know the fundamental of accountancy, you can share your require points to include it. Regards Ashish Bhalara On Sat, Aug 29, 2015 at 10:08 AM, GENIUS wrote: > Thank you very much for sharing the workbook, but it requires more > comprehensiveness, I dont know about your accountancy knowledge but if you > understand then i want to share some more points to be included in this > workbook then we may say that it now a complete and comprehensive > workbook. now it is totally depends on you either you permit me to explain > all the above or not. Once again thank you very much for sharing the > workbook. > > > > On Friday, 28 August 2015 14:04:17 UTC+5, Ashish_Bhalara wrote: >> >> See this attachment. >> >> Regards >> Ashish Bhalara >> >> On Fri, Aug 28, 2015 at 1:37 PM, GENIUS wrote: >> >>> it requires a password to password to open the file >>> >>> On Thursday, 27 August 2015 17:36:06 UTC+5, Ashish_Bhalara wrote: >>>> >>>> Hi, >>>> >>>> See attached file as per your requirement. Enable Macro in Excel before >>>> use it. >>>> >>>> Regards >>>> Ashish Bhalara >>>> >>>> On Thu, Aug 27, 2015 at 12:20 PM, Izhar wrote: >>>> >>>>> Can anyone share a template in which the bank debit and credit goes to >>>>> debit and credit in the respective ledger account and then onward the >>>>> debit >>>>> and credit of ledger goes to in the respective head of trial balance. it >>>>> will be highly appreciated if anyone do the needful. >>>>> Thanks in advance. >>>>> >>>>> -- >>>>> *Izhar Ul Haq* >>>>> >>>>> >>>>> >>>>> Cell# 009203069072597 >>>>> >>>>> -- >>>>> 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 subscri
Re: $$Excel-Macros$$ sharing a template for accounting
See this attachment. Regards Ashish Bhalara On Fri, Aug 28, 2015 at 1:37 PM, GENIUS wrote: > it requires a password to password to open the file > > On Thursday, 27 August 2015 17:36:06 UTC+5, Ashish_Bhalara wrote: >> >> Hi, >> >> See attached file as per your requirement. Enable Macro in Excel before >> use it. >> >> Regards >> Ashish Bhalara >> >> On Thu, Aug 27, 2015 at 12:20 PM, Izhar wrote: >> >>> Can anyone share a template in which the bank debit and credit goes to >>> debit and credit in the respective ledger account and then onward the debit >>> and credit of ledger goes to in the respective head of trial balance. it >>> will be highly appreciated if anyone do the needful. >>> Thanks in advance. >>> >>> -- >>> *Izhar Ul Haq* >>> >>> >>> >>> Cell# 009203069072597 >>> >>> -- >>> 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, 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. Account Entries & Report.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Need help to split numbers available in the last
Hi Nasir, Your message can not view but you can use below formula to split number. =--IFERROR(TRIM(RIGHT(A2,LEN(A2)-SEARCH(" ",A2,1))),0) Regards Ashish Bhalara On Wed, Aug 5, 2015 at 5:11 PM, Nasir Shaikh wrote: > > KEY=1ad2be5fa4f57b86403816ac8682739e41b04832&CLIENT=520b4539-6b10-73eb-2e6e-2728cff6aa79 > > This secure message was sent using Dmail. To view this message, simply > click the button below > > View Message > <https://mail.delicious.com/view/?id=1ad2be5fa4f57b86403816ac8682739e41b04832&key=520b4539-6b10-73eb-2e6e-2728cff6aa79> > > Secure message sent via Dmail <https://mail.delicious.com> > <https://mail.delicious.com> > > On Wed, Aug 5, 2015 at 5:08 PM, Paul Schreiner > wrote: > >> Sorry, I am unable to view the response. >> *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* >> - >> >> -- >> *From:* Nasir Shaikh >> *To:* excel-macros@googlegroups.com >> *Sent:* Wednesday, August 5, 2015 7:34 AM >> >> *Subject:* Re: $$Excel-Macros$$ Need help to split numbers available in >> the last >> >> >> KEY=55a65c4efb80535a8efd001eee190a4795a02acc&CLIENT=f090d7af-c960-0296-57db-a2d0ed8b4084 >> >> This secure message was sent using Dmail. To view this message, simply >> click the button below >> View Message >> <https://mail.delicious.com/view/?id=55a65c4efb80535a8efd001eee190a4795a02acc&key=f090d7af-c960-0296-57db-a2d0ed8b4084> >> Secure message sent via Dmail <https://mail.delicious.com/> >> <https://mail.delicious.com/> >> >> >> >> On Wed, Aug 5, 2015 at 4:54 PM, Paul Schreiner >> wrote: >> >> For MOST of the data, you could use an excel function like: >> >> =TRIM(RIGHT(TRIM(A3),15)) >> >> (for row 3) >> >> but rows 2 and 7 do not have the $$ at the end of the row. >> In fact, they do not seem to have the $$ at all! >> >> *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* >> - >> >> -- >> *From:* Paul Schreiner >> *To:* "excel-macros@googlegroups.com" >> *Sent:* Wednesday, August 5, 2015 7:21 AM >> *Subject:* Re: $$Excel-Macros$$ Need help to split numbers available in >> the last >> >> What type of solution are you looking for? >> VBA macros? >> Excel function? >> Manual steps? >> >> how often do you need to do this? >> (is it a one-time thing, or daily/weekly/monthly?) >> >> What is the source of the data? >> Can you provide delimiters in the output? >> >> *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* >> - >> >> -- >> *From:* Nasir Saikh >> *To:* MS EXCEL AND VBA MACROS >> *Sent:* Wednesday, August 5, 2015 3:35 AM >> *Subject:* $$Excel-Macros$$ Need help to split numbers available in the >> last >> >> Hi, >> >> Please help me out to split numbers from a cells if the numbers available >> in the last then. >> >> Example attached. >> >> 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
Re: $$Excel-Macros$$ Vlookup query
Make a little changes in your formula as mention below, then lookup on that value. =--MID(A9,FIND(1,A9,1),6) On Sat, Jun 13, 2015 at 1:07 PM, Shrinivas Shevde wrote: > > Dear All > > I have a text in Column A4 ,I am extracting a number from that text in > colum B4,using outcome of I want to use Vlookup but its not successful. > Same Out put I entered by hand in the column then I get desire result. > To entered manually its take lot of time I have more than 1000 data. > Please find attached file, > > -- > Shrini > > -- > 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$$ how to seperate
Hello Mr.Kumar You can get same output by pivot table, see the attached file. On Sat, Jun 13, 2015 at 3:37 PM, Kumar Bhanushali < kumar.bhanush...@pmcprojects.com> wrote: > > *Dear Sir,* > > I had attached a file which contains Daily Report sheet, I am updating > this sheet daily. This sheet contains 7 nos of contractor. > > From this sheet, I have to separate data, contractor wise. > > Please help > > > > > *Regards, Kumar Bhanushali* > DISCLAIMER > The information contained in this e-mail including attachment is meant > only for the addressee and may contain confidential and privileged > information. Any use, distribution, printing, retransmission, > dissemination, copying or disclosure of this e-mail by any other person is > strictly prohibited and may be unlawful. If you are not the intended > recipient and receive this e-mail in error, please notify the sender by > reply e-mail and then permanently delete this message. Electronic > transmission cannot be guaranteed to be secured. Accordingly, PMC Projects > (I) Pvt Ltd does not accept liability for any data loss, corruption, > interception, unauthorised amendment, viruses, delays or consequences > thereof. > > -- > 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. Combined.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ I need a excel where users can add data but cannot delete.
Hello Mr.Nasir Firstly select all cell and unchecked Locked property from Format Cells. Paste below code in coding area of worksheet. Hope it would useful as per your requirement. Private Sub Worksheet_Change(ByVal Target As Range) Worksheets("Sheet1").Unprotect Password:="abc" Range("A1:N28").SpecialCells(xlCellTypeConstants, 23).Locked = True Worksheets("Sheet1").Protect Password:="abc" End Sub On Wed, Jun 3, 2015 at 4:38 PM, Paul Schreiner wrote: > What you can do is: > > Select all cells and change the properties to "unlocked". > Change the properties on the "header" row to "locked". > Protect the worksheet (with or without a password) > > Write a BeforeSave event macro that: > Unprotects the worksheet. > Change the properties of any rows with values (data) to "locked" > Protect the sheet > > You can decide when protecting the worksheet whether the user > is allowed to select locked cells. > Otherwise, they cannot modify the protected cells. > > If you need help with this, let me know. > > *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* > - > > -- > *From:* Nasir Saikh > *To:* excel-macros@googlegroups.com > *Sent:* Wednesday, June 3, 2015 2:46 AM > *Subject:* $$Excel-Macros$$ I need a excel where users can add data but > cannot delete. > > Hi Experts, > > I need to help to make a excel database. > In the excel file I need, users can open the sheet and add the data write > anything and can be save. > But they cannot delete anything from the excel once they kept any value in > the excel. > > > Regards > Nasir Shaikh > > -- > 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. > -- Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üa
$$Excel-Macros$$ Split Data Query
Hello experts, I want to split selection data to next columns by macro, please see attached file for require output. -- 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. Query of split data.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Re: Copy PDF data to Excel macro require
To convert PDF to excel visit the site smallpdf.com On Fri, May 8, 2015 at 3:17 PM, Mandeep Baluja wrote: > I don't think there is any code which can do the same, you need a software > for that. > > > Check this Out. > > Regards, > Mandeep Baluja > Email :-mandeep.bal...@snapdeal.com > mandeep.bal...@gmail.com > https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77 > https://www.facebook.com/groups/825221420889809/ > > > On Thursday, May 7, 2015 at 7:42:59 PM UTC+5:30, Pankaj Sharma wrote: >> >> Hi everyone, >> >> Need your help for this easy. I have a folder with multi PDF files. I >> need a macro to copy all pdf data in a workbook. >> >> Note: One pdf data should be copy in one sheet. >> >> -- > 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$$ Re: Please help with Activex "cannot insert object". error
Try to search after un-hide files from explorer Tools-Folder options-View. On Sun, Apr 26, 2015 at 1:28 PM, Rohit Jadhav wrote: > Hi Paul > I tried doing searching the .exd files in the appdata folder but as you > can see the attachment there is nothing in the search of the folder. Also I > have started experiencing this problem after an update of windows but am > not able to find it. > > -- > 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$$ Re: Need function help to calculate on matched field data
Thank you Mr.Mandeep :) On Sun, Apr 5, 2015 at 11:49 PM, Mandeep Baluja wrote: > Retreived by sumproduct and vlookup check this out. > > Regards, > Mandeep Baluja > Learningzmypassion > > > > > > > > > > > > > On Sunday, April 5, 2015 at 5:47:05 PM UTC+5:30, Ashish_Bhalara wrote: >> >> Dear experts, >> >> Kindly see attached file in which I make formula in yellow cell that is >> if match particular task with Sheet2 table, the calculated data should be >> from matched task. I tried with array but not get exact output. Please >> suggest me how to calculate data only those which matched of Sheet1 task >> with Sheet2 task. >> >> >> 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.
$$Excel-Macros$$ Need function help to calculate on matched field data
Dear experts, Kindly see attached file in which I make formula in yellow cell that is if match particular task with Sheet2 table, the calculated data should be from matched task. I tried with array but not get exact output. Please suggest me how to calculate data only those which matched of Sheet1 task with Sheet2 task. 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. Query for Array Function.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ How to show VBA code in *.xlsm format file
Dear experts, I have downloaded some files with macro to editing in ribbon for learning purpose, but I can't see coding in file. Could you guide me how to show VBA code in attached file. Kindly also know me some books of VBA coding about editing in Excel Ribbon. Thanks in advance 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. ControlsPart1.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12 ControlsPart2.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Query in code of email send with attachment from excel
When value of path is null, function by default set 0 in cell F2, so I tried below code to avoid error on path not written in cell. but though same error is occur, pls do something in coding. If ws.Range("F2") <> Chr(48) Then .addattachment rngAttach1.Value End If On Mon, Mar 23, 2015 at 6:30 PM, Vaibhav Joshi wrote: > Before adding att check if attachment exists or not, if its null then you > will get error... > > Cheers!! > > On Mon, Mar 23, 2015 at 5:00 PM, Ashish Bhalara > wrote: > >> Dear experts, >> >> See the attached file of email sending from excel. Normally mail send >> successfully to all together from database. I need attached file to some of >> party so I add column 'Attachment (Filename with path)' in sheet of 'Mail >> Data', file also send successfully as per path written but problem is that >> if file name and location not written, error occur of 'The spcified >> protocol is unknown'. >> >> Could you please edit in below coding that .addattachment code is only >> work if the value in cell F2 in sheet 'Mail' is not nill. >> >> >> Sub CDO_Mail_Small_Text_2() >> Dim iMsg As Object >> Dim iConf As Object >> Dim mailto As String, ccto As String, sItem As String >> Dim Flds As Variant >> Dim rng As Range, rngAttach1 As Range, rngAttach2 As Range, >> rngAttach3 As Range >> Dim i As Integer >> Application.DisplayStatusBar = True >> Worksheets("Mail").Unprotect Password:="aryan" >> >> Set rngAttach1 = Worksheets("Mail").Range("f2") >> 'Set rngAttach2 = Worksheets("Mail").Range("f3") >> Set iMsg = CreateObject("CDO.Message") >> Set iConf = CreateObject("CDO.Configuration") >> iConf.Load -1' CDO Source Defaults >> Set Flds = iConf.Fields >> With Flds >> .Item("http://schemas.microsoft.com/cdo/configuration/smtpusessl";) >> = True >> .Item(" >> http://schemas.microsoft.com/cdo/configuration/smtpauthenticate";) = 1 >> .Item(" >> http://schemas.microsoft.com/cdo/configuration/sendusername";) = " >> ashishbhalar...@gmail.com" >> .Item(" >> http://schemas.microsoft.com/cdo/configuration/sendpassword";) = "***" >> .Item("http://schemas.microsoft.com/cdo/configuration/smtpserver";) >> = "smtp.gmail.com" >> .Item("http://schemas.microsoft.com/cdo/configuration/sendusing";) >> = 2 >> .Item(" >> http://schemas.microsoft.com/cdo/configuration/smtpserverport";) = 25 >> .Update >> End With >> >> Application.ScreenUpdating = False >> With ActiveSheet.PivotTables("PivotTable2") >> .PivotCache.MissingItemsLimit = xlMissingItemsNone >> .PivotCache.Refresh >> With .PivotFields("Party's Name") >> '---hide all items except item 1 >> .PivotItems(1).Visible = True >> For i = 2 To .PivotItems.Count >> .PivotItems(i).Visible = False >> Next >> For i = 1 To .PivotItems.Count >> .PivotItems(i).Visible = True >> If i <> 1 Then .PivotItems(i - 1).Visible = False >> sItem = .PivotItems(i) >> >> Set rng = Nothing >> On Error Resume Next >> Worksheets("mail").Range("e9:" & >> ActiveSheet.Range("e9").End(xlDown).Address).Select >> Range(Selection, Selection.End(xlToLeft)).Select >> >> Set rng = Selection.SpecialCells(xlCellTypeVisible) >> >> On Error GoTo 0 >> >> 'If rng Is Nothing Then >> ' MsgBox "The selection is not a range or the sheet is protected" >> & _ >> ' vbNewLine & "please correct and try again.", vbOKOnly >>' Exit Sub >> 'End If >> >> With Application >> .EnableEvents = False >> .ScreenUpdating = False >> End With >> >> Application.StatusBar = "Email sending to " & >> Sheets("Mail").Range("B1").Value & ", Email sent " & i - 1 & " out of " & >> .PivotItems.Count >> mailto = Sheets("Mail").Range("B5").Value >> ccto = Shee
$$Excel-Macros$$ Auto mail to more than one email id from excel
Dear experts, I need help in coding of automatic email from data base. Kindly see attached file in which 'Data' sheet contain database and 'Mail' sheet contain data to mail. As per codding I have to manually filter pivot table and send mail one by one. I require loop in my coding to automatic filter data and send mail to all particular party together. I tried using by AutoShowCount and AutoShowField but cannot success. 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. Query of AutoEmail.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Sum value of closing balance of date
Thank you Mr.Vaibhav:) Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Fri, Mar 13, 2015 at 1:28 PM, Vaibhav Joshi wrote: > Hi > > Check cell D20 for formula.. > > On Fri, Mar 13, 2015 at 12:43 PM, Vaibhav Joshi wrote: > >> Hi >> >> Use this array formula =SUM(IF(A3:A17<>A2:A16,D2:D16,0)) >> >> Cheers!! >> >> On Thu, Mar 12, 2015 at 3:34 PM, Ashish Bhalara < >> ashishbhalar...@gmail.com> wrote: >> >>> Dear experts, >>> >>> I need function to sum only closing value of particular date, pls see >>> attached file for example. >>> >>> 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. >>> >> >> > -- > 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.
$$Excel-Macros$$ Sum value of closing balance of date
Dear experts, I need function to sum only closing value of particular date, pls see attached file for example. 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. Quer of Sum.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Mail from excel using gmail
Thanks Mr.Vaibhav to reply. I realize that when I enable Forwarding and POP/IMAP <https://mailtrack.io/trace/link/a8085d1844ea014de74fde5fec93a1ef72f995f4?url=https%3A%2F%2Fmail.google.com%2Fmail%2Fu%2F0%2F%23settings%2Ffwdandpop&signature=349318ba2e1728fd> in Gmail and save changes, the option button is going to unchecked when I see another time this setting. I tried several time to save setting this but this button going to unchecked. The another problem would be is that the internet connection is receive by router not direct and in Outlook setup guidance it's mention that 'However, if you setup a 3rd party outgoing mail server, you will not have access to sent emails via your web based Gmail account panel. ' So, I think it's not possible due to not direct connection of Net, but my first problem to uncheck button automatically of enalbe POP that's I can't understand. Kindly know me the reason if you know, otherwise it's ok. Thanks. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Mon, Mar 9, 2015 at 12:59 PM, Vaibhav Joshi wrote: > Hi > > The script which you gave is using CDO for that you need to have SMTP > services running on your machine through which you are running > macro...check whether smtp servies is running or not? > > for setting gmail on outlook, first goto Forwarding and POP/IMAP > <https://mailtrack.io/trace/link/a8085d1844ea014de74fde5fec93a1ef72f995f4?url=https%3A%2F%2Fmail.google.com%2Fmail%2Fu%2F0%2F%23settings%2Ffwdandpop&signature=349318ba2e1728fd> > &enable > POP/SMTP services .. > > After that setupyour Outlook.. > http://www.emailaddressmanager.com/tips/outlook-gmail.html > > > Pl note: your code wont run on outlook!! > > Cheers!! > > On Sat, Mar 7, 2015 at 8:42 PM, Ashish Bhalara > wrote: > >> Hi Mr.Vaibhav, I tried both as you suggest, but error is still not solve. >> I also tried to setup ms outlook for gmail, but error receive of >> unencrypted connection. I follow all the setting as mentioned in website. >> Kindly solve my query by either send using gmail or add connection of >> gmail in outlook. Thanks. >> On 07-Mar-2015 6:49 PM, "Vaibhav Joshi" wrote: >> >>> Hi >>> >>> change port no. to 465 also you need to enable smpt / imap services for >>> your Google account >>> >>> Cheers >>> On Mar 7, 2015 5:48 PM, "Ashish Bhalara" >>> wrote: >>> >>>> Dear experts, >>>> >>>> I want mail from excel using gmail ID. I want to mail from data sheet >>>> by filtering data of mail receivers. I find the code using google search as >>>> mention below but it's error occur of "The transport failed to connect to >>>> the server." during the running code. Kindly help me regarding this matter. >>>> >>>> >>>> Sub CDO_Mail_Small_Text_2() >>>> Dim iMsg As Object >>>> Dim iConf As Object >>>> Dim strbody As String >>>> Dim Flds As Variant >>>> >>>> Set iMsg = CreateObject("CDO.Message") >>>> Set iConf = CreateObject("CDO.Configuration") >>>> >>>> iConf.Load -1' CDO Source Defaults >>>> Set Flds = iConf.Fields >>>> With Flds >>>> .Item(" >>>> http://schemas.microsoft.com/cdo/configuration/smtpusessl";) = True >>>> .Item(" >>>> http://schemas.microsoft.com/cdo/configuration/smtpauthenticate";) = 1 >>>> .Item(" >>>> http://schemas.microsoft.com/cdo/configuration/sendusername";) = "Full >>>> GMail mail address" >>>> .Item(" >>>> http://schemas.microsoft.com/cdo/configuration/sendpassword";) = "GMail >>>> password" >>>> .Item(" >>>> http://schemas.microsoft.com/cdo/configuration/smtpserver";) = " >>>> smtp.gmail.com" >>>> >>>> .Item("http://schemas.microsoft.com/cdo/configuration/sendusing";) >>>> = 2 >>>> .Item(" >>>> http://schemas.microsoft.com/cdo/configuration/smtpserverport";) = 25 >>>> .Update >>>> End With >>>> >>>> strbody = "Hi there" & vbNewLine & vbNewLine & _ >>>> "This is line 1" & vbNewLine & _ >>>>
Re: $$Excel-Macros$$ Mail from excel using gmail
I checked it, that's not a problem, data browsing and downloading is doing smoothly. On Sun, Mar 8, 2015 at 8:48 AM, Ashish Kumar wrote: > I think your internet connection is slow. > > -- > 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$$ Mail from excel using gmail
Hi.Mr.Ashish Kumar, I tried of changing port number, incoming server popup and also enable smtp/imap service in google account, but still receive error of connection failure. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Sat, Mar 7, 2015 at 8:58 PM, Ashish Kumar wrote: > Hi, > > change port no. to 465 also you need to enable smpt / imap services for > your Google account > and, incoming server pop up - 995 > > Reply back if you facing problem. > > > Regards > Ashish > > -- > 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$$ Mail from excel using gmail
Hi Mr.Vaibhav, I tried both as you suggest, but error is still not solve. I also tried to setup ms outlook for gmail, but error receive of unencrypted connection. I follow all the setting as mentioned in website. Kindly solve my query by either send using gmail or add connection of gmail in outlook. Thanks. On 07-Mar-2015 6:49 PM, "Vaibhav Joshi" wrote: > Hi > > change port no. to 465 also you need to enable smpt / imap services for > your Google account > > Cheers > On Mar 7, 2015 5:48 PM, "Ashish Bhalara" > wrote: > >> Dear experts, >> >> I want mail from excel using gmail ID. I want to mail from data sheet by >> filtering data of mail receivers. I find the code using google search as >> mention below but it's error occur of "The transport failed to connect to >> the server." during the running code. Kindly help me regarding this matter. >> >> >> Sub CDO_Mail_Small_Text_2() >> Dim iMsg As Object >> Dim iConf As Object >> Dim strbody As String >> Dim Flds As Variant >> >> Set iMsg = CreateObject("CDO.Message") >> Set iConf = CreateObject("CDO.Configuration") >> >> iConf.Load -1' CDO Source Defaults >> Set Flds = iConf.Fields >> With Flds >> .Item("http://schemas.microsoft.com/cdo/configuration/smtpusessl";) >> = True >> .Item(" >> http://schemas.microsoft.com/cdo/configuration/smtpauthenticate";) = 1 >> .Item(" >> http://schemas.microsoft.com/cdo/configuration/sendusername";) = "Full >> GMail mail address" >> .Item(" >> http://schemas.microsoft.com/cdo/configuration/sendpassword";) = "GMail >> password" >> .Item("http://schemas.microsoft.com/cdo/configuration/smtpserver";) >> = "smtp.gmail.com" >> >> .Item("http://schemas.microsoft.com/cdo/configuration/sendusing";) >> = 2 >> .Item(" >> http://schemas.microsoft.com/cdo/configuration/smtpserverport";) = 25 >> .Update >> End With >> >> strbody = "Hi there" & vbNewLine & vbNewLine & _ >> "This is line 1" & vbNewLine & _ >> "This is line 2" & vbNewLine & _ >> "This is line 3" & vbNewLine & _ >> "This is line 4" >> >> With iMsg >> Set .Configuration = iConf >> .To = "Mail address receiver" >> .CC = "" >> .BCC = "" >> ' Note: The reply address is not working if you use this Gmail >> example >> ' It will use your Gmail address automatic. But you can add this >> line >> ' to change the reply address .ReplyTo = "re...@something.nl" >> .From = """YourName"" " >> .Subject = "Important message" >> .TextBody = strbody >> .Send >> End With >> >> End Sub >> >> 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.
$$Excel-Macros$$ Mail from excel using gmail
Dear experts, I want mail from excel using gmail ID. I want to mail from data sheet by filtering data of mail receivers. I find the code using google search as mention below but it's error occur of "The transport failed to connect to the server." during the running code. Kindly help me regarding this matter. Sub CDO_Mail_Small_Text_2() Dim iMsg As Object Dim iConf As Object Dim strbody As String Dim Flds As Variant Set iMsg = CreateObject("CDO.Message") Set iConf = CreateObject("CDO.Configuration") iConf.Load -1' CDO Source Defaults Set Flds = iConf.Fields With Flds .Item("http://schemas.microsoft.com/cdo/configuration/smtpusessl";) = True .Item(" http://schemas.microsoft.com/cdo/configuration/smtpauthenticate";) = 1 .Item("http://schemas.microsoft.com/cdo/configuration/sendusername";) = "Full GMail mail address" .Item("http://schemas.microsoft.com/cdo/configuration/sendpassword";) = "GMail password" .Item("http://schemas.microsoft.com/cdo/configuration/smtpserver";) = "smtp.gmail.com" .Item("http://schemas.microsoft.com/cdo/configuration/sendusing";) = 2 .Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport";) = 25 .Update End With strbody = "Hi there" & vbNewLine & vbNewLine & _ "This is line 1" & vbNewLine & _ "This is line 2" & vbNewLine & _ "This is line 3" & vbNewLine & _ "This is line 4" With iMsg Set .Configuration = iConf .To = "Mail address receiver" .CC = "" .BCC = "" ' Note: The reply address is not working if you use this Gmail example ' It will use your Gmail address automatic. But you can add this line ' to change the reply address .ReplyTo = "re...@something.nl" .From = """YourName"" " .Subject = "Important message" .TextBody = strbody .Send End With End Sub 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$$ Function for Data validataion
Thanks Mr. Paul for excellent easy condition and your description to understand the issue everytime is also excellent. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Mon, Mar 2, 2015 at 8:08 PM, Paul Schreiner wrote: > OK, this solution attempts to convert each of the first 4 > characters to an integer. > If the character is alphabetic, INT() produces an error. > (#VALUE!) > So, if INT() produces an error, ISERROR() results in "true" > > So, for each of the first 4 characters, ISERROR should be "true": > > > =AND(LEN(B8)=11, > ISNUMBER(INT(RIGHT(B8,7))), > EXACT(B8,UPPER(B8)), > ISERROR(INT(MID(B8,1,1))), > ISERROR(INT(MID(B8,2,1))), > ISERROR(INT(MID(B8,3,1))), > ISERROR(INT(MID(B8,4,1 > > *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* > - > >*From:* Paul Schreiner > *To:* "excel-macros@googlegroups.com" > *Sent:* Monday, March 2, 2015 9:31 AM > > *Subject:* Re: $$Excel-Macros$$ Function for Data validataion > > OOps... sorry. > ISTEXT() isn't working because 1abc is considered "text", > so istext(left(B8,1)) evaluates to "true". > > I'll look again and get back to you. > > *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* > - > >*From:* Paul Schreiner > *To:* "excel-macros@googlegroups.com" > *Sent:* Monday, March 2, 2015 9:22 AM > *Subject:* Re: $$Excel-Macros$$ Function for Data validataion > > There's not going to be a lot we can do to make it "simpler" > But we might be able to make it easier to read. > > first: Did you know you can use Alt-Enter to insert a "carriage return" > in the formula? > > That way, the formula isn't in one long line and you can break it up > logically. > > Second, You evidently want to test to ensure the alpha characters are > CAPS, for that, you can use: > EXACT() and compare the value to the upper() value of the cell: > > EXACT(B8,UPPER(B8)) > > I cannot think of any other way to check the first four characters except > to check them individually. > > At least this option reduces the tests from 10 to 7! > > =AND(LEN(B8)=11, > ISNUMBER(INT(RIGHT(B8,7))), > EXACT(B8,UPPER(B8)), > ISTEXT(MID(B8,1,1)), > ISTEXT(MID(B8,2,1)), > ISTEXT(MID(B8,3,1)), > ISTEXT(MID(B8,4,1))) > > *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* > - > >*From:* Ashish Bhalara > *To:* excel-macros@googlegroups.com > *Sent:* Saturday, February 28, 2015 5:15 AM > *Subject:* Re: $$Excel-Macros$$ Function for Data validataion > > Hi Mr.Paul > I make below condition to check first four character is Alphabetic. > > > =AND(LEN(B8)=11,ISNUMBER(INT(RIGHT(B8,7))),CODE(LEFT(B8,1))>64,CODE(LEFT(B8,1))<91,CODE(MID(B8,2,1))>64,CODE(MID(B8,2,1))<91,CODE(MID(B8,3,1))>64,CODE(MID(B8,3,1))<91,CODE(MID(B8,4,1))>64,CODE(MID(B8,4,1))<91) > > Could you please make it short or easy. > > Regards. > Ashish Bhalara > 9624111822 > P*Please do not print this email unless it is absolutely necessary. > Spread environmental üawareness.♣♣♣* > > > On Sat, Feb 28, 2015 at 11:19 AM, Ashish Bhalara < > ashishbhalar...@gmail.com> wrote: > > Dear Mr.Paul, Thanks to reply. > But problem of third criteria is still not fulfill as per your condition > of 'ISTEXT(MID(A1,1,1)' > The output is same 'TRUE' whether entered value is alpha or numeric. > Please give me a solution for it or macro also preferred if possible. > > Regards. > Ashish Bhalara > 9624111822 > P*Please do not print this email unless it is absolutely necessary. > Spread environmental üawareness.♣♣♣* > > > On Fri, Feb 27, 2015 at 6:45 PM, Paul Schreiner > wrote: > > If the cell you're validating is A1, with the current
Re: $$Excel-Macros$$ Re: Query in IF formula on sheet deactivation event
Thanks Mr.Michael, it's work. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Sun, Mar 1, 2015 at 11:08 PM, michael vinoth wrote: > Hi Ashish, > > Please find the attached macro file. > > Regards, > MV > > On Saturday, February 28, 2015 at 5:04:35 PM UTC+5:30, Ashish_Bhalara > wrote: >> >> Dear expert, >> >> I need help in attached file in which if cheque amount is greater than >> zero and date & cheque number field Blank then msgbox should display, and >> when cheque amount is blank, no any msgbox should display. >> >> In my case and as per my formula the msgbox display even cheque amt. >> field is zero. >> >> Kindly see attached file to solve my query, I tried different way in >> codding but did't get result. >> >> 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. > -- 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$$ Query in IF formula on sheet deactivation event
Dear expert, I need help in attached file in which if cheque amount is greater than zero and date & cheque number field Blank then msgbox should display, and when cheque amount is blank, no any msgbox should display. In my case and as per my formula the msgbox display even cheque amt. field is zero. Kindly see attached file to solve my query, I tried different way in codding but did't get result. 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. Query VBA If formula.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Function for Data validataion
Hi Mr.Paul I make below condition to check first four character is Alphabetic. =AND(LEN(B8)=11,ISNUMBER(INT(RIGHT(B8,7))),CODE(LEFT(B8,1))>64,CODE(LEFT(B8,1))<91,CODE(MID(B8,2,1))>64,CODE(MID(B8,2,1))<91,CODE(MID(B8,3,1))>64,CODE(MID(B8,3,1))<91,CODE(MID(B8,4,1))>64,CODE(MID(B8,4,1))<91) Could you please make it short or easy. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Sat, Feb 28, 2015 at 11:19 AM, Ashish Bhalara wrote: > Dear Mr.Paul, Thanks to reply. > But problem of third criteria is still not fulfill as per your condition > of 'ISTEXT(MID(A1,1,1)' > The output is same 'TRUE' whether entered value is alpha or numeric. > Please give me a solution for it or macro also preferred if possible. > > Regards. > Ashish Bhalara > 9624111822 > P*Please do not print this email unless it is absolutely necessary. > Spread environmental üawareness.♣♣♣* > > > On Fri, Feb 27, 2015 at 6:45 PM, Paul Schreiner > wrote: > >> If the cell you're validating is A1, with the current value of: >> abcd1234567 >> - >> Your first criteria is easy: >> Len(A1)=11 >> - >> The second criteria: "last 7 characters are numeric" >> CAN be fairly simple, depending on your definition of "numeric". >> right(A1,7) gives you the last 7 characters. >> "normallY", ISNUMBER() would tell you if the characters are numeric. >> But for some reason, since your cell value is alphanumeric, >> Excel considers the last 7 characters as "text" and therefore, >> ISNUMBER(RIGHT(A1,7)) would return FALSE. >> So, you have to convert it to an number. >> you can either use: INT(RIGHT(A1,7)) or RIGHT(A1,7)*1 >> >> I chose ISNUMBER(RIGHT(A2,7)*1) >> >> Now, as the to your definition of "numeric": >> To Excel all of these are 7 digit "numerics": >> 1234567 >> .123456 >> 123.456 >> 123456% >> >> If that is acceptable, than all is well and good, if NOT >> then we'll have to work on testing each individual character >> to see if it is between 0 and 9. >> - >> Your third criteria: "the first 4 characters as alpha" >> requires testing each character separately. >> To extract the character, you can use the MID() function >> >> MID(A1,4,1) extracts the fourth character >> MID(A1,3,1) extracts the third character >> MID(A1,2,1) extracts the second character. >> MID(A1,1,1) extract the first character >> (you COULD use LEFT(A1,1) but to keep it looking the same, I prefer to >> use MID()) >> >> Now, to test to see if it is alpha, use ISTEXT() >> Resulting in: ISTEXT(MID(A1,1,1)) >> - >> >> Now, for the validation formula, each of these criteria must be met. >> By combining them, you get: >> >> =AND(LEN(A1)=11, >> ISNUMBER(INT(RIGHT(A1,7))), >> ISTEXT(MID(A1,1,1)), >> ISTEXT(MID(A1,2,1)), >> ISTEXT(MID(A1,3,1)), >> ISTEXT(MID(A1,4,1)) >> ) >> >> Hope this helps >> >> *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* >> - >> >>*From:* Ashish Bhalara >> *To:* excel-macros@googlegroups.com >> *Sent:* Thursday, February 26, 2015 10:50 PM >> *Subject:* $$Excel-Macros$$ Function for Data validataion >> >> Dear experts, >> >> I want to formula for data validation to fulfill below conditions. >> >> >>1. Total character should be 11 degit >>2. Last 7 character should be numeric >>3. First 4 character should be Alphabatic (A to Z) >> >> Please see attached file in which 3rd criteria I can't make it. >> 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 Hel
Re: $$Excel-Macros$$ Function for Data validataion
Dear Mr.Paul, Thanks to reply. But problem of third criteria is still not fulfill as per your condition of 'ISTEXT(MID(A1,1,1)' The output is same 'TRUE' whether entered value is alpha or numeric. Please give me a solution for it or macro also preferred if possible. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Fri, Feb 27, 2015 at 6:45 PM, Paul Schreiner wrote: > If the cell you're validating is A1, with the current value of: > abcd1234567 > - > Your first criteria is easy: > Len(A1)=11 > - > The second criteria: "last 7 characters are numeric" > CAN be fairly simple, depending on your definition of "numeric". > right(A1,7) gives you the last 7 characters. > "normallY", ISNUMBER() would tell you if the characters are numeric. > But for some reason, since your cell value is alphanumeric, > Excel considers the last 7 characters as "text" and therefore, > ISNUMBER(RIGHT(A1,7)) would return FALSE. > So, you have to convert it to an number. > you can either use: INT(RIGHT(A1,7)) or RIGHT(A1,7)*1 > > I chose ISNUMBER(RIGHT(A2,7)*1) > > Now, as the to your definition of "numeric": > To Excel all of these are 7 digit "numerics": > 1234567 > .123456 > 123.456 > 123456% > > If that is acceptable, than all is well and good, if NOT > then we'll have to work on testing each individual character > to see if it is between 0 and 9. > - > Your third criteria: "the first 4 characters as alpha" > requires testing each character separately. > To extract the character, you can use the MID() function > > MID(A1,4,1) extracts the fourth character > MID(A1,3,1) extracts the third character > MID(A1,2,1) extracts the second character. > MID(A1,1,1) extract the first character > (you COULD use LEFT(A1,1) but to keep it looking the same, I prefer to use > MID()) > > Now, to test to see if it is alpha, use ISTEXT() > Resulting in: ISTEXT(MID(A1,1,1)) > - > > Now, for the validation formula, each of these criteria must be met. > By combining them, you get: > > =AND(LEN(A1)=11, > ISNUMBER(INT(RIGHT(A1,7))), > ISTEXT(MID(A1,1,1)), > ISTEXT(MID(A1,2,1)), > ISTEXT(MID(A1,3,1)), > ISTEXT(MID(A1,4,1)) > ) > > Hope this helps > > *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* > - > >*From:* Ashish Bhalara > *To:* excel-macros@googlegroups.com > *Sent:* Thursday, February 26, 2015 10:50 PM > *Subject:* $$Excel-Macros$$ Function for Data validataion > > Dear experts, > > I want to formula for data validation to fulfill below conditions. > > >1. Total character should be 11 degit >2. Last 7 character should be numeric >3. First 4 character should be Alphabatic (A to Z) > > Please see attached file in which 3rd criteria I can't make it. > 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.
Fwd: $$Excel-Macros$$ Function for Data validataion
-- Forwarded message -- From: Ashish Bhalara Date: Fri, Feb 27, 2015 at 9:20 AM Subject: $$Excel-Macros$$ Function for Data validataion To: excel-macros@googlegroups.com Dear experts, I want to formula for data validation to fulfill below conditions. 1. Total character should be 11 degit 2. Last 7 character should be numeric 3. First 4 character should be Alphabatic (A to Z) Please see attached file in which 3rd criteria I can't make it. 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. -- 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. query data validation.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Function for Data validataion
Dear experts, I want to formula for data validation to fulfill below conditions. 1. Total character should be 11 degit 2. Last 7 character should be numeric 3. First 4 character should be Alphabatic (A to Z) Please see attached file in which 3rd criteria I can't make it. 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. query data validation.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Please solve this
Hello, Kindly explain particular detail what result you need, there are not any logic fulfill from your sum in output, though I try to understand your output and solve it, see attached file. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Tue, Feb 24, 2015 at 1:01 PM, Sushma David wrote: > > -- > 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 Solve.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Page footer for last page only.
Dear sir, Kindly suggest to written texts in footer on last page only in excel, if page more than one and print on first page if only one page to print. 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$$ Require function for lookup value on condition.
Thanks Mr.Vaibhav & Mr.Sandeep, that's exactly what i need:) Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Mon, Feb 9, 2015 at 10:39 AM, Sandeep Sharma wrote: > Thanks Vaibhav. Sir, I want to learn VBA so, suggest me where from start. > > With Regards > Sandeep Kumar Sharma > > *“Always laugh when you can. It is cheap medicine.*” > > On Sun, Feb 8, 2015 at 10:39 PM, Vaibhav Joshi wrote: > >> really good Sandeep >> >> >> On Sun, Feb 8, 2015 at 3:37 PM, Sandeep Sharma < >> sandeepsharma4...@gmail.com> wrote: >> >>> Kindly check this Non-Array solution. >>> >>> >>> >>> With Regards >>> Sandeep Kumar Sharma >>> >>> *“Always laugh when you can. It is cheap medicine.*” >>> >>> On Sat, Feb 7, 2015 at 9:26 PM, Vaibhav Joshi wrote: >>> >>>> Check this... >>>> >>>> On Fri, Feb 6, 2015 at 11:08 AM, Ashish Bhalara < >>>> ashishbhalar...@gmail.com> wrote: >>>> >>>>> Dear experts, >>>>> >>>>> I require function to lookup value on consider of two particular >>>>> condition. >>>>> Pls. see attached file for example. >>>>> >>>>> 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. >>>>> >>>> >>>> -- >>>> 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 >>>> a
$$Excel-Macros$$ Require function for lookup value on condition.
Dear experts, I require function to lookup value on consider of two particular condition. Pls. see attached file for example. 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. query of lookup value.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ problem in code fpr data copied from text to number format
Thank you Mr.Paul to suggest me best in coding. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Tue, Feb 3, 2015 at 5:50 PM, Paul Schreiner wrote: > The problem is: > When you insert a row in your table, column "D" doesn't "inherit" the > properties of the previous row, but instead reverts to the "General" format > of the rest of the column. > > There's a couple ways of handling this. > I tried both and they both seem to work: > > Select the entire column "D" and change the format to "Text". > > add this statement: > > Worksheets("BankData").Cells(NewRow, 4).NumberFormat = "@" > (prior to: > Worksheets("BankData").Cells(NewRow, 4).Value = ano > > > (I found this by recording a macro, in which I changed the cell format to > "Text") > > > also: > > in your macro, when you're looking for a blank row, there's LOTS of ways > to do this, of course, but your loop should look more like: > > > For NewRow = 5 To 1000 > If Worksheets("BankData").Cells(NewRow, "A").Value = "" Then > Exit For > End If > Next NewRow > > hope this helps, > > *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* > - > >*From:* Ashish Bhalara > *To:* excel-macros@googlegroups.com > *Sent:* Tuesday, February 3, 2015 1:02 AM > *Subject:* $$Excel-Macros$$ problem in code fpr data copied from text to > number format > > Dear experts, > > Please see attached file in which account no. field is text format but > copied in number format. Problem is that when I type 0123, data copied at > 123 as per my coding, I also try by define variable as string but problem > same as standing. > > Please edit my code to solve this issue. > > 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. > > >-- > 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 rec
$$Excel-Macros$$ problem in code fpr data copied from text to number format
Dear experts, Please see attached file in which account no. field is text format but copied in number format. Problem is that when I type 0123, data copied at 123 as per my coding, I also try by define variable as string but problem same as standing. Please edit my code to solve this issue. 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. query of text to number format.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Loop to check duplicate value
I have to remove q = q + 1 to check every line. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Mon, Feb 2, 2015 at 6:17 PM, Ashish Bhalara wrote: > Thank you very much Mr.Paul, my solution is in your last line. > > Regards. > Ashish Bhalara > 9624111822 > P*Please do not print this email unless it is absolutely necessary. > Spread environmental üawareness.♣♣♣* > > > On Mon, Feb 2, 2015 at 6:04 PM, Paul Schreiner > wrote: > >> From what I can see, you're looking in rows 5 to 1000 >> and comparing the value in column (D) to the value in cell B7. >> >> If you use the debugger to step through one line at a time and watch your >> value for "q", >> you'll see that the loop: >> >> For q = 5 to 1000 >> increments q by 1 for each iteration of the loop. >> (if you wanted it to do every THIRD row, you could use for q=5 to 1000 >> step 3) >> >> that means, that it runs through with q =5, >> then q=6, q=7, and so on. >> >> But within your loop, you have q=q+1 >> >> that means that it will start with q=5, >> then, q=q+1 makes q=6, >> but the for q=5 to 1000 statement will then increment q to 7! >> >> So, your loop is only checking q=5,7,9,11, etc. >> >> if you want it to check all rows, remove the line: q = q + 1 >> >> >> *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* >> - >> >>*From:* Ashish Bhalara >> *To:* excel-macros@googlegroups.com >> *Sent:* Monday, February 2, 2015 6:14 AM >> *Subject:* $$Excel-Macros$$ Loop to check duplicate value >> >> Dear experts, >> >> Below code is not work to check duplicate value, please know me problem >> in code. >> >> For q = 5 To 1000 >> If Worksheets("BankData").Cells(q, 4).Value = >> Worksheets("NewEntry").Cells(7, 2).Value Then >> MsgBox "Account number already exist", vbOKOnly, "Ashish" >> Exit Sub >> End If >> q = q + 1 >> >> Next q >> >> >> 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. >> >> >>-- >> 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
Re: $$Excel-Macros$$ Loop to check duplicate value
Thank you very much Mr.Paul, my solution is in your last line. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Mon, Feb 2, 2015 at 6:04 PM, Paul Schreiner wrote: > From what I can see, you're looking in rows 5 to 1000 > and comparing the value in column (D) to the value in cell B7. > > If you use the debugger to step through one line at a time and watch your > value for "q", > you'll see that the loop: > > For q = 5 to 1000 > increments q by 1 for each iteration of the loop. > (if you wanted it to do every THIRD row, you could use for q=5 to 1000 > step 3) > > that means, that it runs through with q =5, > then q=6, q=7, and so on. > > But within your loop, you have q=q+1 > > that means that it will start with q=5, > then, q=q+1 makes q=6, > but the for q=5 to 1000 statement will then increment q to 7! > > So, your loop is only checking q=5,7,9,11, etc. > > if you want it to check all rows, remove the line: q = q + 1 > > > *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* > - > >*From:* Ashish Bhalara > *To:* excel-macros@googlegroups.com > *Sent:* Monday, February 2, 2015 6:14 AM > *Subject:* $$Excel-Macros$$ Loop to check duplicate value > > Dear experts, > > Below code is not work to check duplicate value, please know me problem in > code. > > For q = 5 To 1000 > If Worksheets("BankData").Cells(q, 4).Value = > Worksheets("NewEntry").Cells(7, 2).Value Then > MsgBox "Account number already exist", vbOKOnly, "Ashish" > Exit Sub > End If > q = q + 1 > > Next q > > > 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. > > >-- > 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. &
Re: $$Excel-Macros$$ Copy & Paste only particular to another sheet
Thank you very muc Mr.Vaibhav & Mr.Gaurav Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Mon, Feb 2, 2015 at 5:58 PM, Gaurav Devrani wrote: > And Please check the filter again. I guess I dint put that filter on the > entire sheet. Please select true values as well and then filter it again. > Sorry for the wrong file. > > On Mon, Feb 2, 2015 at 5:24 AM, Gaurav Devrani > wrote: > >> :) >> >> On Mon, Feb 2, 2015 at 5:22 AM, Vaibhav Joshi wrote: >> >>> Great Tip by Gaurav.. >>> >>> On Mon, Feb 2, 2015 at 5:49 PM, Gaurav Devrani >>> wrote: >>> >>>> Please check the attached file, Let me know If I am missing on >>>> something. I guess you were trying to copy only those rows. which contains >>>> no error.. if not. let me know. >>>> >>>> >>>> Regards >>>> Gaurav >>>> >>>> On Mon, Feb 2, 2015 at 5:09 AM, Ashish Bhalara < >>>> ashishbhalar...@gmail.com> wrote: >>>> >>>>> Dear Vaibhavji, >>>>> >>>>> Thanks to reply, my query to check duplicate value is solved, i was >>>>> wrong in variable defination. >>>>> >>>>> My other query is that I have sheet containing formulas. I want copy & >>>>> paste only those cell which not containing error. Please see attached file >>>>> for data. >>>>> >>>>> Regards. >>>>> Ashish Bhalara >>>>> 9624111822 >>>>> P*Please do not print this email unless it is absolutely necessary. >>>>> Spread environmental üawareness.♣♣♣* >>>>> >>>>> >>>>> On Mon, Feb 2, 2015 at 5:30 PM, Vaibhav Joshi wrote: >>>>> >>>>>> Dear Ashish Bhalara >>>>>> >>>>>> What exactly you are doing, can you pl explain.. >>>>>> >>>>>> On Mon, Feb 2, 2015 at 4:44 PM, Ashish Bhalara < >>>>>> ashishbhalar...@gmail.com> wrote: >>>>>> >>>>>>> Dear experts, >>>>>>> >>>>>>> Below code is not work to check duplicate value, please know me >>>>>>> problem in code. >>>>>>> >>>>>>> For q = 5 To 1000 >>>>>>> If Worksheets("BankData").Cells(q, 4).Value = >>>>>>> Worksheets("NewEntry").Cells(7, 2).Value Then >>>>>>> MsgBox "Account number already exist", vbOKOnly, "Ashish" >>>>>>> Exit Sub >>>>>>> End If >>>>>>> q = q + 1 >>>>>>> >>>>>>> Next q >>>>>>> >>>>>>> >>>>>>> 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
$$Excel-Macros$$ Copy & Paste only particular to another sheet
Dear Vaibhavji, Thanks to reply, my query to check duplicate value is solved, i was wrong in variable defination. My other query is that I have sheet containing formulas. I want copy & paste only those cell which not containing error. Please see attached file for data. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Mon, Feb 2, 2015 at 5:30 PM, Vaibhav Joshi wrote: > Dear Ashish Bhalara > > What exactly you are doing, can you pl explain.. > > On Mon, Feb 2, 2015 at 4:44 PM, Ashish Bhalara > wrote: > >> Dear experts, >> >> Below code is not work to check duplicate value, please know me problem >> in code. >> >> For q = 5 To 1000 >> If Worksheets("BankData").Cells(q, 4).Value = >> Worksheets("NewEntry").Cells(7, 2).Value Then >> MsgBox "Account number already exist", vbOKOnly, "Ashish" >> Exit Sub >> End If >> q = q + 1 >> >> Next q >> >> >> 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. >> > > -- > 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 an
Re: $$Excel-Macros$$ Loop to check duplicate value
Please tell me what's wrong in code. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Mon, Feb 2, 2015 at 4:57 PM, Sunil Kumar Yadav wrote: > Hello Friends, > > i have checked many chart of Mr. Chandoo...he used two or three range in > series value in one series in selected data source...i mean please look > below snapshot. > > i want to know how i can select similiarly range in my data...i use window > 2007. > > Please!!! > > [image: Inline image 1] > > -- > Thanks > *Sunil Kumar Yadav* > > On Mon, Feb 2, 2015 at 4:44 PM, Ashish Bhalara > wrote: > >> Dear experts, >> >> Below code is not work to check duplicate value, please know me problem >> in code. >> >> For q = 5 To 1000 >> If Worksheets("BankData").Cells(q, 4).Value = >> Worksheets("NewEntry").Cells(7, 2).Value Then >> MsgBox "Account number already exist", vbOKOnly, "Ashish" >> Exit Sub >> End If >> q = q + 1 >> >> Next q >> >> >> 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. >> > > -- > 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
$$Excel-Macros$$ Loop to check duplicate value
Dear experts, Below code is not work to check duplicate value, please know me problem in code. For q = 5 To 1000 If Worksheets("BankData").Cells(q, 4).Value = Worksheets("NewEntry").Cells(7, 2).Value Then MsgBox "Account number already exist", vbOKOnly, "Ashish" Exit Sub End If q = q + 1 Next q 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$$ Wrong entry of a number
Yes, I doing same, but is there any solution to type in number format more than 15 digit? Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Fri, Jan 30, 2015 at 3:50 PM, Vaibhav Joshi wrote: > Hi > > Excel allows entry upto 15 digits & there should not be any problem with > entering 296100210001856 > > You mat add ' before number if you want to store digits more than 15. > > Cheers!! > ᐧ > > On Fri, Jan 30, 2015 at 3:48 PM, Ashish Bhalara > wrote: > >> I checked it in version of 2007 & 2003. >> And also checked same sheet by opening in another PCs and also by >> creating new sheet. >> >> Regards. >> Ashish Bhalara >> 9624111822 >> P*Please do not print this email unless it is absolutely necessary. >> Spread environmental üawareness.♣♣♣* >> >> >> On Fri, Jan 30, 2015 at 3:36 PM, Vaibhav Joshi wrote: >> >>> what is your MS office version? >>> ᐧ >>> >>> On Fri, Jan 30, 2015 at 3:24 PM, Ashish Bhalara < >>> ashishbhalar...@gmail.com> wrote: >>> >>>> I did it same also but though problem remaining same. >>>> >>>> Regards. >>>> Ashish Bhalara >>>> 9624111822 >>>> P*Please do not print this email unless it is absolutely necessary. >>>> Spread environmental üawareness.♣♣♣* >>>> >>>> >>>> On Fri, Jan 30, 2015 at 2:46 PM, Vaibhav Joshi wrote: >>>> >>>>> Change cell format to number with zero decimal places.. >>>>> ᐧ >>>>> >>>>> On Fri, Jan 30, 2015 at 2:43 PM, Ashish Bhalara < >>>>> ashishbhalar...@gmail.com> wrote: >>>>> >>>>>> Dear experts, >>>>>> >>>>>> I enter number 296100210001856 in cell of excel in number format but >>>>>> after given enter the number change to 296100210001850. >>>>>> I checked all the way but not found any solution, pls check n reply >>>>>> for solution. >>>>>> >>>>>> 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. >>>>>> >>>>> >>>>> -- >>>>> 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
Re: $$Excel-Macros$$ Wrong entry of a number
I checked it in version of 2007 & 2003. And also checked same sheet by opening in another PCs and also by creating new sheet. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Fri, Jan 30, 2015 at 3:36 PM, Vaibhav Joshi wrote: > what is your MS office version? > ᐧ > > On Fri, Jan 30, 2015 at 3:24 PM, Ashish Bhalara > wrote: > >> I did it same also but though problem remaining same. >> >> Regards. >> Ashish Bhalara >> 9624111822 >> P*Please do not print this email unless it is absolutely necessary. >> Spread environmental üawareness.♣♣♣* >> >> >> On Fri, Jan 30, 2015 at 2:46 PM, Vaibhav Joshi wrote: >> >>> Change cell format to number with zero decimal places.. >>> ᐧ >>> >>> On Fri, Jan 30, 2015 at 2:43 PM, Ashish Bhalara < >>> ashishbhalar...@gmail.com> wrote: >>> >>>> Dear experts, >>>> >>>> I enter number 296100210001856 in cell of excel in number format but >>>> after given enter the number change to 296100210001850. >>>> I checked all the way but not found any solution, pls check n reply for >>>> solution. >>>> >>>> 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. >>>> >>> >>> -- >>> 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(
Re: $$Excel-Macros$$ Wrong entry of a number
I did it same also but though problem remaining same. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Fri, Jan 30, 2015 at 2:46 PM, Vaibhav Joshi wrote: > Change cell format to number with zero decimal places.. > ᐧ > > On Fri, Jan 30, 2015 at 2:43 PM, Ashish Bhalara > wrote: > >> Dear experts, >> >> I enter number 296100210001856 in cell of excel in number format but >> after given enter the number change to 296100210001850. >> I checked all the way but not found any solution, pls check n reply for >> solution. >> >> 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. >> > > -- > 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.
$$Excel-Macros$$ Wrong entry of a number
Dear experts, I enter number 296100210001856 in cell of excel in number format but after given enter the number change to 296100210001850. I checked all the way but not found any solution, pls check n reply for solution. 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$$ Data Copy from one sheet (or Form) to another sheet
Data copied perfectly as my requirement but not drag needed field as described in previous mail, I using loop for it but still not success, pls try to edit my code for it. Thanks. On 23-Jan-2015 7:04 PM, "Vaibhav Joshi" wrote: > Dear Ashish Bhalara, > > Is it resolved? > ᐧ > > On Sat, Jan 17, 2015 at 8:41 AM, Ashish Bhalara > wrote: > >> Thanks to reply Mr.Ashish Kumar, but my requirement in sheet is little >> different than write same data to another sheet. >> In my query sheet, the account entry in fields of Group, Account Ledgers, >> Dr. Cr. would be more than 2 row which should copied to another sheet and >> another fields OrderID, Date, VocherType also should drag till number of >> Ledgers mention in table. So main problem is that how to make code like >> that. Please also see my coding like that which occur some error it may be >> some basic mistake of variable define that's I can't got due to less of my >> basic knowledge, Please suggest. >> >> Regards. >> Ashish Bhalara >> 9624111822 >> P*Please do not print this email unless it is absolutely necessary. >> Spread environmental üawareness.♣♣♣* >> >> >> On Fri, Jan 16, 2015 at 10:05 PM, Ashish Kumar > > wrote: >> >>> Hi Ashish Bhalara, >>> >>> PFA >>> >>> >>> Regards >>> Ashish >>> >>> -- >>> 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
$$Excel-Macros$$ Problem Autofilter Date Range
Dear experts, I want automatic filtering of Date range in cell C11 but the below code is not work for Date Field, the output is hide to all data. Please suggest what are mistake in coding. Sub Custom2() Dim r As String Dim FDate As Date, Ldate As Date r = Range("j3").Value Range("D11").AutoFilter Field:=4, Criteria1:=r FDate = Range("J1") Ldate = Range("J2") Range("C11").AutoFilter Field:=3, Criteria1:=">=" & FDate, Operator:=xlAnd, Criteria2:="<=" & Ldate End Sub 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$$ Re: Need a Formula or Macro to pick-up values from other sheets
Thanks Mr.Ashish Kumar, your sharing file of ListPicker is very useful for me. :) Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Sat, Jan 17, 2015 at 9:32 PM, Ashish Kumar wrote: > PFA > > Regards > Ashish > > -- > 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$$ Data Copy from one sheet (or Form) to another sheet
Thanks to reply Mr.Ashish Kumar, but my requirement in sheet is little different than write same data to another sheet. In my query sheet, the account entry in fields of Group, Account Ledgers, Dr. Cr. would be more than 2 row which should copied to another sheet and another fields OrderID, Date, VocherType also should drag till number of Ledgers mention in table. So main problem is that how to make code like that. Please also see my coding like that which occur some error it may be some basic mistake of variable define that's I can't got due to less of my basic knowledge, Please suggest. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Fri, Jan 16, 2015 at 10:05 PM, Ashish Kumar wrote: > Hi Ashish Bhalara, > > PFA > > > Regards > Ashish > > -- > 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. query.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ Data Copy from one sheet (or Form) to another sheet
Dear experts, Please see the attached file in which data copy to Record sheet, there are error occur "Object Require", I can't understand. Kindly help for require out put as mention in Record sheet, also guide if it is possible to create Form for DataEntry sheet. 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. query.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ Macro for Autofilter
Dear experts, Please provide Macro for autofilter for criteria of Date range & exact matching of code as per in attached sheet. Column of C contain date and filter as per range given in J1 to J2. Second filter on column D with exact match in cell J4. 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. Autofilter Query.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Happy New 2015
A very very Happy New Year to all Group members. On Wed, Dec 31, 2014 at 7:54 PM, Vaibhav Joshi wrote: > Joyous January –Fabulous February > > Magical March –Adorable April > > Magnificent May –Jolly June > > Jubilant July –Awesome August > > ScintillatingSeptember –Outstanding October > > Naughty November –Dazzling December > > This is how I sincerely wish your New Year to be! > > Yu Year – Happy Year.. > > A Very Happy New Year 2015! To all group members. > > Cheers!! > > -- > 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$$ Need looping to hide row
Thank you very much...Cheers!! Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Tue, Dec 30, 2014 at 12:26 PM, Vaibhav Joshi wrote: > check this > > i m not getting any error.. > > + > *I did not do this for you. God is here working through me for you.* > > On Tue, Dec 30, 2014 at 10:29 AM, Ashish Bhalara < > ashishbhalar...@gmail.com> wrote: > >> I was wrong, error occur of 'Sub of Function not defined. >> >> Regards. >> Ashish Bhalara >> 9624111822 >> P*Please do not print this email unless it is absolutely necessary. >> Spread environmental üawareness.♣♣♣* >> >> >> On Tue, Dec 30, 2014 at 10:24 AM, Ashish Bhalara < >> ashishbhalar...@gmail.com> wrote: >> >>> Hi Vaibhavji, >>> >>> The Syntex error occur in IF formula. >>> >>> Regards. >>> Ashish Bhalara >>> 9624111822 >>> P*Please do not print this email unless it is absolutely necessary. >>> Spread environmental üawareness.♣♣♣* >>> >>> >>> On Mon, Dec 29, 2014 at 7:07 PM, Vaibhav Joshi wrote: >>> >>>> Hi >>>> >>>> Try this: >>>> >>>> Private Sub Worksheet_Change(ByVal Target As Range) >>>> Dim rng As Range, c As Range >>>> If Target.Cells.Count > 1 Or IsEmpty(Target) Then Exit Sub >>>> If Not Intersect(Target, Range("A16:A50")) Is Nothing Then >>>> Set rng = Range("A16:A150") >>>> For Each c In rng >>>> If c.Value = "" Then >>>> c.EntireRow.Hidden = True >>>> Else >>>> c.EntireRow.Hidden = False >>>> End If >>>> Next >>>> End If >>>> End Sub >>>> >>>> >>>> >>>> however you will be required to work with ..Workbook_SheetChange >>>> >>>> Cheers!! >>>> >>>> + >>>> *I did not do this for you. God is here working through me for you.* >>>> >>>> On Mon, Dec 29, 2014 at 5:32 PM, Ashish Bhalara < >>>> ashishbhalar...@gmail.com> wrote: >>>> >>>>> Dear experts, >>>>> >>>>> Kindly see below code to hide row if cell value is blank. I need >>>>> looping in this code to apply this code from row 16 to 50. Thanks in >>>>> advance. >>>>> >>>>> Private Sub Worksheet_Change(ByVal Target As Range) If >>>>> Range("A16").Value = "" Then Rows("16:16").EntireRow.Hidden >>>>> = True ElseIf Range("A16").Value <> "" Then >>>>> Rows("16:16").EntireRow.Hidden = False End If End Sub >>>>> >>>>> >>>>> 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 exc
Re: $$Excel-Macros$$ Need looping to hide row
I was wrong, error occur of 'Sub of Function not defined. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Tue, Dec 30, 2014 at 10:24 AM, Ashish Bhalara wrote: > Hi Vaibhavji, > > The Syntex error occur in IF formula. > > Regards. > Ashish Bhalara > 9624111822 > P*Please do not print this email unless it is absolutely necessary. > Spread environmental üawareness.♣♣♣* > > > On Mon, Dec 29, 2014 at 7:07 PM, Vaibhav Joshi wrote: > >> Hi >> >> Try this: >> >> Private Sub Worksheet_Change(ByVal Target As Range) >> Dim rng As Range, c As Range >> If Target.Cells.Count > 1 Or IsEmpty(Target) Then Exit Sub >> If Not Intersect(Target, Range("A16:A50")) Is Nothing Then >> Set rng = Range("A16:A150") >> For Each c In rng >> If c.Value = "" Then >> c.EntireRow.Hidden = True >> Else >> c.EntireRow.Hidden = False >> End If >> Next >> End If >> End Sub >> >> >> >> however you will be required to work with ..Workbook_SheetChange >> >> Cheers!! >> >> + >> *I did not do this for you. God is here working through me for you.* >> >> On Mon, Dec 29, 2014 at 5:32 PM, Ashish Bhalara < >> ashishbhalar...@gmail.com> wrote: >> >>> Dear experts, >>> >>> Kindly see below code to hide row if cell value is blank. I need looping >>> in this code to apply this code from row 16 to 50. Thanks in advance. >>> >>> Private Sub Worksheet_Change(ByVal Target As Range) If >>> Range("A16").Value = "" Then Rows("16:16").EntireRow.Hidden = >>> True ElseIf Range("A16").Value <> "" Then >>> Rows("16:16").EntireRow.Hidden = False End If End Sub >>> >>> >>> 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. >>> >> >> -- >> 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 be
Re: $$Excel-Macros$$ Need looping to hide row
Hi Vaibhavji, The Syntex error occur in IF formula. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Mon, Dec 29, 2014 at 7:07 PM, Vaibhav Joshi wrote: > Hi > > Try this: > > Private Sub Worksheet_Change(ByVal Target As Range) > Dim rng As Range, c As Range > If Target.Cells.Count > 1 Or IsEmpty(Target) Then Exit Sub > If Not Intersect(Target, Range("A16:A50")) Is Nothing Then > Set rng = Range("A16:A150") > For Each c In rng > If c.Value = "" Then > c.EntireRow.Hidden = True > Else > c.EntireRow.Hidden = False > End If > Next > End If > End Sub > > > > however you will be required to work with ..Workbook_SheetChange > > Cheers!! > > +++++ > *I did not do this for you. God is here working through me for you.* > > On Mon, Dec 29, 2014 at 5:32 PM, Ashish Bhalara > wrote: > >> Dear experts, >> >> Kindly see below code to hide row if cell value is blank. I need looping >> in this code to apply this code from row 16 to 50. Thanks in advance. >> >> Private Sub Worksheet_Change(ByVal Target As Range) If >> Range("A16").Value = "" Then Rows("16:16").EntireRow.Hidden = >> True ElseIf Range("A16").Value <> "" Then >> Rows("16:16").EntireRow.Hidden = False End If End Sub >> >> >> 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. >> > > -- > 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 Pro
$$Excel-Macros$$ Need looping to hide row
Dear experts, Kindly see below code to hide row if cell value is blank. I need looping in this code to apply this code from row 16 to 50. Thanks in advance. Private Sub Worksheet_Change(ByVal Target As Range) If Range("A16").Value = "" Then Rows("16:16").EntireRow.Hidden = True ElseIf Range("A16").Value <> "" Then Rows("16:16").EntireRow.Hidden = False End If End Sub 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.
$$Excel-Macros$$ Help on coding to change cell value after every printing
Dear experts, I need to change cell value on every looping in below mention code. Sub PrintForms() Dim StartRow As Integer Dim EndRow As Integer Dim Msg As String Dim i As Integer Sheets("Form").Activate StartRow = Range("StartRow") EndRow = Range("EndRow") If StartRow > EndRow Then Msg = "ERROR" & vbCrLf & "The starting row must be less than the ending row!" MsgBox Msg, vbCritical, APPNAME End If For i = StartRow To EndRow Range("RowIndex") = i * ' Need logic for RowIndex cell value start from L12 (from attached sheet) and loop till EndRow (L13, L14, .)* If Range("Preview") Then ActiveSheet.PrintPreview Else ActiveSheet.PrintOut End If Next i End Sub Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Forwarded message -- From: Ashish Bhalara Date: Fri, Dec 26, 2014 at 5:41 PM Subject: $$Excel-Macros$$ Help on coding to change cell value after every printing To: excel-macros@googlegroups.com Dear experts, I want to change cell value on every automatic printing as per series given, please see attached file in which describe in detail. 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. -- 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. query.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Help on coding to change cell value after every printing
Dear experts, I want to change cell value on every automatic printing as per series given, please see attached file in which describe in detail. 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. query.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Need function help for output of particular list on matching data
Thanks... you are always rock in excel..Cheers!! Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Thu, Dec 25, 2014 at 10:50 PM, Vaibhav Joshi wrote: > Hi > > Check this... > > Cheers!! > > + > *I did not do this for you. God is here working through me for you.* > > On Thu, Dec 25, 2014 at 10:41 AM, Ashish Bhalara < > ashishbhalar...@gmail.com> wrote: > >> Hello Mr.Vaibhav >> >> As per trial mail, you solved my function query to display data on >> matching code, but could you please edit this function to display only >> those data which matching with code & Date, example is mention in attached >> sheet. >> >> Regards. >> Ashish Bhalara >> 9624111822 >> P*Please do not print this email unless it is absolutely necessary. >> Spread environmental üawareness.♣♣♣* >> >> >> On Tue, Dec 23, 2014 at 2:57 PM, Vaibhav Joshi wrote: >> >>> Cheers!! >>> >>> + >>> *I did not do this for you. God is here working through me for you.* >>> >>> On Tue, Dec 23, 2014 at 2:51 PM, Ashish Bhalara < >>> ashishbhalar...@gmail.com> wrote: >>> >>>> Hi Mr.Vaibhav >>>> Ones again thank you so much for your tremendous job to help me. >>>> >>>> Regards. >>>> Ashish Bhalara >>>> 9624111822 >>>> P*Please do not print this email unless it is absolutely necessary. >>>> Spread environmental üawareness.♣♣♣* >>>> >>>> >>>> On Tue, Dec 23, 2014 at 2:31 PM, Vaibhav Joshi wrote: >>>> >>>>> Hi >>>>> >>>>> check this.. >>>>> >>>>> Cheers!! >>>>> >>>>> + >>>>> *I did not do this for you. God is here working through me for you.* >>>>> >>>>> On Tue, Dec 23, 2014 at 11:17 AM, Ashish Bhalara < >>>>> ashishbhalar...@gmail.com> wrote: >>>>> >>>>>> Dear experts, >>>>>> >>>>>> I try below function to get output from other sheet on matching data >>>>>> written in L1 in sheet of 'Letter'. But this function is not working and >>>>>> I'm not able to understand error. >>>>>> >>>>>> >>>>>> {=INDEX(Func.Query.xlsm!InvNo,SMALL(IF(INT(SaleData!$A$2:$A$100)=$L$1,ROW(SaleData!$A$2:$A$100)-ROW(SaleData!$A$2)+2),ROWS($B$22:B22)))} >>>>>> >>>>>> Please see attached file for better understanding, kindly solve this >>>>>> query, thanks in Advance. >>>>>> >>>>>> 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
$$Excel-Macros$$ Need function help for output of particular list on matching data
Hello Mr.Vaibhav As per trial mail, you solved my function query to display data on matching code, but could you please edit this function to display only those data which matching with code & Date, example is mention in attached sheet. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Tue, Dec 23, 2014 at 2:57 PM, Vaibhav Joshi wrote: > Cheers!! > > + > *I did not do this for you. God is here working through me for you.* > > On Tue, Dec 23, 2014 at 2:51 PM, Ashish Bhalara > wrote: > >> Hi Mr.Vaibhav >> Ones again thank you so much for your tremendous job to help me. >> >> Regards. >> Ashish Bhalara >> 9624111822 >> P*Please do not print this email unless it is absolutely necessary. >> Spread environmental üawareness.♣♣♣* >> >> >> On Tue, Dec 23, 2014 at 2:31 PM, Vaibhav Joshi wrote: >> >>> Hi >>> >>> check this.. >>> >>> Cheers!! >>> >>> + >>> *I did not do this for you. God is here working through me for you.* >>> >>> On Tue, Dec 23, 2014 at 11:17 AM, Ashish Bhalara < >>> ashishbhalar...@gmail.com> wrote: >>> >>>> Dear experts, >>>> >>>> I try below function to get output from other sheet on matching data >>>> written in L1 in sheet of 'Letter'. But this function is not working and >>>> I'm not able to understand error. >>>> >>>> >>>> {=INDEX(Func.Query.xlsm!InvNo,SMALL(IF(INT(SaleData!$A$2:$A$100)=$L$1,ROW(SaleData!$A$2:$A$100)-ROW(SaleData!$A$2)+2),ROWS($B$22:B22)))} >>>> >>>> Please see attached file for better understanding, kindly solve this >>>> query, thanks in Advance. >>>> >>>> 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. >>>> >>> >>> -- >>> 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
Re: $$Excel-Macros$$ Need function help for output of particular list on matching data
Hi Mr.Vaibhav Ones again thank you so much for your tremendous job to help me. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Tue, Dec 23, 2014 at 2:31 PM, Vaibhav Joshi wrote: > Hi > > check this.. > > Cheers!! > > + > *I did not do this for you. God is here working through me for you.* > > On Tue, Dec 23, 2014 at 11:17 AM, Ashish Bhalara < > ashishbhalar...@gmail.com> wrote: > >> Dear experts, >> >> I try below function to get output from other sheet on matching data >> written in L1 in sheet of 'Letter'. But this function is not working and >> I'm not able to understand error. >> >> >> {=INDEX(Func.Query.xlsm!InvNo,SMALL(IF(INT(SaleData!$A$2:$A$100)=$L$1,ROW(SaleData!$A$2:$A$100)-ROW(SaleData!$A$2)+2),ROWS($B$22:B22)))} >> >> Please see attached file for better understanding, kindly solve this >> query, thanks in Advance. >> >> 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. >> > > -- > 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$$ How to extract only numbers
Use below code of UDF. Function removeSpecial(sInput As String) As String Dim sSpecialChars As String Dim i As Long sSpecialChars = "\/:*?""{}[](),!`~\:;'._-=+&^%$<>|ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz" For i = 1 To Len(sSpecialChars) sInput = Replace$(sInput, Mid$(sSpecialChars, i, 1), "") Next removeSpecialAdd = sInput End Function Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Tue, Dec 23, 2014 at 11:17 AM, Ashu k wrote: > vba. > > > Thanks > Ashu Kenith > > > On Tue, Dec 23, 2014 at 11:13 AM, Ashish Kumar > wrote: > >> Hi Ashu, >> >> You want resolution by VBA or formula. >> >> Reply. >> >> Regards >> Ashish >> >> On 23 December 2014 at 11:10, Ashu k wrote: >> >>> Dear Seniors, >>> >>> I have Data in Cell A1 like sffdsd14563jhgh85fg98cn4 in string. I want >>> extract only Numbers and delete rest of string. It's possible. >>> >>> >>> Please help. >>> >>> >>> Thanks >>> Ashu Kenith. >>> >>> -- >>> 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 o
$$Excel-Macros$$ Need function help for output of particular list on matching data
Dear experts, I try below function to get output from other sheet on matching data written in L1 in sheet of 'Letter'. But this function is not working and I'm not able to understand error. {=INDEX(Func.Query.xlsm!InvNo,SMALL(IF(INT(SaleData!$A$2:$A$100)=$L$1,ROW(SaleData!$A$2:$A$100)-ROW(SaleData!$A$2)+2),ROWS($B$22:B22)))} Please see attached file for better understanding, kindly solve this query, thanks in Advance. 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. Func.Query.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Macro for Ageing of Inventory
Mr.C.G.Kumar See attached file as your require function. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Mon, Dec 22, 2014 at 9:44 AM, C.G.Kumar wrote: > Hi, > > I have purchase data in a spreadsheet and List of Inventory Items on > another worksheet of excel. > > May someone help me with a macro or advance formula which computes Ageing > of Inventory. > > Age of Inventory is calculated in Purchase Sheet but do not know how to > compute for available qty only. > > Sample Sheet attached. > > > -- > 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. Ageing Inventory.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Date query for conditional format
Dear experts, I have series of date in which only sunday should be highlighted, please see attached file for example. 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. date query.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ need function to get data on exact match
Dear experts, I need function to receive data on fulfill particular cell data, the demo is attached herewith, thanks in advance. 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. Query.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ need macro add Rows
Thank you very much Mr.Vaibhav, ones again u do a marvelous job for me. I also learn new things from your code. Cheers :) Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Mon, Sep 15, 2014 at 1:52 PM, Vaibhav Joshi wrote: > Check this, you will be prompted to add only no. of rows & new rows will > be added at the end! > > Cheers!! > > + > *I did not do this for you. God is here working through me for you.* > > On Mon, Sep 15, 2014 at 12:45 PM, Ashish Bhalara < > ashishbhalar...@gmail.com> wrote: > >> Thanks to reply Vaibhavji, >> There are some error occur if I enter 0 to 2 in "Row from". >> Pls see attached file of ITR4 and see sheet name 'CG-OS' in which show >> command button to Add Rows. >> I want code of exactly like this. >> >> Regards. >> Ashish Bhalara >> 9624111822 >> P*Please do not print this email unless it is absolutely necessary. >> Spread environmental üawareness.♣♣♣* >> >> >> On Sun, Sep 14, 2014 at 12:56 PM, Vaibhav Joshi wrote: >> >>> Hi >>> >>> Chek this, corrected bug & added auto complete method.. >>> >>> Cheees!! >>> >>> + >>> *I did not do this for you. God is here working through me for you.* >>> >>> On Sat, Sep 13, 2014 at 4:13 PM, Ashish Bhalara < >>> ashishbhalar...@gmail.com> wrote: >>> >>>> Dear experts, >>>> >>>> I have column with heading of SR and fillup with 1 to 10. >>>> I need a macro to insert blank row under 10 with continue series >>>> 11,12,13... >>>> When run macro, message box will ask to input number i.e. 5 (How many >>>> rows to insert) and after entering, the same entered number of rows added >>>> under last series i.e. last series 10, then insert new 5 rows after 10 with >>>> writing series 11,12,13,14,15. >>>> >>>> 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. >>>> >>> >>> -- >>> 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
$$Excel-Macros$$ need macro add Rows
Dear experts, I have column with heading of SR and fillup with 1 to 10. I need a macro to insert blank row under 10 with continue series 11,12,13... When run macro, message box will ask to input number i.e. 5 (How many rows to insert) and after entering, the same entered number of rows added under last series i.e. last series 10, then insert new 5 rows after 10 with writing series 11,12,13,14,15. 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. Demofile.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Date in concatenate function
Dear experts, I am using Concatinate function to merge different text but date field not shown as a date in function. Kindly suggest require changes to merge text and date. See the attached file. 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. query.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Help in function to show only valid data
Dear Paul, thanks to reply, I don't want to simple filter. The data source is from same Sheet and data should be automatic filter in the same sheet output by changing date. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Thu, Aug 28, 2014 at 4:37 PM, Paul Schreiner wrote: > I'm sure we're going to find that there's more to this requirement than > you've supplied. > > What you asked SPECIFICALLY: > "I need a function help in attached sheet, in which Output result display > only if value is not equal to zero" > is... ambiguous. > > In Excel, a function is something like =sum() > In Excel VBA, a function is a specific type of macro. > > So, if you're wanting an Excel function, it's not going to happen. > > It COULD be done with a simple filter (see attached). > > If you're wanting a VBA macro, then there's lots more we need to know. > Like: > Do you know how to write/modify/maintain macros? > Where is the source data? (workbook/sheet) > Where do you want the output displayed? > How do you want to execute the macro (button? Change Event?) > > so... does any of this help? > > *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* > - > >*From:* Ashish Bhalara > *To:* "excel-macros@googlegroups com" > *Sent:* Thursday, August 28, 2014 5:35 AM > *Subject:* $$Excel-Macros$$ Help in function to show only valid data > > Dear experts, > > I need a function help in attached sheet, in which Output result display > only if value is not equal to zero, if data contain zero value, data should > not display in output. > Thanks in advance. > > 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. > > >-- > 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-
$$Excel-Macros$$ Help in function to show only valid data
Dear experts, I need a function help in attached sheet, in which Output result display only if value is not equal to zero, if data contain zero value, data should not display in output. Thanks in advance. 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. query.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Change date format
Oh Thanks to both of you, its very easy...Cheers!! Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Wed, Jul 16, 2014 at 12:29 PM, Amresh Maurya wrote: > see the attachment > > > On Wed, Jul 16, 2014 at 12:22 PM, Ashish Bhalara < > ashishbhalar...@gmail.com> wrote: > >> Dear experts, >> >> I have a data in which date format is Text, I want to change in date >> format to filter data date and month wise. I have change manually this >> thing by pressing FR and Enter key. >> Please provide Macro or function to change the format, the example file >> is attached herewith. >> >> 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. >> > > -- > 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.
$$Excel-Macros$$ Change date format
Dear experts, I have a data in which date format is Text, I want to change in date format to filter data date and month wise. I have change manually this thing by pressing FR and Enter key. Please provide Macro or function to change the format, the example file is attached herewith. 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. date.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Disable Row and sheet name
Dear expert, Kindly know me how to hide sheet name which displayed with scroll bar and also know me how to disable and to show of row/column number only particular which is not use. The demo sheet is attached herewith. 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. Demo.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ enable Data Validation & Insert menu in Developer menu
Dear experts, I want add command button but somehow Insert menu turn to disable in Developer menu, the Data Validation also not work, kindly know me how reset it. Thanks & 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.
$$Excel-Macros$$ enable Insert menu in Developer menu
Dear experts, I want add command button but somehow Insert menu turn to disable in Developer menu, kindly know me how to enable it. Thanks & 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$$ Autofill Macro
See the attachment of your solution. Use this function... =IF(A2="","",CONCATENATE(COLUMN(),",",ROW())) Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Sat, May 10, 2014 at 1:59 PM, Vaibhav Joshi wrote: > Hi > > See attachment.. > > It check if rows in col A is empty or not depending upon it puts value in > respective rows of col. B ,C etc... > > > If combination of row & col is empty no data will be filled. > > It takes care upto last Row & col. > > > HTH//Cheers > > > > On Sat, May 10, 2014 at 6:20 AM, Bill Q wrote: > >> I have spent the better part of 40 minutes searching the web for what I >> believe is a simple solution. I have found many answers. I have tried them >> all - None are working to what I am looking for. >> >> Simply put. >> >> - Assume source Data is always is column "A". It could be 50 rows in >> length or 84,679 rows in length. >> - The data in the rows in column "A" will always be different. >> >> I simply want a macro that will autofill starting from B1 until it >> encounters no more data in column "A" >> >> -- >> 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.
Re: $$Excel-Macros$$ if error function
Thanks, thats exactly what i found :) Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Fri, May 9, 2014 at 6:49 PM, Vaibhav Joshi wrote: > Hi > > You need to use =if ( ISERROR(fn)=True, if ( iserror(fn)=True, true>, )) > > HTH//Cheers > > > On Fri, May 9, 2014 at 5:49 PM, Ashish Bhalara > wrote: > >> Dear experts, >> >> I want to add another function if the result of first function is error, >> so please know me the function. >> >> for example >> =if =error, if=error, > function>, >> >> Iferror function cannot use because its contain only 1 argument. >> >> Thanks & 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. >> > > -- > 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.
$$Excel-Macros$$ if error function
Dear experts, I want to add another function if the result of first function is error, so please know me the function. for example =if =error, if=error, , Iferror function cannot use because its contain only 1 argument. Thanks & 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.
$$Excel-Macros$$ need solution by IF and lookup fundtion
Dear experts, Please see the attached file, Input sheet contain selection and Output sheet is a result from Input sheet. I need output in yellow cell as per selection in Input sheet by function of IF or any else. Thanks in advance 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. query.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Need help in Mid function
Dear experts, I need the middle value between two particular word as per below sentence. Sentence:Being amt. of claim *incentive for CE of Apr-14* claim receivable from TDL. Output of function should be "incentive for CE of Apr-14" The two particular word is "amt. of" & "claim receivable" Thanks & 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$$ Need help to filter text by function
Thanks to reply but the "Mud Flap-Vista" is a complete word, there are no need comma between "Mud" & "Flap-Vista". I want to remove only last commas, kindly suggest if possible. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Tue, Apr 15, 2014 at 1:25 PM, vba wrote: > Try this =SUBSTITUTE(TRIM(SUBSTITUTE(A1,","," "))," ",",") > > where cell A1 contains your data.. > > > On Tue, Apr 15, 2014 at 1:06 PM, Ashish Bhalara > wrote: > >> Dear experts >> >> I have a text as per below. >> Matting, Mud Flap-Vista, , , ,,, >> >> I want remove extra comma from the end as below result by function. >> Matting, Mud Flap-Vista >> >> Kindly suggest proper function for 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. >> > > -- > 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.
$$Excel-Macros$$ Need help to filter text by function
Dear experts I have a text as per below. Matting, Mud Flap-Vista, , , ,,, I want remove extra comma from the end as below result by function. Matting, Mud Flap-Vista Kindly suggest proper function for 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.
Fwd: $$Excel-Macros$$ Help to merge text from difference cell
Dear experts, I want merge cell containing text value and want comma(,) between all cell value in cocatenate function but my query is that when cell value is blank, the comma should not be display. Is it possible, kindly guide regarding this. Thanks & 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. -- 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$$ Help to merge text from difference cell
Dear experts, I want merge cell containing text value and want comma(,) between all cell value in cocatenate function but my query is that when cell value is blank, the comma should not be display. Is it possible, kindly guide regarding this. Thanks & 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.
$$Excel-Macros$$ Error occured during opening the file
Dear expert, There are Error occur during opening the file of "Excel found unreadable content in ''. Do you want to recover the contents of this workbook?." There are also sometime problem create during the opening file and Excel gone to task of Recover of file content and open as [Repaired] file. This file contain many sheets and conditions of also linking of each sheets. To complete the task of copy paste in new work book is so hard to write all conditions & macros. Kindly give the proper solution regarding this matter. There are also message coming with log file in xml which mention below. - < recoveryLog xmlns="*http://schemas.openxmlformats.org/spreadsheetml/2006/main <http://schemas.openxmlformats.org/spreadsheetml/2006/main>*"> error008880_01.xml Errors were detected in file 'D:\Ashish\Share Document\Account Statement from Apr-2014.xlsm' - < removedRecords summary="*Following is a list of removed records:*"> Removed Records: Object from /xl/printerSettings/printerSettings5.bin part (Print options) Thanks & 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.
$$Excel-Macros$$ Error occured during opening the file
Dear expert, There are Error occur during opening the file of "Excel found unreadable content in ''. Do you want to recover the contents of this workbook?." There are also sometime problem create during the opening file and Excel gone to task of Recover of file content and open as [Repaired] file. This file contain many sheets and conditions of also linking of each sheets. To complete the task of copy paste in new work book is so hard to write all conditions & macros. Kindly give the proper solution regarding this matter. Thanks & 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.
Fwd: $$Excel-Macros$$ Show links which to other Data source
-- Forwarded message -- From: Ashish Bhalara 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" -- Forwarded message ------ From: Ashish Bhalara Date: Tue, Apr 1, 2014 at 1:23 PM Subject: $$Excel-Macros$$ Show links which to other Data source To: "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.
Fwd: $$Excel-Macros$$ Show links which to other Data source
-- Forwarded message -- From: Ashish Bhalara Date: Tue, Apr 1, 2014 at 1:23 PM Subject: $$Excel-Macros$$ Show links which to other Data source To: "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.
$$Excel-Macros$$ Show links which to other Data source
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.
Re: $$Excel-Macros$$ Re: Copy data from multiple sheets into single sheet.
Dear Vallinayagam This sheet are password protected so I can not see the coding of copy paste. Kindly provide the coding or file containing without password. Thanks Ashish On Thu, Mar 27, 2014 at 3:28 PM, Vallinayagam wrote: > Hi, > > Attached file contains a macro which will be useful for you. > > Regards, > Vallinayagam > > > On Wednesday, March 26, 2014 11:47:01 PM UTC+5:30, jafna wrote: > >> Hello experts, >> >> Can any one explain the process that i subjected how to do in efficient >> way, which will help us to reduce our copying time. >> >> Requirements, >> >> 1) Need data from more than 200 worksheet into one sheet, >> 2) The combined data need in one format what i mentioned in sheet >> Requirement. >> >> Many thanks in advance. >> >> Regards >> Satiq >> Kuwait >> > -- > 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$$ Fwd: Need VBA coding for vlookup function
OK, I got it, Thank you very much Mr.Ravinderji. On Wed, Mar 19, 2014 at 2:33 PM, Ravinder wrote: > Pfa… put correct formula for B4 and B5 in vba code…. > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Ashish Bhalara > *Sent:* Wednesday, March 19, 2014 1:40 PM > *To:* excel-macros@googlegroups com > *Subject:* $$Excel-Macros$$ Fwd: Need VBA coding for vlookup function > > > > > > -- Forwarded message -- > From: *Ashish Bhalara* > Date: Wed, Mar 19, 2014 at 1:39 PM > Subject: Need VBA coding for vlookup function > To: "excel-macros@googlegroups com" > > Dear experts, > > > > I need coding for function written in yellow cell in attached file. On > running of macro every time the function should be written same as > peresent. Kindly guide me how to write coding for it or say another code to > find out any particular data on matching of same data like function of > vlookup as mention in sheet. Alos give coding of Now() function. > > > > > > Thanks & regards. > > Ashish Bhalara > > 9624111822 > > P*Please do not print this email unless it is absolutely necessary. > Spread environmental **ü**awareness.**♣♣♣* > > > > > > > > -- > > 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. > > -- > 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
Re: $$Excel-Macros$$ Date of Retirement.
Dear Prabhakar, see the attached file to know the retire age as per your example On Tue, Feb 18, 2014 at 2:50 PM, wrote: > Hi Team, > > I need your help to find out date of retirement with simple formula in > attached excel file. > > -- > 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/groups/opt_out. > -- 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/groups/opt_out. Date of Retirement.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ VLOOKUP Query
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/groups/opt_out. >> > -- > 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/groups/opt_out. > -- 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/groups/opt_out.
Re: $$Excel-Macros$$ Filter Data of Bold letter
Thanks Mr.Anil & others I got it. On Wed, Sep 11, 2013 at 5:36 PM, Prafull Jadhav wrote: > > Dear Anil and Xlstime Sir, > can we use below method? > > Sub prafull() > For Each x In Range("G2:G139") > If x.Font.Bold = True Then > x.Offset(0, 1).Value = 1 > End If > Next x > > End Sub > > > > On Wed, Sep 11, 2013 at 2:23 PM, अनिल नारायण गवली > wrote: > >> Dear Ashish, >> >> Pl see the attached workbook. >> Is it ok? >> Warm Regards, >> Gawli Anil >> Thanks & Regards, >> Gawli Anil Narayan >> Software Developer, >> Abacus Software Services Pvt Ltd >> >> >> On Wed, Sep 11, 2013 at 2:11 PM, अनिल नारायण गवली >> wrote: >> > Dear Ashish, >> > >> > Pl share the workbook with us. >> > >> > Warm Regards, >> > Gawli Anil. >> > Thanks & Regards, >> > Gawli Anil Narayan >> > Software Developer, >> > Abacus Software Services Pvt Ltd >> > >> > >> > On Wed, Sep 11, 2013 at 1:20 PM, Ashish Bhalara >> > wrote: >> >> Dear experts, >> >> >> >> I have a data columnar and want filter only bold letter data, is it >> >> possible, if yes please tell me how it done. >> >> >> >> >> >> Thanks & regards. >> >> Ashish Bhalara >> >> 9624111822 >> >> PPlease 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/groups/opt_out. >> >> -- >> 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/groups/opt_out.
$$Excel-Macros$$ Filter Data of Bold letter
Dear experts, I have a data columnar and want filter only bold letter data, is it possible, if yes please tell me how it done. Thanks & 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/groups/opt_out.
Re: $$Excel-Macros$$ Re: Excel file corrupt in Outlook
Thanks for reply sir, but my problem is still there, i did setting as you say but there are not solve my problem, kindly suggest another solution, Regards Ashish Bhalara On Wed, Jan 9, 2013 at 3:58 PM, Lalit Mohan Pandey wrote: > Hi Ashish, > > Here is the fix > It actually isn't a "Protected view" issue, but a DCOM issue. > > Somehow the DCOM permission got changed, so it wouldn't allow certain > applications access to simple things like Preview mode on Outlook 2010 / > 2007, or opening up attachments without it saying file corrupt. I also was > having an issue with Pop ups in IE8, where javascript messages about > security tokens were not authenticated. > > The solution is as follows, and then you can turn on your protected mode > back on in word, excel, and your "Preview mode" in outlook will start > working again. > > Go to start, then run. Type dcomcnfg and push o.k. Component Services > should come up. > > Expand Component Services, click on Computers, then "Right click" on My > Computer and go to "properties". > > Click on Default Properties tab, and make sure the following is set: > > Default Authentication Level: Should say Connect, not "None" > > And Default Impersonation Level: SHould say Identify. > > When those are set properly, hit o.k and turn on your protected mode back > on your Office applications. Everything works as expected :) > > Cheers :) > > Regards, > Lalit Mohan > > On Wednesday, 9 January 2013 15:44:15 UTC+5:30, Ashish_Bhalara wrote: >> >> >> Dear Expert, >> >> I am using outlook 2010 & I receive the error in all attachment of excel >> file during view of preview and also file show corrupted during open the >> same file, the error message is mention in below snap, I also re installed >> whole MS Office but there are same problem continue, so kindly suggest how >> to solve this problem. >> >> [image: Inline image 1] >> >> -- >> Regards. >> Ashish Bhalara >> 9624111822 >> P*Please do not print this email unless it is absolutely necessary. >> Spread environmental üawareness.♣♣♣* >> >> -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Fwd: $$Excel-Macros$$ Re: Formula need to calculate sum on conditional base
Dear expert, Thanks to reply but i have to keep data same as in attached sheet so i need a formula for amount written in red colour. -- Forwarded message -- From: अनिल नारायण गवली Date: Fri, Nov 30, 2012 at 12:26 PM Subject: Re: $$Excel-Macros$$ Re: Formula need to calculate sum on conditional base To: excel-macros@googlegroups.com, Ashish Bhalara Pls find attched sheet for you reference. Regards, Gawli Anil On Fri, Nov 30, 2012 at 12:16 PM, Ashish Bhalara wrote: > i need the formula for text enetered in sheet with red color > > On Fri, Nov 30, 2012 at 12:13 PM, Ashish Bhalara < > ashishbhalar...@gmail.com> wrote: > >> Dear expert, >> >> I have a data in attached sheet, in which data contain opng balance, >> transaction & closing balance of particular month and code, i need a >> formula to calculate sum opening balance of month wise on base of code, the >> data file is attached herewith for my requirement. >> >> Thanks & regards. >> >> Ashish Bhalara >> 9624111822 >> P*Please do not print this email unless it is absolutely necessary. >> Spread environmental üawareness.♣♣♣* >> >> >> > > > -- > Thanks & regards. > > Ashish Bhalara > 9624111822 > P*Please do not print this email unless it is absolutely necessary. > Spread environmental üawareness.♣♣♣* > > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Thanks & regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. Sum problem.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Formula need to calculate sum on conditional base
Dear expert, I have a data in attached sheet, in which data contain opng balance, transaction & closing balance of particular month and code, i need a formula to calculate sum opening balance of month wise on base of code, the data file is attached herewith for my requirement. Thanks & regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. Sum problem.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet