User Conditional View

Is there a way to create conditional workbook and worksheet views based on 
the value of a particular cell?

Below is what I'm trying to accomplish:

I'm building a master budget template with multiple worksheets and not all 
departments will use all worksheets. So, on the main page of the workbook I 
want to have users select a department from a drop down menu and based on 
that selection I only want worksheets that pertain to that particular 
department to be displayed and worksheets that don't pertain to the 
department hidden. Additionally I want show/hide certain columns in some of 
the worksheets based on department selection on the main page.

Unfortunately, I do not know visual basic at all.

Thanks for any help.

James

0
James6891 (359)
8/20/2004 2:59:02 AM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
271 Views

Similar Articles

[PageSpeed] 55

Hi,

Yes there are ways.  You might do some searches on this
site for "hide" and read some responses.  As long as
you're not too worried about security, you could
1) hide all sheets except a "logon" sheet,
2) the logon sheet could have a drop down with a list
of depts to be selected from.
3) based on the selection, you can open (unhide) specific
sheets and do the same further for colums/rows.

If you know nothing about VBA, I'd record a few simple]
steps and then go read the recorded macro.  also just
look at some of the responses in this UG for macro
examples.

Finally, if you'll send me your email address, I'll be
happy to help you in my off hours.  

Jeff
jreese51@REMOVESPAM_Bellsouth.net

>-----Original Message-----
>Is there a way to create conditional workbook and 
worksheet views based on 
>the value of a particular cell?
>
>Below is what I'm trying to accomplish:
>
>I'm building a master budget template with multiple 
worksheets and not all 
>departments will use all worksheets. So, on the main 
page of the workbook I 
>want to have users select a department from a drop down 
menu and based on 
>that selection I only want worksheets that pertain to 
that particular 
>department to be displayed and worksheets that don't 
pertain to the 
>department hidden. Additionally I want show/hide certain 
columns in some of 
>the worksheets based on department selection on the main 
page.
>
>Unfortunately, I do not know visual basic at all.
>
>Thanks for any help.
>
>James
>
>.
>
0
anonymous (74722)
8/20/2004 3:28:41 PM
Reply:

Similar Artilces:

Error when adding new user to CRM
Hello all, I need to add 5 new users into CRM. When I complete the first form for the user information such as Last name, First name, email address, etc, then click the save button I receive an error page and the following message is logged in the Application log. MSCRM Platform Error Report: -------------------------------------------------------------------------------------------------------- Error: The statement has been terminated. Error Message: The statement has been terminated. Error Details: Details on this error have not been provided by the platform. Source File: Not avail...

SBS Exchange 2003: Create new user in AD but no exchange mailbox #3
I'm using SBS 2003. Exchange server is SP2. When I create a new user using Active Directory, it prompts me about creating a mail box. It says it's creating a mailbox, then it's done. But no mailbox appears. In fact, if I use the Exchange tasks wizard, I can create, delete, and recreate the mailbox--all say successful without an error message. And yet, no mailbox. This is even after I reboot the PC and sent email to the address. Any ideas what's going on? mike.aes@gmail.com wrote: > I'm using SBS 2003. Exchange server is SP2. > > When I create a new user ...

Lookup Function in user form
I have a combo box (cboitem1) and a text box (txtprice1). I am using the code below to have txtprice1 fill with the corresponding price the worksheet: Private Sub Cboitem1_Change() If cboItem1 <> "" Then txtprice1.Value = Excel.WorksheetFunction.VLookup(cboItem1.Value, Sheets("Pizzas").Range("A1:B65536"), 2, False) End If End Sub It works perfectly when you enter an existing value in cboitem1. However if 'the user' accidently types a letter that is not the first letter of one of the existing items VB debugging pops up with error &qu...

Conditional format that higlights differing data on two worksheets
I have a workbook that contains a worksheet for a single week of any given month and in the sheet I have an individual's time reported for each day of the week. I have a second workbook that contains an individual's time reported by each day for the entire month. I would like to compare the two to determine if there is a mismatch and highlight those cells. The logic goes something like this: (1) I need to match person A in column C of workbook1 to the same name in column C in workbook2. (2) I then need to match the date of the month on workbook 1 & 2 for person A in step #1. (3)...

Excel user information
I am interested in learning about who uses Excel and how they use it. For example, what percentage of users have had formal training; how many use VLookup, or how many build models from scratch. Does anyone know of a source for such information? Thanks. Steve Powell No idea where you would get official stats, if indeed they even exist (Which i doubt), but happy to give you my personal guess:- Formal Training - Less than 1% Use VLOOKUP - Less than 10% Build Models - Depends on definition of what a model is. A couple of cells of data with a formula could be construed as a model, so I...

