List Items That Has Been Booked Out

Jan 10, 2013

I have sheets with list of goods and in the last column I have a dropdown box you can choose - book in or booked out. See attached file.

On another sheet I want a list of all the items that has been changed to booked out.

View 3 Replies


ADVERTISEMENT

Select Multiple Items In List And Then Print Those Items?

Dec 26, 2013

I am wanting to create a list where I can select multiple items within that list and then print only those selected items. I have created something similar thru data validation, but I can't get it to print.

In addition, I would like to be able to subdivide the list into multiple categories, then select items from these multiple categories and print them.

View 3 Replies View Related

Calculate Number Of Booked Entries?

Apr 16, 2014

I have attached a workbook which I am trying to calculate the number of "Booked" entries there are between 0 -36 months, 36 -72 months, 72 - 96 months and 96 months plus, for some reason the 0 - 36 months is calculating correctly but the remainder aren't, the current formula that I am using is;

=SUM(COUNTIFS('Service Reminders 2014'!$AR:$AR,"Booked",'Service Reminders 2014'!$K:$K,"<="&EDATE(TODAY(),-36),'Service Reminders 2014'!$K:$K,">"&EDATE(TODAY(),-60)))

Reminders.xlsx‎

View 8 Replies View Related

Creating A Unique List Of Items In Column A That Have A Corresponding Non-zero Value In Column B, I.e. Excluding All Items Where Sumif ColumnB Would Sum To 0

Jul 17, 2009

I know how to use array formulae to create a unique list, i.e.{=INDEX($G$1:$G$760,SMALL(IF(ROW($G$1:$G$760)=MATCH($G$1:$G$760,$G$1:$G$760,0),ROW($G$1:$G$760)),ROW()))}

however this is giving all the unique items from column G and I only want the unique items that have a non-zero value in column H as well. This would be the sumif of all instances that would have to be zero. I've tried to crack it and I've tried to search for solutions but so far no joy.

View 9 Replies View Related

Equipment Hire System - Check If Item Is Already Booked On Upcoming Job?

Aug 9, 2013

I work for a equipment hire company, where various computers and structure are hired out on different jobs. We are getting to a point where keeping track of stock is a problem, we need to quickly be able to check if an item is already booked on an upcoming job, and keep track of home many are in stock. ETC.

View 1 Replies View Related

Extracting Summary List Of Larger List Showing Only Items That Have Quantities?

Apr 11, 2014

It is a product list of office stationary with codes, descriptions and quantities. Using this spreadsheet we input into the quantity how many we want of the item, all well and simple you could call the list a stationary order form.

What I would like to be able to do with this Giant list is to have a function that would extract items off the list into a cleaner consolidated form. As in, if I wanted to order some of item A, C and F, I would like for the second table to just Show ACF without every letter in between or blank cells.

I know a simple method would be to have an IF formula to return the information to a new sheet that I could simply remove blank cell rows (unordered items) and ready for print each time. But I would love to know if there is a better way this could be achieved.

I have basic/intermediate knowledge of excel and can setup the data if need be in order for the function to work, but I can't seem to find the correct function for this project.

View 8 Replies View Related

Remove Items From DV List Once Used / Display Elsewhere / Reset List When Filling Across

Sep 13, 2013

It's a quarterly schedule for utility meter readers, divided up into days across the top, and routes/areas down the side.
There's a space with each route for the employee ID to go, depending on who's doing it.

Down the bottom of the sheet, there's a few empty lines for all the available employees who haven't been allocated to a route.

On the second sheet labelled EMP LIST, is all the employee IDs. It's also got the areas they work- it's for something I want to implement later.

I can put all the employees into a single column list, then use basic DV to give a dropdown menu by each route, to assign an employee to it. This is pretty straight forward. I've also been playing with this in combination with a countif, so that employees already assigned do not appear in the list.

This is about as far as I've managed to get with it.

I need to get the employees who aren't assigned to anything to appear in a list below the routes. I'm fairly sure this is just another countif, but I'm not 100% on the exact formulas.

I also need the list in the dropdown menu to reset for each day of the quarter, i.e. if I assign an employee to a route on the 30th day of the quarter, their ID will disappear from the list for any other route for that day, but will still be there for the other days of the quarter.

So far the only way I've managed to do this is by duplicating the employee list for every day of the quarter, which is going to get very cluttered, and also makes staffing changes difficult. I'm hoping there's an easier way to do this using one data set.

I've added an example of the sheet. It's one week and it's only got about 1/3 of the routes we would actually have on any given day.

scheduledemo.xlsx

View 1 Replies View Related

Getting Conditional Formatted Dropdown List Items To Keep Their Formatting In List

Feb 12, 2014

