I would do this with a macro. Provide a file to ME along with this msg and
examples.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
-----Original Message-----
From: in.vaib...@gmail.com
Sent: Tuesday, August 28, 2012 1:04 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ If condition limitation.
Hi All
I have a tracker with almost 10 condition to be tasted. All condition is
shown as header, for case 1 when first event is completed then date of
completion is put under 1st header and under status for case 1 value to be
reflected is description of header 1.
When second event is completed then under header 2 date of completion is
mention and status is replaced with description of header 2 and so on.
So in column A all event name is mentioned, col B is status col. And from
column C to column L header 1 to 10 is mentioned.
Eg. Value of cell A2 is Case North Port and now description of column C to Z
header is START, EMAIL SENT, REPLY recd and so on.
So when case is logged in date is mention under START header i.e. In cell.
C2 we put date of email sent. So status in Cell B2 will show as START.
Now when email is sent cell D2 will be updated with date of email sent and
Cell B2 should show status as Email Sent.
I tried applyin if condition since we are using excell 2003 not more than 7
nesting of if is used.
Any alternate way out for the same.
Rgds
Vaibhav.
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ 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.
6) Jobs posting is not allowed.
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
NOTE : Don't ever post personal or 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.
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ 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.
6) Jobs posting is not allowed.
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
NOTE : Don't ever post personal or 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.
