Hello Umesha,
Please don't mind. Actually I want to do it automatically to save time and
manual working to avoide any mistake. So I have asked it again. The solution
suggested by Zujar is little different. It's a advance filter option. It
didn't change the sr. no. of list which is not possible in auto filter
function. Everything else is same in both functions.
Regards
Mukesh Baviskar
--------------------------------------------------
From: "Umesha Economics" <[email protected]>
Sent: Thursday, December 20, 2012 8:35 AM
To: <[email protected]>
Subject: Re: [AI] if formula text
mukesh sir,
can't we do it by using autofilter as we did it earlier? I think we did
the same earlier. if you have any specific problem, please write back.
Umesha
----- Original Message -----
From: "Mukesh" <[email protected]>
To: "Access India" <[email protected]>
Cc: "Zujar Shabbir Kanchwala" <[email protected]>
Sent: Wednesday, 19 December, 2012 9:36 AM
Subject: [AI] if formula text
I have a database in which I want to sort out the list of teachers for
particular course in particular month.
Query is as follows:
column 'b' name of teacher Column 'e' name of school column 'g' address
column 'p' selection month
when I type a name of month the data of these three cells should directly
go to the selection list of that particular month.
if 'p5' = nov the data of these three cell should go in selection list in
same sheet columns aa5-ac5 respectively. is it possible? Solution please.
Thank you.
Regards
Mukesh Baviskar
mobile: 9403161157
Register at the dedicated AccessIndia list for discussing accessibility
of mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/[email protected]/
To unsubscribe send a message to
[email protected]
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Register at the dedicated AccessIndia list for discussing accessibility of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/[email protected]/
To unsubscribe send a message to
[email protected]
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Register at the dedicated AccessIndia list for discussing accessibility of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/[email protected]/
To unsubscribe send a message to
[email protected]
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes, please
visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