I found code online that I can put on my sheet to get my formatting properties to stay the same for the items in my dropdown list located on another page. However the code does not work for conditional formatted cells...which is what I need. This is the code that I have that will carry over regular formatted cells. Just not Conditional formatted cells.

View 1 Replies View Related

How To Create A List Of Items For Use In A Dropdown List With Data From A Different

Mar 17, 2007

I Attached a sheet for what i'm asking about ,, i sent it before but the sheet showing it more clearly

View 10 Replies View Related

Count How Many Items Found In List Based On Another List

Oct 27, 2009

I have a list of names in B8:B200 (unique)

I have another list of names in I7:I15

I want to count how many names in B8:B200 that matches any of the names listed in I7:I15.

View 4 Replies View Related

Output Certain Items In A List?

Apr 30, 2014

I'm trying to accomplish the attached. This is just an example of what I want to do. There are no formulas in this spreadsheet.

Spreadsheet 1: Search by Number

Column A is a list of names

Column B is a list of numbers

Column C is a list of the names that correspond to the number "1" from Column B. Note that there are no blank rows between the names.

Spreadsheet 2: Search by Name

Column A is a list of names

Column B is a list of offices

Column C is a list of the names that correspond to office "Williams" from Column B. Note that there are no blank rows between the names.

I have used the index & match formulas to do this WITH duplicates or blank rows, but I would like to produce this without duplicates. I am willing to get as complicated as need be to make this happen.

View 3 Replies View Related

List Of Items In A Column

Nov 1, 2007

I have a list of items in a column. I would like to have a userform pop up with a list box (?) of all the items and I want to be able to select multiple items to perform an action on the row corresponding to the selected item.

I am thinking of other examples I have seen where there are two list boxes (?) and then arrow buttons between them. When you click the arrow the item moves from one list box to the other to see which have been selected.

I have never used list boxes before so if you have a link to some sample code that would be useful.

View 10 Replies View Related

Adding Items To A List Box

Jun 1, 2009

I have the following code used to add items of expired IDs in a listBox,, it actually works well for adding the ID type, but it doesn't add the details of the expired ID completely .. It adds only the details of the last expired ID (I think the code overwrites the details)

I hope that my problem is clear for all,

Can you please find me a solution for that?

View 9 Replies View Related

Dropdown List With More Than Eight Items

Oct 5, 2009

Hi all. I need to create a dropdown list that can handle more than the standard eight rows that data validation allows. My list requires 75 different items in the dropdown. Is there any way that I can do this?

View 14 Replies View Related

Adding Items To List?

Mar 20, 2012

I built a form with a listbox that is populated from a list of products on a worksheet. I want the user to be able to type in a product and if it doesn't match the products already listed I want it to add it to the worksheet list of available products. I keep thinking that I should form an if statement within a loop but whatever I try doesn't work.

View 3 Replies View Related

Moving Items Up And Down In List Box?

Mar 21, 2013

I am trying to move items up and down my listbox2 I have the code below however there seems to be an error with the moving down button

Option Explicit
'Move ListBox Items code
Private Sub BTN_moveselectedLeft_Click()

[Code].....

View 1 Replies View Related

List Items Filtered

Jan 17, 2008

I have a list 10 of names in Column A. ( On sheet 1 )

I then filter column A to show only three specific names, or four names etc. . .

On Sheet 2, in cell A1, I would like to list the three filtered names from column A on sheet1

e.g. if the three names showing in column A ( Sheet 1) are: john, mary, jane . . . then on sheet 2 cell A1, I would like to see: "john, mary, jane"

View 9 Replies View Related

List Unique Items ...

Jun 15, 2009

I have a list of >50 contract numbers listed in cells A1:A350, with several of the numbers listed more than once. What I would like to do is, on a separate worksheet, list each contract number only once, in column A.

View 9 Replies View Related

Listing Items In List Once

Mar 3, 2010

Is there a way than I can take a list of data and create a new list but only listing each value once if there is a duplicate value within that list?

Original List
=========
Apple
Pear
Orange
Orange
Pear
Apple
Peach
Plum
Pear


New List
======
Apple
Pear
Orange
Plum
Peach

View 9 Replies View Related

Count Of Items In List

Nov 21, 2006

I'm new to the forum - I've done a search but cannot find the answer to my problem.

I work in a hospital and have a list of consultants who refer for a particular type of scan over a period of time.
Each time the consultant refers their name is added to a list so I get a list like this:
Dr Smith
Dr Smith
Dr Jones
Dr Smith
Dr Paeker
Dr Paeker
Dr Jones
etc...

View 4 Replies View Related

Data Validation - How To Not Allow Items Already On A List

Jun 26, 2014

I have a cell "project titles" entered in sheet1 that populates into sheet 2 - column "Project titles".

