Dear Dguilett I dont know to apply it in excel.Plz apply it in file.
Regards, Ankit On Tue, Dec 13, 2011 at 7:46 PM, dguillett1 <dguille...@gmail.com> wrote: > What happened to this code that I had offered? You can certainly add a > provision to automatically mark your column. > > > Private Sub Worksheet_Change(ByVal Target As Range) > Dim tr As Long > If Target.Count > 1 Or Target.Row < 3 Then Exit Sub > tr = Target.Row > If Target.Column = 2 Then > Application.ScreenUpdating = False > > Rows(tr - 1).Copy Rows(tr).Resize(2) > Cells(tr, "c").Resize(, 20).ClearContents > Rows(tr + 1).ClearContents > 'Cells(tr, "b").Select > > > Application.ScreenUpdating = False > > End If > End Sub > > > Don Guillett > SalesAid Software > dguille...@gmail.com > -----Original Message----- From: Ankit Agrawal > Sent: Saturday, December 10, 2011 9:54 PM > > To: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ Help in preparing the column automatically > > Dear Sir, > > I had some confusion regarding my sheet now it has been clear.Please > find my new attachment.plz solve my below metion query > > * I shell start from beginning. > * I have only two query. > * Need symbol in coloumn "I" i.e. "Agreement", if vendor > agreement(which mentioed in admin file) has expired on the date of > issuing SOW/PO no., then mark (x) or if agreement is valid then put > (ü). And Vendor is not in the agreement list than mark it (?) > * Another query is that I need SOW approved date is date of issuing > the No. but when I use (TODAY) function it change on daily basis > > Suppose I put this formula =IF(I17="","",TODAY()) then it will change > on daily basis. > > Regards, > Ankit > > On 12/10/11, dguillett1 <dguille...@gmail.com> wrote: > >> I have developed columns A:E with a change event macro and data >> validation. >> I still do NOT understand the rest,especially what date to use?? >> >> Private Sub Worksheet_Change(ByVal Target As Range) >> Dim tr As Long >> If Target.Count > 1 Or Target.Row < 3 Then Exit Sub >> tr = Target.Row >> If Target.Column = 2 Then >> Application.ScreenUpdating = False >> Rows(tr - 1).Copy Rows(tr).Resize(2) >> Cells(tr, "c").Resize(, 20).ClearContents >> Rows(tr + 1).ClearContents >> Application.ScreenUpdating = False >> End If >> End Sub >> >> Don Guillett >> SalesAid Software >> dguille...@gmail.com >> >> From: Ankit Agrawal >> Sent: Saturday, December 10, 2011 1:13 AM >> To: excel-macros@googlegroups.com >> Subject: Re: $$Excel-Macros$$ Help in preparing the column automatically >> >> Deal All, >> >> PFA as per your query. >> >> Regards, >> Ankit >> >> >> On Fri, Dec 9, 2011 at 8:19 PM, dguillett1 <dguille...@gmail.com> wrote: >> >> You need to give examples >> col b. could/should be from data validation list >> col a. incremented automatically when you enter col B. Example of next >> number >> col c. same as col B using DV >> col I. “agreement sheet” ? >> col J. populated on what__________occurring. >> >> Don Guillett >> SalesAid Software >> dguille...@gmail.com >> >> From: Ankit Agrawal >> Sent: Friday, December 09, 2011 8:40 AM >> To: excel-macros >> Subject: $$Excel-Macros$$ Help in preparing the column automatically >> >> Dear Expert, >> >> Please help me to solve out query in attached excel. >> >> Here one excel file where I want to do some column automatically. >> >> Regards, >> Ankit >> -- >> FORUM RULES (934+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will >> not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> ------------------------------**------------------------------** >> ------------------------------**------------ >> To post to this group, send email to excel-macros@googlegroups.com >> >> -- >> FORUM RULES (934+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will >> not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> ------------------------------**------------------------------** >> ------------------------------**------------ >> To post to this group, send email to excel-macros@googlegroups.com >> >> >> -- >> FORUM RULES (934+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will >> not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> ------------------------------**------------------------------** >> ------------------------------**------------ >> To post to this group, send email to excel-macros@googlegroups.com >> >> -- >> FORUM RULES (934+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will >> not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> ------------------------------**------------------------------** >> ------------------------------**------------ >> To post to this group, send email to excel-macros@googlegroups.com >> >> > -- > FORUM RULES (934+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > ------------------------------**------------------------------** > ------------------------------**------------ > To post to this group, send email to excel-macros@googlegroups.com > -- > FORUM RULES (934+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > ------------------------------**------------------------------** > ------------------------------**------------ > To post to this group, send email to excel-macros@googlegroups.com > -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
