Display Sheets Based On Log In Name

Oct 4, 2006

I have a workbook with 3 worksheets the first one is a login screen, however how do I disable the tabs at the bottom of the screen?

View 8 Replies


ADVERTISEMENT

Display Data From Sheets Based On Value In A Cell On Main Sheet?

Apr 29, 2014

I am trying to create a formula which will allow me to type a word in a cell on the Main sheet, and then pull any row from multiple sheets and display them on the Main sheet. For example, my sheet named Main looks like this:

A B C D E
1 Query:
2 Fruit Store Cost Mode Date

And there's a sheet for each month with the same format and different data:
A B C D E
1 Fruit Store Cost Mode Date
2 Apple Dominicks 1.99 Bagged 3/16/2014
3 Apple Piggly Wiggly 2.19 Ala Carte 3/14/2014
4 Banana Jewel 0.49 Bagged 3/1/2014
5 Banana Dominicks 0.57 Ala Carte 3/16/2014
6 Banana Costco 0.69 Ala Carte 3/16/2014
7 Cantaloupe Jewel 2.99 Ala Carte 3/14/2014
8 Cantaloupe Dominicks 1.99 Ala Carte 3/1/2014
9 Eggplant Jewel 0.99 Ala Carte 3/30/2014
10 Eggplant Dominicks 1.19 Ala Carte 3/30/2014
11 Eggplant Costco 1.29 Ala Carte 3/21/2014
12 Eggplant Safeway 0.79 Ala Carte 3/16/2014
13 Pears Jewel 1.19 Ala Carte 3/14/2014
14 Pears Dominicks 1.59 Bagged 3/1/2014
15 Pears Piggly Wiggly 0.99 Ala Carte 3/30/2014
16 Rhubarb Jewel 0.99 Ala Carte 3/14/2014
17 Rhubarb Piggly Wiggly 0.59 Ala Carte 3/14/2014
18 Rhubarb Costco 0.89 Ala Carte 3/14/2014
19 Tomatoes Jewel 1.99 Ala Carte 3/1/2014
20 Tomatoes Safeway 1.69 Bagged 3/30/2014
21 Tomatoes Dominicks 1.89 Carton 3/27/2014

... and so on. On my main sheet in Cell B1, I want to type a fruit name, such as Banana, and have every row in every sheet with Banana in column A,pulled and displayed on the Main sheet. Firstly, is this even possible with a macro?

View 4 Replies View Related

How To Display All Sheets Name At The Left Vertically

Nov 18, 2013

The default sheets are at the bottom. I would like to move the bottom horizontal sheets to left side vertically.

How to display all sheets name at the left vertically permanently?

View 2 Replies View Related

Compare 2 Sheets And Display Differences On 3rd

Feb 14, 2008

1. Got 2 lists in 2 sheets, those I want to compare and all the diffrences in all columns, I want to display in the third sheet.
2. The lists are the same structure.
3.Blad1 or Sheet1 is the list that is the latest.
4.Blad2 or Sheet2 is the list from yesterday.

So i want to compare newest with yesterday and all the diffs come up in the third.
So if there is a change in column A to W new planning date or planning status, or a new added row I want these to turn up in blad3 / sheet3. Cant get my excelfiles to fit the maxupload criteria. Anyone got any idea on how to do this easy? Would like to do it macro wise due to I do couple of macros before this step.

View 2 Replies View Related

Max Value Across Multiple Sheets Then Display Different Cell From That Sheet

Aug 21, 2014

Attached is an example of what I'm trying to do. I've got a master sheet and four sheets, each for a different store. Each store carries the same five items with varying prices. I've set up the master to show the lowest price of each item and have the formula set to display the minimum price. I'd like column D to show the store from which the lowest price came. It can either show the sheet name or display cell A2, as that's the store name on all sheets.

Example.xlsx‎

View 5 Replies View Related

Automatically Display 2 Sheets When Opening A Workbook

Apr 9, 2008

I am preparing a simple document for employees to use that requires viewing two sheets simultaneously.

To make it user friendly I would like, if possible, to save it so that when opening the file, the two sheets open side by side without the user having to open the new window and juggle with window sizes etc.

View 9 Replies View Related

Display Some Text Based On Another Value?

Dec 28, 2011

I am trying to display some text based on another value

This is what i am trying to achieve

