Would it be possible to display different data based on logins???? for instance, if i login with passwd1 i should be shown data set 1 and when i login with passwd2 i should be shown data set 2 ????
View 2 Replies
I have created few excel files from "X" login account and when i try to open it from the "Y" login account, it opens it in the read only mode. do you know how to access it from Y account in the edit mode or the write mode.
View 2 Replies View RelatedI have a pretty simple spreadsheet with two columns. In Column A is a unique identifier for a user (608901, 505141, etc.). In Column B is a date the user logged in (5/1/2014). For a week's span there are about 25k rows.
Users can and do log in multiple times per day creating duplicate entries for a single day (680717 might show up 3 times for 5/1/2014). What I need to figure out is how to get a count of all unique logins per day. So if 680717 in previous example logged in 80 times on 5/1/2014, that only counts as 1 unique login for 5/1/2014.
how to create user logins and passwords for five users for one workbook. Also, preferrably to have a message to prompt for entering the user name and password at the first worksheet (e.g. the main page where there it is usually the company logo page) when the workbook is open.
E.g. there are five employees and we would like to create five different logins and passwords for them. So when they open the workbook, it would be the first sheet of the workbook to appear first and they would then be prompt to enter their username and password. If one of the employees leave the company, we can still quite easily change the name to the new employee.
Pivot Chart. I would like to set up something to where a user can click on an individual value on a pivot chart (currently a line chart set up with 4 data series) and somehow display some underlying data. I have a lot of information stored in a data worksheet that I can't display all at once, but if a user sees a questionable data point, he/she can click and learn more about it from source data, or even a new query of the data worksheet.
I am using Excel 2010
I have two separate worksheets:
I'm trying to find a formula that looks at Column A on both sheets (each client is allocated a unique number) and if they match enter in column D of the referral sheet the month they were seen but only if it is a 1st contact (appt type on column D of contact sheet)
Referral
A
B
C
[Code]....
way to do the calculation using Excel 2003
Need in displaying data by user input criteria, mulitple rows of display also need to display to blank out when no criteria is input. In example spreadsheet the criteria cell is B6 in "Results" page and needs to pull in data from the "Database" page.
View 3 Replies View RelatedI have a spreadsheet with two sheets.
The data I am working with is in a column named "fund code"
One sheet has the fund code information that would be updated on a daily basis the other has the list of all the fund codes and what they mean.
What I would like to know is if it would be possible that if I enter a fund code number on sheet 1, it will display what that code means by getting the meaning of that code from sheet 2.
Alternatively once I enter the fund code on sheet 1 is there a way that could be automatically replaced with the meaning of that code from sheet 2?
Here to ask for a simple code on how can i display information on a user form once entered from an input box.
Example
A B C
1 E12858 Jorge Stregan
2 E112859 Rose Ann
Result:
Display all data in a row in userform once any data in A1 entered in input box.
i am looking some formula to display/show data from top to down with criteria string "drop" in col.G ("status")..
View 6 Replies View RelatedI am hoping to quickly display our inventory & WIP values by a specific job number (Column F). When I filter the job number I would like the new values for inventory & WIP to be displayed in cells N2 & P2. Is this possible?
View 1 Replies View RelatedMy data currently looks like this: 2iiaRXl.jpg
I would like to render it into something like this: TZ1ibNb.jpg
I tried to use pivot tables but I couldn't get it to look right: Jyn1CKl.jpg. If possible, I want the companys' ratings to be displayed along each corresponding year row, similar to the picture in the second link.
I have a database with a few hundred records. I can display the Data Form using Excel but receive the following error when I try display the DataForm with VBA? "ShowDataForm method of Worksheet class failed"
View 3 Replies View RelatedI need to show on one page all of the people that are above a certain percentage for the day from largest to smallest, as long as they are over 4.5%.
Unfortunately the sample size will change daily.
on the second page i have the people's names, plus all their data, plus the % metric i'm using for the front page.
so the data page would look like this:
I have a database sheet with all the data, I want to make a query sheet that display the rows of data when I enter the data in the summary sheet. I have 2000 rows of data and about 24 in type(columns)
So if I enter in cell Hona and Miles 50, it will display all the rows in the database sheet that contain those data...so I assume I would have to insert some kind of formula, or is there a simpler way to do it with out VB/database...
Car Miles PriceGasColor
RaceCar 50 Over1.5Red
Honda 100 Over2.5Black
Lexus 200 Over 3.5Silver
I'm trying to display only rows that contain data.
I have a work book that contains several work sheets. The work sheet are named by department, I'm trying to display only rows that have data and to which department they belong. I have 7 columns of data with a header. The header names are the same for all work Sheets.
The headers are Customer#(A1), Order#(A2), Qty(A3), Purchase Date(A4), Comments(A5), Promise date(A6), and Ship Date (A7).
I only want to display cells that have data from the work sheets onto a summary page.
How can I submit the data from userform in the spreadsheet vertically like A1,A2,.....
View 9 Replies View RelatedPrivate Sub UserForm_Initialize()
'ReviewFormlabel.Caption = "This is a Test" 'this line WILL display on the form
ReviewFormlabel.Caption = Sheets("Punches"). Range("A1:G17") 'I get a type mismatch error 13 here
End Sub
What I am trying to do is, display the worksheet data on a user form. This is for display only. The user will NOT be able to change any of the data.
Example:....
i m wanting Cell B1 to display true if any of the values in column C match otherwise I want to display false.
A 1
B 0
C 0
D 0
But I can't determine how to get this done.
I have a dropdown list for data validation on the "display" tab. The dropdowns come from a named range on the "Parts List" tab. When you select a part from the data validation list on the "display" tab it displays the data along the same row from the "data" tab. What i am trying to do is create the logic that will allow it to also display the information below until it hits a new part.
For Example:
If I choose "part1" in cell A1 dropdown list on the "display" tab, it will display "a,1,2,3,4" from cells A3 to E3 (this data comes from "data" tab cells B1 to F1). I also want to include the information in the rows below until it hits a new part. The number of rows may vary. Something along the lines of IF(A1) show B1 to F1, then if A2=blank then show B2 to F2, then if A3=blank display B3 to F3, etc. I need this to be dynamic, if the cell below is blank then display row info.
I need to show data across the page, currently the data is arranged in column's, I need it displayed in row's.
Each material has a number of components, it is the components which I want to show across the page, with the different headings.
I have attached the current format and the required format.
Note the spreadsheet I will be working on has thousands of materials and hundreds of components.task.xls
I have a credit card payment estimation sheet that i am trying to set up a cell that will display the same data as the last cell in columb A that the IF function displays true. I have attached a sample of what i have so far. Would like the data do display in the yellow cell with the red border. File is in Excell 2007 Format.
View 4 Replies View Relatedobviously if one wants to count all cells that contain data they can use COUNTA, but what if i have a range of cells that contain IF formulas and only want to count the cells that display data?
presumably you'd have to use some variation of NOT(""), but i can't seem to make it work.
eg having a live rate of intrest or exchange rate from the internet that is updated live whenever you load up excel and you are connceted to the intenet.
View 14 Replies View RelatedWe 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 RelatedI am trying to analyse a whole heap of data generated by an image analysis package. The data is exported out in to excel, I then need to be able ot rearange it a bit and export it out to another program.
I have attached a smaller version of the data as an example. The example data set only contains 3 image planes with ~100 entries for each. A full data set contains 96 planes and ~2000 entries each.
So what i want to do.
I want to setup a workbook i can dump this data into and have it spread everything out over 96 different sheets (1 for each plane).
I can get it to do it for the first lot of data using a IF command like =IF('Object Data'!B:B=1,'Object Data'!D3,)
But that only really works for the first plane, as the starting cell for plane 2 is always going to be different.
So what i need is a formula that will say: look at the plane column, if it equals a certain value print out the value for the other cells in that row.
Is that possible?
I have a database with 65536 rows and A-BZ columns
What I am wanting to do is, on another worksheet be able to select identifying data from one or more columns from the database but have it display the entire row.
For example
WCP28 SX
WCP28 TX
WCT36 SX
WCT36 TX
In this example I would like to, on another worksheet, be able to create a drop down where I could select WCP28 and it would show me both the TX and SX row. Or I would like to be able to select WCP28 SX and WCT36 SX and see the rows next to each other. If it were for me I would just use the auto filter and manually compare but this is for somebody even less inclined than I am.
anyone know how to display data using label on userform? I tried using offset but it doesnt work. The data I want to display is in column G. How do i go about that?
View 13 Replies View RelatedColumn L14 - L47 is not very wide on my spreadsheet because I wanted the whole sheet to be in view when you look at it on the screen. But there will be times when the user needs to put quite a bit of information in there. The cell will let you keep typing as long as you want, but if you don't have any information in the cell to the left of it, then the information spills over into those cells.
I don't like the look of that. Is it possible to make the cell automatically populate a drop down type box if the information is longer than the cell. Then have the cell display normal when you click out of it, whith a little arrow in the bottom right hand corner of the cell to tell the user that there is more information in that cell, they just have to click on it.
I have a Workbook that contains 2 sheets. One of them has a list of customer codes in one column, product codes in the next and product description in the last. The second sheet has a list of customers with their respective codes next to the names. I have a buton that when pressed asks to select a customer code from the second spreadsheet. After the selection is made a new sheet is created and that code is displayed there. This is as far as i got.
What i would like to do next is loop through the 1st sheet looking for the customer code that has been selected and in the newly created sheet display the product code and description that is next to that particulare customer in the first sheet. I'm sorry if my description is a bit fuzzy im just very tired. I will atach the spreadsheed with the vba code tha i have so far. Thnak you in advance to anyone that would be willing to help.
