Show Users Only Certain Data Based On Their Name
Sep 29, 2006
I have a large workbook that contains markbook info of all my classes that I teach.
I don't want them to see all my workbook as it would be too confusing. I would like to hide all the data and have a simple INPUT box on a separate page that would ask for their name. The name would then be used to find the row number, add this to a specific column number (always the same) which hold their marks and then return the mark in a Message box.
View 2 Replies
ADVERTISEMENT
Aug 18, 2011
I have a few people all entering in data into excel, since they cannot be all in one sheet they each have their own copy. I would like to be able to extract all data where column P reads "Red" from each users spreadsheet and then delete the corresponding lines from their spreadsheet (end of day activity)
The Sheets will be named
FDEntryU1AM.xlsm
FDEntryU2AM.xlsm
FDEntryU3AM.xlsm
FDEntryU4AM.xlsm
[Code] .......
I will then need to do the same in another workbook for all items Labeled Blue, but that of course will be same code with just an item replaced.
The idea is after they close up the person overseeing the data can import all at once and leave the users with fresh empty workbooks.
View 9 Replies
View Related
Apr 5, 2007
Is there are a formula that will result in showing the users name in a selected cell?
View 9 Replies
View Related
Mar 13, 2014
I want to show/hide multiple rows based on the value of a cell on another sheet.
For example,
If Sheet1!A1="A" I want to show hide rows on sheet 2 as follows:
2 Show
3 Show
4 Hide
5 Hide
6 Hide
7 Hide
If Sheet1!A1="B" I want to show hide rows on sheet 2 as follows:
2 Hide
3 Hide
4 Show
5 Show
6 Hide
7 Hide
If Sheet1!A1="C" I want to show hide rows on sheet 2 as follows:
2 Hide
3 Hide
4 Hide
5 Hide
6 Show
7 Show
In my actual example the number of rows to show hide is greater (27 rows per selection) so a range, rather than specifying individual rows would be best.
View 4 Replies
View Related
Mar 2, 2007
Call centre data for financial years located in separate workbooks (1 for each year)
Here's what I want to create.
One main file to consolidate/view all data
I've tried to make this as user friendly as possible by having a validated list, whereby the user can select the year they want to view, and hey presto, the data changes to reflect the year displayed in the validated cell.
View 5 Replies
View Related
Feb 11, 2013
How to autopopulate numbers from data sheet based on Selected month.
View 4 Replies
View Related
Nov 30, 2012
I am trying to show a value in a cell, based on the values found in other cells. Essentially, here is what I've got:
If C2 is greater than A2, B2, D2, then put the value found in C1 in E1.
View 9 Replies
View Related
Mar 31, 2014
Is there any vba codes that can show tab/sheet that is based on the filter selection.
For example:
Cell A1 have a data validation of Apple, orange and Mango
I have 3 tabs named Apple, orange and Mango.
So every time I select Apple on the main in page filter. Apple tab will show. and if orange then orange tab will show.
View 3 Replies
View Related
Jan 10, 2005
I have a spreadsheet that queries the web for a weather forecast each day. I'd like to associate pictures on the excel page based on the weather description, but can't figure out a way to select /change the picture automatically.
View 3 Replies
View Related
May 10, 2009
I'm building a spreadsheet for a sporting franchise using a pull-down validation menu. Once the opposing team name is selected from the drop down menu, I would like it to display the opposing teams players and their statistics.
On the database worksheet, I have a web query pulling names and statistics from the web. Each player name has his team name in his corresponding row. What function can I use that will search for that team name and report it back to the display sheet? Once I have the player name there, I think I can figure the statistic portion... But I can't seem to figure out how to pull all of the players with the matching team name into my display sheet.
Example:
A1 on worksheet "A" contains a pull down menu with team names "Lightning", "Storm", "Magic", and "Thunder".
A16-A20 on worksheet "B" contains players from team "Lightning"
A21-A25 on worksheet "B" contains players from team "Storm"
A26-A30 on worksheet "B" contains players from team "Magic"
A31-A35 on worksheet "B" contains players from team "Thunder"
B16-B20 on worksheet "B" contains team name "Lightning"
B21-B25 on worksheet "B" contains team name "Storm"
B26-B30 on worksheet "B" contains team name "Magic"
B31-B35 on worksheet "B" contains team name "Thunder"
If I pull down "Lightning" on A1 (worksheet "A"), I want the following to display:..........................
View 4 Replies
View Related
Jun 26, 2014
formula to use in my report
Let's say I have a summary table on Sheet 1 6000 rows of data on sheet 2.
In Sheet 2 I have 3 columns, Name, Month and Score. Name Column (A) has names of students Month Column (B) has months January, February and so on. Score Column (C) has data from Green, Yellow and Red. Red is if they failed.
In the summary table on Sheet 1, I need to show all the names that got a "Red" Score. And their corresponding months.
It should look like this.
Month l Name l Score
-----------------------------------------
January l Mike J l Red
-----------------------------------------
March l Joe M l Red
View 2 Replies
View Related
Dec 12, 2007
I want to write a VBA code, so I can apply dates criterias to my pivot table. Say, I have 1-Dec-2007 in "C2" and 10-Dec-2007 in "C3". Now I want my pivot table to show me the dates between those two dates and the data that goes along with it. I have written this code, but it keep debugging:
Sub FilterDates()
Application. ScreenUpdating = False
Sheets("PnL").Select
Sheets("PnL").PivotTables("PivotTable3").PivotFields("Date") _
.PivotItems("01/01/1950").Visible = True 'to always have 1 populated
View 9 Replies
View Related
Feb 22, 2008
I have looked at the below Hide/Show Pivot Table Field Items help web pages:
Hide/Show Pivot Table Field Items
Hide Pivot Table Fields Pivot Items by Criteria
I am trying to use the above, but with dates in the following format in each cell:
YYYYMM
200612
200701
200702
200703
200704
200705
200706
etc, etc
The below code is working for >200702 and removes all years/months prior to this entered value. Unfortunately the code does not work when a user enters <200706, instead the code goes through to the “NonValidCriteria” prompt.
Sub HideByCriteriaYYYYMM()
'Declare variables
'SEE: [url]
'SEE: [url]
Dim pt As PivotTable, pi As PivotItem
Dim lMonth As Long
Dim strCri As String, strCri1 As String, strCri2 As String
Dim bHide As Boolean
Dim xlCalc As XlCalculation
View 4 Replies
View Related
Apr 2, 2014
I'd like for my spreadsheet to open with only Column A visible; I'd like all other collumns to stay hidden.
I want to create a marco to unhide column(s) based on the value of an individual cell.
For example:
if I enter the number 5 into cell A1, I would like Columns B:F to unhide.
if I enter the number 2 into cell A1, I would like Columns B:C to unhide. Is this possible?
View 10 Replies
View Related
Sep 8, 2009
I have 2 different formulas that I need changed in a similar way.
The first formula is for cell AV11:
=SUM(BI11,BP11,BW11,CD11,CK11,CR11,CY11,DF11,DM11,DT11,EA11)+10
Every cell starts off blank.
What I need is for cell AV11 to always start off blank until data is entered into one of the other cells. The problem is that since the sum always needs to be +10 only when data is entered in the other cells, I don't know how to keep 10 from showing in cell AV11 when no data is typed in the other cells.
The other formula is for cell CO39:
=(CU8)+3
I pretty much need the same thing. If no data is entered in cell CU8, then I do not want cell CO39 to show the 3.
View 9 Replies
View Related
Feb 14, 2008
I have a sheet with 3 columns and I would like to have these 3 columns fit the screen so that an attractive user interface is created. I do not want to be able to scroll to blank area to the right of column C
I know nothing about Visual Basic and was trying to follow the following
Private Sub Worksheet_ Active ()
Me. ScrollArea = Range (Me. Used Range, Me. UsedRange (2.2) .Address
End Sub
I am using Excel 2000 and I either kept getting error messages or after changing the visual basic sheet headings to worksheet and Active respectively ( two headers at top of page) the macro still failed to work.
Colo HTML does not seen to work in the visual basic window so I cannot show you the page.
View 9 Replies
View Related
Feb 26, 2009
i have a query spreadsheet where all business queries are logged. Next to each query you need to select a resolving reason from a drop down list, however i would like some of these to be locked so only certain people could use them.
Lets for ease of use the resolving reasons are the following -
Not paid
Allocated Correctly
Rejected
And say the drop down list is in column P
I would like everyone to use the top 2 but only certain members of the team to be able to use the last one.
I was thinking protect the cells in some way and a worksheet change event of some kind so protect / unprotect depending on the resolving reason.
View 9 Replies
View Related
Feb 2, 2013
My Workbook contains several UserForms in which employees will be entering hours and activities on a daily basis. In the UserForm, they select their department and enter hours for each specific type of work/activity that shows up for that department in the userform. They click the submit button and all the data (date, name, department, type of work and hours) is added to a database table in another sheet, which in turn feeds a number of reports.
I need to be able to have anywhere from 20 to 100+ employees enter their hours on a daily basis, many of them at the same time, all from different locations (within the network of the client's system), using the same UserForms.
We've experimented with Google Drive, but that seems not to be the solution. It kind of works, but is not secure (it installs a copy of the entire workbook on the users system and then synchs the data back to the server upon "save") and way too cumbersome. I've heard of SharePoint, but not every client has that installed (and frankly I don't know how it works).
View 3 Replies
View Related
Mar 25, 2009
I am making a spreadsheet that allows users to select items from a validated data list. Each item in the list has a numeric value in an adjacent column. When the user is entering data they will select from a drop down of the data list in column "A" and I would like to have the numeric value that corresponds with their selection to then autofill in column "B". I have tried VLOOKUP and IF formulas but cannot seem to get anything to work.
View 9 Replies
View Related
Jul 21, 2009
Amongst the several sheets contained in my workbook, there is one called 'Inspection Report'. Users fill in whatever data is required in the other sheets, and once they get to this one, they are supposed to enter a number from 1 to 3 into Cell X1 (which is currently selected) before they select anything else. Unfortunately, I am currently unable to stop them from doing what they should not be doing.
So, I would like to have a notification of some sort pop up into their face if they click or move the selection anywhere else while Cell X1 is still empty. Something like a validation would be nice.
View 6 Replies
View Related
Oct 9, 2009
I have a column of data held in column B.
I am required to show the following.
If there is data in the cell then it is to be left. If there is no data in the cell then I would like to show the value 0.
I have tried using a circular reference, using the formula =IF(ISBLANK(B1),0,B1) and other similar formulas but they dont work as the formula overwrites the data in it.
do I need a macro?, or conditional formatting?
View 9 Replies
View Related
Jul 30, 2009
We're trying to use one template to enter data with users being able to start entry from a number of different starting points. this changes they way the look-ups have to work. The attached sample explains it a whole lot better.
View 2 Replies
View Related
Nov 15, 2010
Is there a way to have a data validation drop down menu but at the same time allowing users to enter free text as well.
View 3 Replies
View Related
Dec 12, 2008
I have 15 sheets - Resident 1, Resident 2 etc
If cell A1 on Summary tab contains 10, I want sheets Resident 1 to Resident 10 visible, everything over Resident 10 to be invisible
If cell A1 on Summary tab contains 5, I want sheets Resident 1 to Resident 5 visible, everything over Resident 5 to be invisible
View 9 Replies
View Related
Dec 31, 2006
I have folder with 5 photos on c (c:Pictures). Photos are named a, b, c, d, and e. In Excel workbook sheet1 (c:Photos.xls), how to display the photos in cell range (B1:F10) in response to change in cell A1 (i.e., when A1 cell value is “a”, the photo “a” is displayed in the range B1:F10, and so on when the A1 value changes)
View 3 Replies
View Related
May 18, 2007
I have a workbook with multiple worksheets, and I am trying to create a title sheet where a user can select their name from a drop down list, and Excel will show only the tabs that are associated with that user. For example:
The worksheets in the workbook are:
Heading
Control sheet
Client Relations Admin
Sales Summary
etc...
The user Hudnall needs to see the sheets:
Client Relations
Sales Summary
The user Ferguson needs to see the sheets:
Sales Summary
Control Sheet
I want the user to be able to select their name from a drop down list on seperate sheet, and have the Macro show only the sheets that they need to see.
View 7 Replies
View Related
Jul 2, 2007
Question: I would like to have two pictures (one in cell B2, the other in cells D1-C10 to I10) display based on a data validation list that I have in A1. So, for example, if you click U.S.A., two pictures for U.S.A. show up; if you scroll down to Canada, two pictures show up. If you're interested, I have included the history of what I have tried in the past.
History of what I have tried:
I used this code before [url] , but that makes all pictures but 1 invisible and I need two.
So then I used this one,
Sub HelloWorld()
'Message box to say hello
MsgBox " Sub GetPicture()
Dim oPic As Picture, imgFlag As Range, imgMap As Range
' Loop Flag and Map images
'imgFlag = Worksheets("Image").Range("B1")
'imgMap = Worksheets("Image").Range("D1")
For Each oPic In Worksheets("Summary").Pictures
If (oPic.Name = Worksheets("Image").Range("B1").Text) Then
oPic.Visible = True
oPic.Top = Worksheets("Image").Range("B1").Top
oPic.Left = Worksheets("Image").Range("B1").Left
ElseIf (oPic.Name = Worksheets("Image").Range("D1").Text) Then
oPic.Visible = True
oPic.Top = Worksheets("Image").Range("D1").Top
oPic.Left = Worksheets("Image").Range("D1").Left
Else
oPic.Visible = False
End If
Next oPic
End Sub"
View 8 Replies
View Related
Apr 1, 2008
I have 5 sheets in a workbook named the following:
Monday delivery
Tuesday delivery
Wednesday delivery
Thursday delivery
Friday delivery
I want a macro to fire when the workbook opens. I want it to look at what day it is and then show the sheet for the next day and hide all the rest.
Example, with today being Tueday, if someone opened the workbook, I want only the Wednesday delivery sheet to be visible and all the others to be hidden, well very hidden.
Then tomorrow it will show Thursday delivery and so on. If opened on a Friday, it should show the Monday delivery sheet.
View 8 Replies
View Related
Mar 4, 2014
What I'm trying to do is show monthly performance based on products of a few different areas. Where I'm running into problems, is with the month listings. If the report shows one month at a time, I can get it to work with SUMIF formulas, however when there is more than one (and there will always be three).
View 6 Replies
View Related
Mar 31, 2009
I have a spreadsheet with two bitmap images inserted into it. In cell E2, I will enter a number, either a 1 or a 2. if I enter a 1, I want only the first image to be visible. If I enter a 2, I only want the second image to be visible. Is there a way to accomplish this (hopefully without the need for macros)? I've attached a spreadsheet as an example of what I'm trying to do. Also, note that I'd like the images to be stacked on top of each other so that they show up in the same place regardless of wether there's a 1 or a 2 in cell E5
View 13 Replies
View Related