Viewing / Printing more than two pages at once
I'm working on a publication, and I'd like to get a proper overview of it (balance of pictures etc) However, I can only view two pages at a time. Is it possible to view lots of little pages - say 8-10 at a time? Like you can in Powerpoint. If not, can I print lots of pages on one sheet? In the Print setup I can only get two pages at a time. Only in print preview. On the toolbar there is an icon that you can select to show you multiple pages. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "KMcA" <KMcA@discus...

Prob. when viewing my XL graph thru internet...
Hi. A problem which may or may not be due to Excel: I have some files, protected and with some sheets hidden, which I am using to show graphs and data on the internet. I want the viewer to be able to copy off the data (so they are saved as .xls files. The problem is, when I view the file in internet explorer, the chart sheet in which the file is opened will have a different size (the chart expands to fill the whole screen). The other chart sheets are fine. ??? Also, #1 the chart toolbar appears (don't want or need it) and #2 when I hit Back, a prompt to save appears (unwanted, ...

Could Microsoft create a MSPOS user manual?
My customers are asking for one. Guess we were spoiled by RMS Store Operations having one available after Microsoft updated the SMS Commerce manuals. Makes me expect one for MSPOS even though most software no longer has printed manuals. -- Jeff Faul Merchants Solutions ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and t...

Viewing xml created in .Net in a ASP form VB6
I have been trying to create an xml document in VB.Net for displaying on an existing page written in ASP. im having a type mismatch error in my code. When i view my XML i have the following included in the <binary> node. <Binary xmlns:dt="urn:schemas-microsoft-com:datatypes" dt:dt="bin.base64">DATA HERE </Binary My issue is how do i set the datatype of the the node using dotnet so that i can replicate the same node structure and use my existing ASP page. thanks in advance Colin Graham ...

Threaded message view?
This is a multi-part message in MIME format. ------=_NextPart_000_00DB_01C3970B.56F977D0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable First off, sorry if this is in a FAQ somewhere. I'm using Outlook 2003 and for the life of me can't find a way to get a = threaded message view similar to how Outlook Express shows messages in = newsgroups. I've experimented with group by/sort by filters, and the = best I can come up with is a view that has messages in threads, but = sorted the wrong way. Is there a way I can get message th...

Outlook 2003 calendar side-by-side view
I added another users calendar to my view and now it's entries are mixed up into my calendar. When I uncheck viewing the other calendar, the entries don't go away. ...

can cells apply conditional formatting using the internal clock?
I am using excell to keep track of my production schedule and I wanted to know if there was a way to tie the cells in a worksheet to the internal date and time in the computer,so that the cells will update automatically. Example: Row A10 would be my production start date, Row A1 would be my projected finish date, I would like the cells in between to go from green to red as I near the finish date without manually inputting the date in each cell. Can you help me? Thyanks Set the normal format as desired (I selected a Pattern of Green). Select A1:A10, then select Format | Conditional Fo...

viewing other publisher files
I have MIcrosoft Publisher 2000. When my friends send me Publisher files of the same year and version, I get an error message saying that Publisher cannot open files from a different source. Does anyone know what gives? Are you sure they are also using Pub 2000? Are you running Norton antivirus? -- JoAnn Paules MVP Microsoft [Publisher] "freedom" <freedom@discussions.microsoft.com> wrote in message news:CF95B6D4-85E8-4C5E-A8E1-1B2635AAEF23@microsoft.com... >I have MIcrosoft Publisher 2000. When my friends send me Publisher files of > the same year and version, I...

How to get rid of unwanted entries in the Outlook CRM tree view
Hello, If you use the crm outlook client you can easily create a new entry in the tree view of Microsoft CRM. But it how can you remove this entry again? Only by re-installing CRM? Thanks, Alex Are you talking for CRM 3, Humm, that actually sounds like a bug in outlook. -- Regards, MS CRM Certified Professional http://microsoftcrm3.blogspot.com Chat with me on MSN / Gmail / Skype : ID Is :.. mscrmexpert@gmail.com "Alex (crm-resultants.nl)" wrote: > Hello, > > If you use the crm outlook client you can easily create a new entry in the > tree view of Microsof...

User Template crashes Outlook2007
When I select a distribution template from "User Templates in File System" Outlook crashes, sends error amessage, and reloads Outlook. Can't weem to find the problem. ...

conditional running sum
Is it possible to have a conditional running sum in access. I have found for Excel but no details for access 2007. I would like to have in a report or query that will have a weekly grouping. I have a query that has calculations in it and that will be by source. I have the following sample fields: Date Adbn% 01/01/09 (Mon) 5% 01/02/09 (Tues) 6% 01/03/09 (Wed) 9% 01/04/09 (Thurs) 6% 01/05/09 (Fri) 8% I need it to end up with the following: Date Abdn% 01/01/09 5% 01/02/09 5.5% Avg of Mon&Tues 01/03/09 6.6% Avg Mon...

Conditional text field Total
Hi, In the detail section of a report I have a text box that based on a condition, it will be either a 0 or a 1. I want to total the control at the end of the report. I did this in another report a couple of years ago but it is not working now. In the previous report, the ControlSource of the total is = [TextBoxNameFromDetailSection] and it sums correctly. What am I doing wrong?? Thanks. Leah -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/201001/1 Thanks but I see what was missing - "running sum over ...

Adding User Name to footer
I have spreadsheets that go out to a number of users, and they make various changes and print out for themselves. The problems is that no-one knows which version to pick up from a central printer. Can I add the user name to the footer. I also have the path and file in the same area. I would like to end up with : User Name printed 'path/file' on 'date' ...

RMS User Question/Problem
Hello, I Downloaded and installed Microsoft Dynamics RMS, but when I first run it (for the first time) it asks me user ID and password, but have not yet established one, and is the first time I run the program! (Or is it comes with some standard user / default?) User ID: 1 Password: password Robert Armstrong RMS Systems Inc. "F.Misle" <F.Misle@discussions.microsoft.com> wrote in message news:B29A28E5-315C-4A1A-9490-A497651736A0@microsoft.com... > Hello, > I Downloaded and installed Microsoft Dynamics RMS, but when I first run it > (for the first...

user name and password not being retained in WindowsMail
I have Vista 32bit sp2, IE8 and WindowsMail. I had this problem on my XP/Outlook Express machine and found an answer, but can't find one for WindowsMail. Please note that I have had this set-up for several months and never incurred this problem. Even earlier today everything was working fine. It looks as if I can send messages, but when I click on send/receive button to receive messages I get a screen asking for my username and password. I have it set to remember in 'tools' 'accounts', but it isn't remembering it. Does anyone have a suggestion on how...

Transferring users from 1.2 to 3.0 upgrade
I am trying to upgrade a 25-user 1.2 installation to a 10-user 3.0 setup. Only 7 of the 25 licenses are being used. When I run the setup, I receive the following message: There are not enough Microsoft CRM 3.0 licenses to include all the users from Microsoft CRM 1.2 in the upgrade. Please add enough licenses to cover all the active users or deactivate some users to match the number of licenses. As I said there are only seven active users, so there shouldn't be a problem. Does anyone know what I need to do to fix this problem? Thanks. Berk; I've never seen the error, but p...

Customized Task Views Have Disappeared (Take 2)
I was having an issue similar to this original post and followed the instructions given. It worked, but as I have worked with it I have found that it will restore my customized Task views but not my customized Contact views. I can change some of the Send and Receive setting and it will restore the Contact views but not Task views. Somehow I am searching for a way to restore both Task and Contact views. Any ideas? -- Tia, Education and Documentation Specialist Sorry, i posted this in the wrong discussion group. I have posted this correctly and my question has been answered. -- ...

Error Message when viewing CRM 4.0 Reports
We recieve the following event error when attempting to access any report. http://<reportserver>/reportserver failed. Error: The request failed with HTTP Unauthorized 401 Any suggestions? This is a new install. "Chris Timms" <ChrisTimms@discussions.microsoft.com> wrote in message news:0E4DDBE2-58EC-408F-82E8-3B7EF531D392@microsoft.com... > We recieve the following event error when attempting to access any report. > > http://<reportserver>/reportserver failed. Error: The request failed with > HTTP Unauthorized 401 > > Any suggestions? Thi...

e2k3 sp2: Unknown user name or bad password error
We have an exchange cluster with two nodes that runs exchange 2003 SP2 on windows 2003 Sp1 ent. For security reasons recently I had to change the password for the account under which I installed exchange - the account is exchservice. Since then I get few of the following messages in the security log on the server - any idea how can I stop this? Event Type: Failure Audit Event Source: Security Event Category: Logon/Logoff Event ID: 529 Date: 09/10/2006 Time: 10:30:00 User: NT AUTHORITY\SYSTEM Computer: EMILYA Description: Logon Failure: Reason: Unknown user name or bad password Us...

Delivery failures to my users
This might be too broad of a question, but one of my users occasionaly will not get emails from the outside world. I've checked the Event Viewer, modified the Diagnostic Logging Levels, but can't find a reason why she's not getting some emails. Below is what her sender got back when attempting to email her. I obviously changed some information to protect the innocent! Our enviornment is: 1 Exchange 2003 Enterprise Front End Server 1 Exchange 2003 Enterprise Back End Server (ispriv and ispub on here) 1 Exchange 5.5 Enterprise We are in the middle of moving mailboxes frmo 5.5 to 2...