Conditional formatting (Refers to range(O3-P6)
=U3="A/L" (Then Display A/L in the cell)
=U3="SICK" (Then Display SICK in the cell)
=U3="OTHER" (Then Display OTHER in the cell)

View 6 Replies View Related

Display Value Based On 2 Conditions

Nov 6, 2009

I have a workbook with 2 worksheets. The first sheet provides a summary showing the last date a person attended a specific course.

The second worksheet is a list of all courses, attendees, dates, and status. I need a function that will match the attendee and course from the Master and display the date from the master in the corresponding cell on the summary sheet....

View 9 Replies View Related

Display Different Text Based On Data

Aug 17, 2009

We are working on having the spreadsheet display the correct options, depending on what criteria are chosen. There are three choices in the first criteria and two choices in the second criteria. These choices are presented using data validation so they will always be formatted correctly. Worked on conditional formatting to display results but did not make much progress. Started working on "if" statements to display results, looks like this may not be efficient. Spent a lot of time reading, trying to find a solution.

View 3 Replies View Related

Display An Image Based On A Cell's Value?

Jan 12, 2010

I have two bitmap images, and I would like to show only one image at a time, based on the content of another cell's pull-down list. If the user selects "AIR", then display the AIR image. If the user selects "SERVO", then display the SERVO image.

View 2 Replies View Related

Display Numbers Based On Counts

Oct 17, 2011

I have a series of numbers going down from max to min in column M, in column N I have the number of counts of the same numbers.

The Modal value is calculated by a formula and already displayed in cell F3 (it needs no modification).

What I am trying to do is this:

1) Identify the address of the same modal value in column M.

2) From the modal values address in column M, search Column N searching upwards and downwards from the modal value address, until the first instance of the pre-specified count number is identified.

3) When the pre-specified count number is identified look beside in the cell in column M and display the value beside that pre-specified count in cell.

We stop at the first instance of that prespecified count both when 1) counting upwards and 2) counting downwards.

The upper value is displayed in F2 and the lower value is displayed in F4.

An example would be.

1 1
2 2
3 3
4 4
5 6
6 1
7 2
8 3
9 4
10 1

The modal value is 5 looking beside it as it has 6 counts, so in the count column we search upwards from the count of 6 until we encounter the pre-specified number of 4, then we look beside the count of 4 and observe that the number 4 above the modal value has 4 counts hence we display the number, now we search downwards from 6 counts until we reach the first instance of 4 we find it and the cell beside it contains the number 9 so we display the number 9.

The end result is numbers 4 and 9 that have 4 counts each.

View 9 Replies View Related

Display Userform Based On Cell Value

Sep 12, 2012

Depending on the result of a formula in R67, one of three things will occur. If the result is a 1, UserForm1 is displayed. If the result is a 2, UserForm2 is displayed. If it is nothing, nothing happens. Ok, I can do that.

However, with the code below, whenever I select any cell, and there is a 1 or a 2 in R67, the userform pops up. I only want it to pop up if I change a value in C6 which in turn changes the result of the formula in R67.

Code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("R67").Value = 1 Then
Run "UserForm1"
End If
If Range("R67").Value = 2 Then
Run "Userform2"

[Code] .......

I've tried setting a monitored range. I've tried the code below in one form or another and it didn't work.

Code:
If Not Intersect(Target, Range("C6, R67")) Is Nothing Then Macro

View 7 Replies View Related

Display Number Color Based On Value?

Jan 16, 2014

I have a column of numbers that I am trying to get to display based on the value. (The field is formatted as percentage and must stay that way).

I want any number that is < 90% to appear red, but any number => 90% to appear black.

View 4 Replies View Related

Display Different Message Box Based On Cell Value?

Jun 24, 2014

I have a workbook that can open a URL into IE when a project number is entered in an input box.

What I would like to happen is that if the project number entered does not have a URL against it and the value is #N/A, then the message box will display "Project does not exist". However if the number does exist, I want a different message box to be displayed which is a yes/no box.

The code below is what I have tried which works fine if the cell value is #N/A but when it is not it throws an Run-Time error 13: Type mismatch

Code:
Sub SearchPidsMessageBox()
Dim Answer As String
Dim MyNote As String

[Code]....

View 2 Replies View Related

Best Method To Display Chart Based On Condition Met?

Sep 6, 2013

I'm designing a sheet at work where an individuals performance is monitored then charted. However the supervisor has now decided that he wants to see their performance charted against that of their entire team.