I need to keep the values in this column unique. So can I create a data validation such a way that I won't be able to enter values into this cell that are already on the list. This way I can avoid entering duplicates.

View 3 Replies View Related

Divide A Sum By Number If Items In List

Oct 2, 2008

I basically have lots of lists of 12 cells. how ever some of those lists contain errors (e.g instead of having 12 numbers it will only have 10)

so instead of doing =sum(a1:a12)/12 i want to divide by the amount of numbers in that area in this case 10 so i can get an average.

View 3 Replies View Related

Non-Selectable Dropdown List Items

Sep 9, 2009

I would just like to know if there is a way to add items to a drop down list that cant actually be selected.

Asking because I have a table from which the dropdown list gets populated and the user then selects a particular row but would like the header fields to also be added to the list just for reference.

I have attached the spreadsheet in question for reference.

View 2 Replies View Related

Print All Items In Dropdown List?

Mar 18, 2014

I have about 145+- employees and I made a simple spreadsheet that allows me make a timesheet for every employee. However, I do not want to sit here and select each employee's name and press print 145+ times. Is there another way to do this?

All I would like to do is press print or run a macro and 145 sheets pops out. I have to do this weekly and it would take me an hour to individually do this.

View 1 Replies View Related

Color Code List Box Items?

Feb 1, 2014

I am looking to color code items in a list box called lbActiveItemList, is this possible? If so I would like it to color code based on the value in the 3rd column as follows:

If the value = 'Receive' Color code the item line as Black
If the value = 'Return' Color code the item line as Blue
If the value = 'Relocate' Color code the item line as Green
If the value = 'Lost' or 'Damaged' color code the item line as Red

View 3 Replies View Related

Extract List Of Items From Listbox

Mar 4, 2014

I have a userform and on this userform i populate a listbox with values.

What i want to know is how do i extract ALL the items in the listbox.......not just the ones that are "selected".

View 3 Replies View Related

Vlookup To List Multiple Items With The Same Key

Jan 17, 2006

I want to do a function similar to a vlookup. I want to input a key
into a cell and have the relevant names listed. The problem I have is
the vlookup only shows one of the multiple names. Is there a way to
list all of the names?

Input Key: ____

KeyName
1414BRODRENE DAHL A/S
1880MAN FERROSTAAL AG
2356HEITON BUCKLEY LIMITED
2356HEITON BUCKLEY LIMITED1
2356HEITON BUCKLEY LIMITED2
2356HEITON BUCKLEY LIMITED3
3867STAVANGER RORHANDEL A/S
4367CLEANAWAY LTD
4618ALUKONIGSTAHL GMBH
4618ALUKONIGSTAHL GMBH1
4979MARMON/KEYSTONE ANBUMA N.V.


Ideal Output

Input Key 2356

HEITON BUCKLEY LIMITED //all brought up by a formula
HEITON BUCKLEY LIMITED1
HEITON BUCKLEY LIMITED2
HEITON BUCKLEY LIMITED3

View 13 Replies View Related

Return A Value Based On 2 Items From List

Jan 19, 2009

In Excel 2007, I need to be able to return a value (definition of something) based on what is selected in 2 other cells.

(See Attached)
If in cell C2 I select "competency 1" and in Cell C3 I select "Expert", I need to be able to return the definition for someone that is an Expert in Competency 1 in cell D2.

Then, if in cell C5 I select "competency 2" and in Cell C6 I select "Leading", I need to be able to return the definition for someone that is Leading in Competency 2 in cell D5. And I'll be doing this about 10 times on each sheet.

All the tables with info are in another worksheet. I can do a vlookup if I'm just using one thing to match, but how do I match 2 things to return the definition?

View 2 Replies View Related

Sum Items From Data Validation List?

Jan 6, 2012

I'm attempting to get the sum for an entire row when one particular option is selected from a data list. I'd like to get a numerical total for each cell in the row that has "REQ" selected from the list.

The range of cells that could contain "REQ" are D2:BA2. I'd like the total number of "REQ"s to be listed in A2. And the source for "REQ" is BB2.

=COUNTIF(D2:BA2,"*REQ*")*SUM(D2:BA2)

This doesn't give me an error but the value remains at 0 in A2 when some cells do have "REQ" selected.

I came across these two threads but I still couldn't get it going.

Sum items from Data Validation list
Sum a range if a cell contains a text string

View 2 Replies View Related

Dynamic List Of Unique Items?

Sep 13, 2012

I have a sheet of un-ordered data with duplicates. Looks a little like this:

Sheet2
*
A
B

[Code]....

What I want to do is: on a separate sheet, when the user inputs a Region name, it will return an array of unique Locations under that Region. For example, if the input is "NORTHEAST", the following would be returned:

Sheet3
*
A
B
C

[Code]....

View 7 Replies View Related







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