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