Using Data Validation i have a drop down selecting the user. Then their performance stats are found from various sheets using INDEX and MATCH. I have also done this in another cell to locate their team number ie "Team 1" for example.

Can i use VBA or any other method to generate a chart for when the team is displayed to then generate the entire teams chart? The data to generate this graph is on its own sheet as a team overview?

View 1 Replies View Related

Display Userform Based On Dropdown Selection

Oct 5, 2013

I have created a User Form that has been tested and is working properly. Now my last step is to do the following:

I would like to Display the User Form (coded as CommRM) if in Column C (can be any cell as it is a large worksheet) someone selects "Retail News" from the drop down option.

The code that I have been able to create so far is below. The problem is that when I select Retail News from a drop down in Column C the user form does not appear.

VB:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range (C14, C3333).Text = "Retail News" Then Call UserForm_Initialize
End Sub
Private Sub UserForm_Initialize()
Load CommRM
CommRM.Show
End Sub

View 7 Replies View Related

Display And Summing Value Based On 3 Criteria Month

Mar 31, 2014

I am looking sum formula to display my data with 3 criteria (display by this month, until this month & until last month) based on header column/correspondents, then in cell L3 as selected month display..

For further information, check workbook attached...

SUM 3 MODELS MONTH.xlsx‎

View 7 Replies View Related

Display Message Based On Multiple Criteria?

Feb 10, 2014

I have created a sheet that calculates a score. Based on that score a determination is made to do one of three things - Nothing, Peer/Manager Review, Review Required.

In addition it was requested now that I make an overall decision for "Review Required" based on multiple triggers. My thought was to create a table from outputs of each element on another sheet, and then trigger off the table. What I am stuck on is using the multiple choices to trigger the message - Below are the choices of which each or a combination of each should trigger "Review Required"
Calculate Review Required

Total Score 'Review Required
Element 1 "
Element 2 "
Element 3"
Element 4"
Element 5"
Element 6"
Element 7"
Element 8"
Element 9"
Element 10"
Element 11"
Element 12"
Element 13 "
Element 14 '20 or more = reveiw
Element 15 '20 or more = reveiw
Element 16 '20 or more =review
Element 17 'Sum 20 Total of above if less than 20 in each

View 5 Replies View Related

Display Information Based On Dropdown Selection?

May 21, 2014

I'm wondering how I could display information based on the user input through dropdown selection. I know how to make a dropdown-list already.

Example: A1 has a dropdownlist with Apple and Banana in it. If I select banana then I want B1 to display "8" and if I select Banana I want B1 to display "4".

View 5 Replies View Related

Display Number Of Years Based On A Date

Mar 28, 2009

Right now, in a column I would like to display an number (length of employment) based on the hire date.

In one cell the employee's hire date is entered. In a column of other cells the pay period ending date is displayed and in another column the length of employment is displayed.

Example:

03/17/2000

03/01/2009 8
03/15/2009 8
03/29/2009 9
04/12/2009 9
04/26/2009 9

How would I create a formula in the length of employment cells that would indicate the correct number of years based on the hire date and adjusts when the pay period date passes this hire date?

View 2 Replies View Related

VBA To Display Scenarios Based On Combo Box Selection

Feb 24, 2009

I just want to create a combo box that will allow my manager --- not so good at using menu commands or the scenario manager --- to choose one of five different budget scenarios. I can't seem to get the actual scenarios to change when the selection is made from the combo-box.

This is the

View 4 Replies View Related

Display Data Based On Key Codes Entered?

Jul 8, 2009

I am trying to do in the title so here it goes. I want a user to be able (on form 1) to enter a list of codes that refer to specific requirements (e.g. code PB114 may mean the user needs to perform a pressure test) and then excel will automatically display the requirement somewhere below. It is going to be somewhat of a database. In otherwords lets say in cell A1 you type in a code, e.g. PB114. In a range of merged cells or somewhere below that cell I want the information "Perform a pressure test" to appear.

View 5 Replies View Related

Display An Error Message Based On Particular Condition

Dec 29, 2009

When the whole row in excelsheet is full for particular date that means all the values of columns (Legal Charge,GA and DNM) have been entered for particular date then display an error message if the another user tries to enter the values for the same date .

It means the user can enter the values for same date only if values of Legal Charge,GA and DNM are empty,otherwise an error message should pop up.

View 3 Replies View Related

Display Formatted Formulas Based On Selection?

Feb 7, 2012

I am trying to display a formatted formula (combination of greek characters, superscripts, subscripts, bold, italics, etc...) based on a selected input. I have a selection cell with a drop down offering the choice of 4 difference scenarios. I want to display the resulting formatted formula depending on which scenario is selected (the formula is difference depending on the selection, as well as perform the calculation.

The calculation works fine, but I cannot figure out how to show the formatted formula. The selection works using IF statements, or VLOOKUP, but does not bring the formatting across. How can I do this?

View 1 Replies View Related

Excel VBA To Display Textbox Based Upon Two Criteria

Aug 2, 2012

I have a worksheet that I will enter in an age and gender ($B$5 and $B$6 respectively). Based upon these two criteria, I would like to display text in column H(Lower Limit) and I(Upper Limit), showing the norms for their health metrics, a few are below:

Metrics
Measured
Lower Limit
Upper Limit

Total Cholesterol
200
120
200

HDL
40
35
80

Glucose
90
90
130

So, as the user enters in the age in B5 and the Gender in B6 the VBA or formula would populate the cells with the appropriate data. I can get it to work with 1 condition using vlookup. Was thinking VBA might be useful there with the two criteria, just not sure how to code it.

View 9 Replies View Related

Display Or Hide Shapes Based On Cell Value Without VBA?

Aug 8, 2012

I have a map of the US composed of 50 shapes (one for each state). I need each shape to appear or disappear based on a value in a corresponding cell. I can't use VBA for this as it needs to function for users in a high-security Excel 2003 which doesn't allow macros.

View 1 Replies View Related

Display Image Based On Contents Of Cell?

Feb 25, 2014

I have found Displaying an image based on text contained within a cell. which appears to be a very similar question, but no steps to follow.

Basically I have a folder with around 300 images in it, each is called ProductId number.jpg
eg Z99S1234567.jpg

In my sheet I am using the same ProductId number and would like to display the product image on the sheet. I have A1:D19 as spare space Lookig at the info I have found the image will have to go into a cell, so can I break all the rules and merge cells to fit the image in, or do I need to make a single cell big enough or can I use VBA to import the image somehow to a specific place on the sheet.

There will only ever be one looked up image on the screen at a time.

View 1 Replies View Related

Display Data Based On Current Month

Jan 21, 2007

I have a tab set up to display information that has been colletect on other tabs. What I would like to do is change this information depending on what month is selected.

For example, if I select December then data would be pulled from other tabs and displayed. If I Select June the information would change and select other data from the same tabs.

View 9 Replies View Related

Get 2 Textboxes To Display Different Strings Based On Keypress

Mar 19, 2008

I have a Userform whose purpose it is to capture payment information, in particular Creditcard information. To this end it has (amongst other elements) 2 textboxes - textboxCardNr1 and TextboxCardnr2.

the User enters the cardnr in Textboxcardnr1 as, e.g. 4321098765432109. Through the code below I transform this into the more readable number
4321-0987-6543-2109. I capture the keypress instance to only allow numbers to be entered in this field and to simultaniously update TextboxCardNr2 with the keystrokes.

On exiting TextboxCardNr1 the content of TextboxCardNr2 is copied to the clipboard to be available for pasting on a secure website in the approriate field.

My problem is, that when the user makes a mistake and changes the number in TextboxCardNr1, those changes are not automatically mirrored in TextboxCardNr2.

I want the easy to read form of the card - with the dashes, to be saved. The website the user is pasting the content of TextboxCardnr2 to does not accept the number with dashes.

Private Sub TextBoxCardNr1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)
Dim taste As String
Dim wert As String

taste = VBA.Chr(KeyAscii)
wert = Me.TextBoxCardNr1.Text

KeyAscii = 0
If taste = "0" Or taste = "1" Or taste = "2" Or taste = "3" Or taste = "4" Or taste = "5" Or taste = "6" Or taste = "7" Or taste = "8" Or taste = "9" Then If Not Me.TextBoxCardNr2.Text Like "################" Then
Me.TextBoxCardNr2.Text = Me.TextBoxCardNr2.Text & taste............................

View 9 Replies View Related

Display Data In List Based On Criteria

Sep 11, 2006

II have a list of football fixtures (see attached sheet - barclays premiership) each with a different status Win,Loss,Draw,Pending. I want to display the next team with a Pending status in a cell at the top of the list (cell T13/14) so the user knows at a glance what the next fixture is. I also want to display the days remaining to that fixture in the cells below this (cell T15/17).

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved