Using 2 Variables To Return Multiple Items From Multiple Sheets
I have a need to populate a summary worksheet using two variables to find data in two or more other worksheets.
I find writing out what I want helps some times so let me try it here.
So my variables are:
Product (there are 22 products)
Supply Less than (inset number)
These are the two criteria I want to use to produce a result.
The next issue is I have 300 stores that carry said 22 products. Each store has a unique number 0001, 0002, 0003 etc. So in a separate worksheet I have a list of the store numbers, and then the products. So each product has the store's number to the left in Column A, Column B has the product name, Column C has the quantity on hand.
What i would like to do on the summary page is select the product, and then select the supply less than or equal to 'x' and then have the stores with the selected product less than or equal to x display below.
The last part of this is then to display (data from an other sheet) on the summary page which contains the quantity of the product selected available at the warehouse for that store.
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Lookup & Return Multiple Items
I am trying to make a search form in Excel 2003 where I can lookup data for a specific value which may have multiple rows. I have several columns, column A Tracking Number, B Order number, C Item Number, etc. For example; Order number S6001 has three item numbers on rows 1,2,and 3. I can get the data on row 1 using the basic "LOOKUP" function but not rows 2 and 3. How do I have all of the line items (rows) returned for that order number.
View Replies!
View Related
IF Statement Using Multiple Variables To Give Multiple Outcomes
I'm looking to work out an IF statement based on a series of dates entered to give 1 of 3 possable outcomes. Where: A1: todays date (exmaple =NOW()) B1: due date (exmaple 10/02/09) C1: completion date (example 12/02/09) D1: status (overdue, outstanding or completed) D1: =IF(A1>B1,"overdue",IF(A1<B1,"outstanding",IF(C1<=>A1 & B1,"completed"))) I know the last part is totally wrong (symbols arranged in that manner), but to clarify i would like the date entered in C1 to override the other statements in the fomula to make it read "completed". If no date is entered in C1 then the formula will return either "overdue" or "outstanding" depending on the other dates in A1 and B1.
View Replies!
View Related
Code To Return Data From Multiple Work Sheets
I have a folder on a public drive. (\CFDIVIX1PublicPurchasing2009) This folder contains multiple sub-folders (the sub folders are vendors which I purchase merchandise from) each sub-folder has 1 .xls file in it. Each file has 1 sheet containing all the information I need to retrieve. Each one of these files has the same header information in cells A1 through I2 so I manually place that when I create this new workbook prior to inserting the macro. Each work sheet has a different # of rows depending on the number of items I buy from that particular vendor but I feel safe saying it never exceeds 250 rows per worksheet. What I need For the macro to pull up the first work sheet and pull out the data from cells A3 through I250 and place that data into my new work sheet in the same format. Then I want the code to move on to the next worksheet and pull out the A3 through I250 and place that data in the new worksheet directly below the last row of data that was pulled in. (Also it would be great if the code ignored blank values. Like if the first work sheet it pulled data from only had data in the first 10 rows I don’t want 240 rows of blank rows before the next set of data) I hope that running this macro will accomplish transferring all of my data from these multiple sheets into a single work sheet containing all of the pricing for all of my vendors. Once I have this I can place a second sheet on the workbook and use a formula to pull out pricing information that I need on a per basis without having to search through 50 vendors to find who it comes from. I don’t control the vendor work sheets that I want to extract data from so I need to use the macro to run it weekly incase my purchasing dept makes changes.
View Replies!
View Related
Combine Workbooks With Multiple Sheets Into 1 Multiple Sheet Workbook
I have about 20 workbooks with different file names for different projects all saved in the same folder. Each workbook has about 10 worksheets and each worksheet is named in a similar fashion in each of the 20 workbooks (eg. revenue, cost, variance etc.). I want to pull out a worksheet named ' forecast' from each workbook into a master workbook so that the master workbook would contain the 20 forecast worksheets.
View Replies!
View Related
Count Unique Logs With Multiple Conditions Of Multiple Sheets
I've got no clue about all this, but I've had to get specific formula examples and fill in the blanks in order for my timesheet to work. There's just one final problem if somebody could please help. This is a timesheet for a 5 day work week. I need to count the number of unique log numbers for a specific activity. The log numbers counted must be unique across the entire week, not just for each day, which means I want the formula to count the unique log numbers across multiple sheets. The formula also has multiple conditions. I got 2 columns. The first part of the formula needs to verify a word, say, "split" and if it does it checks the adjacent cell for a unique log number. If both arguments are true, it counts the log as 1 unit. Here is a working formula for only one page. =COUNT(IF(D4:D29="split",IF(FREQUENCY(C4:C28,C4:C28)>0,1,))) Here's 2 problems with this formula: 1. I will count if it encounters a blank cell in the Log numbers the first time (which will happen as not every activity we do has a log#), but it will stop counting if it encounters a second blank cell. 2. I don't know how to make it work across several sheets. This is an alternate formula which works and skips the blank cells, but I don't know how to add the multiple condition of "split" and to have it work across multiple sheets. I just copied it Microsoft. As I said, I don't understand it, I just fill in the blanks. SUM(IF(FREQUENCY(IF(LEN(C4:C29)>0,MATCH(C4:C29,C4:C29,0),""), IF(LEN(C4:C29)>0,MATCH(C4:C29,C4:C29,0),""))>0,1))
View Replies!
View Related
Adding Multiple Cells From Multiple Sheets With Sumif Function
I'm trying to put together a spreadsheet that tracks disc capacity increases, affected by any incoming projects. I've managed to do so for one project, but would like to for up to 10. The way i've designed the solution (i'm sure there are far more elegant ways, but hey) is thus: A forecast worksheet keeps track of a grand total, taking information from sheets P1 -> P10 (being projects 1 to 10). I am unable to figure a way to add up all the increases from all 10 project worksheets with one succinct formula. What I use so far is: ='P1'!C83+SUMIF('P1'!E82,"=2009 - Q1",'P1'!D82) ..................
View Replies!
View Related
Lookup Multiple Same Value And Return Multiple Corresponding Value In Ascending Order
I have a problem with the formula that look up multiple records with the same values and return multiple corresponding values in ascending order. I am using Excel 2003 and it is a bit complicated to explain so I have attached a sample spreadsheet to show what I mean. What I want was after I have sorted the occurrence value in column E based on column B and I want to correspond the Rank in column D based on column A in ascending order for the same occurrence value in column E. Eg: There is two occurrences for number 1 at E3 and E4, and three occurrences for number 2 at E5, E6 and E7 in column E. Then the Rank for the first occurrence for number 1 in D3 should be ranking 6 and the second occurrence for number 1 in D4 should be ranking 7, so the Rank for the first occurrence for number 2 in D5 should be ranking 3, D6 should be ranking 4 and D7 should be ranking 9 based on column A and B, etc.
View Replies!
View Related
Copying VB To Multiple Sheets In Multiple Work Books
Ive put some sheet code together that i need copied to 12 sheets (jan to December) in 24 workbooks (each workbook has trhe same sheet names). I dont want to alter the actual content of the Excel sheets, I just need to copy VB code from a template (in VB editor) to the 12 sheets in each of the workbooks. Is this possible to do with VB or do i need some other utility since Im using the VB editor....
View Replies!
View Related
Print Multiple Ranges From Multiple Sheets Userform
I inherited a spreadsheet that had an userform where the user checked off which 'pages' he wanted to print. The Ok button routine used if statements to run a routine for each 'page.' Here's an example of the original code for one page: Sub Button2_Click() Sheet7.Activate Run "HorizontalPrintStuff" 'generic landscape pagesetup With ActiveSheet.PageSetup 'specific pageset settings .RightFooter = " Construction Assumptions" .PrintArea = "CONSTRUCTION" 'the named range to print .Zoom = False .FitToPagesTall = 1 .FitToPagesWide = 1 'this changes depending upon the page selected End With ActiveSheet.PrintOut End Sub The problem was it printed each page as a separate print job; and if you print to adobe, you get serveral files, not one file. That and it took a long time to run. So I tried a different tack. If the checkboxes has true, then the printarea is set to that named range. If there were more than one named range on a sheet to be printed, I consolidated them. I did this with a bunch of if statements - very cumbersome. Sheet3.Activate 'Sheet3.ResetAllPageBreaks 'disabled due to errors Run "HorizontalPrintStuff" 'generic landscape pagesetup With ActiveSheet.PageSetup 'specific pageset settings .PrintArea = "DEVBGTALL" 'the named range to print .FitToPagesWide = 4 'this changes depending upon the .FitToPagesTall = 1 End With I haven't shown all the code cause it goes on for 12 sheets containing 16 different printareas. My current muck ups are ..... 1) it prints every printarea/named range on a given sheet (I took out all the if statements trying to debug everything.) Is there another conditional argument that allows for multiple 'trues'? 2) the pagebreaks in printarea/named ranges that are multiple pages (like a 48 month schedule) won't stay set. I've tried both VPageBreaks(3).Location:= and .VPageBreaks.Add Before:= 3) the Sheet1.select false argument is always adding a random sheet to the end of the print job. Don't know why. I can do all this in a recorded macro, just not the selection userform. I've thought about copying to another sheet or hiding columns and rows then printing, but that seems just as cumbersome. To recap, i want to print out, as one print job, multiple printareas from mulitple sheets, based upon checkbox selection on an userform.
View Replies!
View Related
Combine Multiple Sheets From Multiple Books Into One
I have 6 spreadsheets all within the same folder, these are pretty much identical (rows, colums, sheets within them) apart from the names of the files. I then have a master spreadsheet within the same folder where I want to combine all the data, from all the sheets within each book (if that makes sense!) apart from the data on the last sheet within each book as this is the reference data, onto one sheet within this master file. If possible I only want to copy rows accross which have complete data too. So: (names not correct) From book1.xls copy all data on sheets (sheet1, sheet2 etc) except last sheet From book2.xls copy all data on sheets (sheet1, sheet2 etc) except last sheet combine onto masterfile.xls on sheet1. I have searched on here and can only find how to do it with the first sheet in each workbook, not looping through all the sheets in each book. Please see below.
View Replies!
View Related
Multiple Column Lookup Across Multiple Sheets
After going through multiple threads in the forums, I got this code to do a multiple VLOOKUP method. =IF(E2+F2=0,"",INDEX(C2:C10,MATCH(1,(A2:A10=E2)*(B2:B10=F2),0))) It works perfect on a sample sheet. But when im trying to implement it in a sheet with too much data, it always fails. I have attached the sheet I am trying the formula on. I have grayed down the columns which needs formula's. The data is picked out from the second sheet. This is how I have modified the formula to suit me.. =INDEX(Data!$G$2:$G$663,MATCH(1,(Data!$A$2:$A$663=$C2)*(LEFT(TEXT(Data!$E$2:$E$663,"mm/dd/yy hh:mm:ss"),8)=$I2),0)) <<Please note that all the dates and numbers in the sheet are in "text" format for ease of use>>
View Replies!
View Related
Sum On Multiple Critera Across Multiple Sheets
I’m relatively new at using the INDIRECT function, and am having a hard time setting up the syntax for ranges, and even knowing if those ranges will work. I have a workbook with multiple sheets (let’s call them Program sheets) created from a template that contains variable numeric data that I need to sum by creating a formula on a Summary sheet within the same workbook. The criteria for IDing and summing the data from the Program sheets is spread over 3 cells in adjacent columns (let’s call them $E7, $F7 and $J7) on the Program sheets. A string concatenation of these cells will not create a unique string value on any one sheet as there are potentially multiple rows of data on each sheet and across sheets that could have the same value string. The Summary sheet is a report that contains hard-coded values in adjacent cells ($C4, $D4 and $E4) that will match values found in columns E, F and J from the Program sheets. I’d like to have the formula sum all values within the range P7:AA70 across all the Program sheets when the entries into E, F and J cells (from Program sheets) match $C4, $D4, and $E4 cells on the Summary sheet, keeping in mind that there could be multiple instances of the same values over several rows within the Program sheets (that’s OK, because I want each instance to be part of the sum) Here’s a formula I created for summing values found in a range based on a single matching criteria across sheets. Can this be adapted to the new sum formula I need? =SUMPRODUCT(SUMIF(INDIRECT("'"&Sheet_List&"'!G7:G70"),'By-Month Summary'!$G7,INDIRECT("'"&Sheet_List&"'!P7:P70"))) Sheet_List is a named range on a separate tab that lists the names of the Program sheets that I need to sum from. P7:P70 is the range that the sumable data lies in. G7:G70 is the range that contains values that need to match the criteria on the By-Month Summary sheet cell G7. For the new formula, I no longer want to sum based on criteria in the G column, but rather on criteria in the multiple columns I outlined in my diatribe above.
View Replies!
View Related
SUMPRODUCT Multiple Variables
I trying to figure out how to calculate a field based off multiple variables that are dependent on another cell range. I'm looking to count everything in the C8:C49 cell range that contains either "BETA" or "FINAL" in the cell but ONLY if the F8:F49 cell range contains "In Test")
View Replies!
View Related
Chart With Multiple Variables
I am trying to create a column chart in which i want to incorporate 2 variables. However I don't want to use the line for the second variable. What I would like to do is to add the information of the number of deals a company has done on top of the column. So you see a column which gives you the average size of a deal, and the you should see a number at that column to see the number of deals done with that company. To make this more clear I have attached an example. There are 2 tables of which the information I would like to see in one chart.
View Replies!
View Related
Vloookup With Multiple Variables ...
I need to count up the scores from a questionnaire I have developed, which I am having trouble coming up with a formula for. I have 5 different types of sales channels in column A. In columns C, E and G there is the call method they use (inbound, outbound or both) with a 'Y' / 'N' option next to it. Basically, I need a formula that if a sales channel has a Y next to Inbound, then the value 'Inbound' to be returned to the destination sale and if it has a Y next to Outbound then the value 'Outbound' returned to the destination cell and so on. I have attached a spreadsheet to make my problem easier to understand.
View Replies!
View Related
Multiple Variables Count
I'm trying to use two variable to calculate a count. In my attachment I have Name, Balance, and Disabled for the data. I would like to find out how many names has a negative balance and have a "Yes" for Disabled In the Summary part, I can find out the count of who is disabled, but can incorporate the negative balance.
View Replies!
View Related
Sumif With Multiple Items
I am using a sumif formula where if column b is a certain number then it will add up the value in column e. This works fine, however now I wish to add another filter, which is only for it to add the values in column E if the value is b is correct (as above) and also if column c has a value of 100.
View Replies!
View Related
Multiple Items To Lookup
I have a list of products with parts for each. I made a drop down of each product and what I want to happen is after I select the product it will autopopulate all the part info for that specific product. Each part has a description, sku, quantity and price. There are up to 10 parts per product so I dont know how to do this. Normally I would use vlookup or something to that degree but I dont know how to display a bunch of information.
View Replies!
View Related
Msgbox, Showing Multiple Variables
I have a form that when you select from the drop down box and click submit it opens up a message box with the appropriate response however I want it to also return the information from a couple of Text Boxes as well on the same pop up box and some information that is always the same. I am making it display the correct information from the drop down box by a case statement.
View Replies!
View Related
Multiple Variables To Equal Constant
I'm trying to create a spreadsheet that will tell the user how much of two products to use in order to get a desired percentage of total fat. For example: if the total pounds is to be 3000 at a fat percentage of 30%. There would be two products (a lean meat and high fat meat). The percentage of fat in those two meats will change each time. The user will enter those percentages and then the formula needs to tell how many lbs of each to use in order to get the desired percentage of fat. Each time there is a "target" amount of each product to use. For example: 1000 lbs of Lean Meant and 2000 lbs of Fat meat. Those are based on the ideal levels of fat in each. However, sometimes the fat is not at the ideal so the formula has to be adjusted in order to compensate.
View Replies!
View Related
Multiple Variables In A Commission Structure
I'm trying to create a worksheet to calculate ourcommsiion structure, but can't figure out a way to attack it. We have manyvariables (5) in our commission structure based on each order. Here's how I set it up so far: (In Cloumns) A= Order Amount B= "Y" is A-15%; "N"=A C= "Y" is B*20%; "N" is B*10% D= "Y" is B+2%; "N" is B E= "Y" is B+2%; "N" is B F="Y" is B+1%; "N" is B G= SUM(A:F) For example, if the order is $1000, and I answer y,y,y,y,y=$212.5 How do I create the formulas so I can just put in the order amount and the appropriate letter to get the correct commission structure?
View Replies!
View Related
If Statement & Multiple Variables
I have in cell c40 a data validation list with source equal Royal (=Royal) has been created. Royal is a namebox that has a defined list of 7 options (6 actual options plus one that says "select via drop down") : FA4 = Select via Drop Down FA5 = option 1 FA6 = option 2 FA7 = option 3 FA8 = option 4 FA9 = option 5 FA10 = option 6.............. The concept is that FA5 is associated with a value defined in FB5, FA6 is associated with FB6, so on What I want to happen is when I select a value via the drop down selection in C40 eg. "Option 1" that in cell D40 the value associated with Option 1 (found in FA5) returns the value found in FB5 ($10). How do I do this? I have tried a number of "if" statements but no luck.
View Replies!
View Related
Contatenate Across Multiple Worksheets With One Or More Variables
My workbook contains 20 worksheets named Legal1-Legal20. Each worksheet has identical column headings. My goal is to Concatenate the contents of Legal1:Legal20 Cell $D$2(same in all worksheets) IF the text in Legal1:Legal20 Cell $H$2 (same in all worksheets) reads "Open of Record". The contents should be seperated " and ". Please note that cells my be blank on one or more worksheets. Secondly it is possible that only 1 cell meet the criteria and therefore should not be prceeded with " and ". I have successfully come up with a formula using a similar situation above utilizing SUMPRODUCT noted below. =SUMPRODUCT(SUMIF(INDIRECT("'Legal"&ROW(INDIRECT("1:20"))&"'!H2"),"Open Of Record",INDIRECT("'Legal"&ROW(INDIRECT("1:20"))&"'!I2")))
View Replies!
View Related
Sumif Based On Multiple Variables
I am trying to do a sumif based on two different columns. For example In col A I have part #s, in col B i have quantity, and in col C, I have the different representatives. I want to import the qty sold onto another worksheet. In the cell for the total number I want to know, how many of part# 401 were sold by rep A. Here is the sheet that the information will be drawn from: Part#QTYREP 4011A 4023A 4031B 401 1 A Here is the sheet that the information will be output: Rep Part#AB 4012 4023 4031
View Replies!
View Related
Copy Multiple Items From Listbox
I am trying to copy multiple items from a listbox. I have a listbox which populates with all the email addresses in my global address list. From this I select email addresses which move to another listbox. I then want to copy these selected email addresses to a spreadsheet when I hit a button. I can get it to copy the 1st one but that is it. I know this will be very simple to do but I just can't think what it is.
View Replies!
View Related
Multiple Matching Items From Table
I'm working on a travel form, which allows people to enter a travel itinerary. From that, I want to be able to extract the cities where they are spending one or more nights - so that I can then do the calculations for accommodation allowances. I am able to calculate the number of nights stay in each city where there is an overnight stop. But I'm stuck on how to extract every combination of City and Nights where Nights is greater than zero - there is no need to calculate for cities with no overnight stay. I have attached an example spreadsheet. Some notes: - the itinerary and accommodation tables have to remain separate, as they hold more data than in the example, - the itinerary table can't be sorted for number of nights. It has to be in chronological order for each segment! Every lookup function I check out seems to demand a sorted table.
View Replies!
View Related
To Select Multiple Items In A Drop Down
I am new to writing macros and am wondering what is the easiest way to create a drop down and select multiple items separated by comas. The people who are going to input data into this spreadsheet are field people and not technically savvy so need to design something that is just a matter of cliking on the drop down and selecting multiple items and they should show on the same cell separated by commas.
View Replies!
View Related
Copy/paste Multiple Items
I am importing some text files into an excel worksheet. I want to change the format just a little bit. For each date I have 5 rows (pixel: 25, 37, 50, 100, and 200). When I import my data the date is in the same row as my pixel numbers. I want to place the date in another column to the left of these pixel numbers. Below is an example of my "spreadsheet" The first 5 lines (with date "2008_308.txt" next to each pixel number is what I want it to look like and the next (with date "2008_309.txt" is how it is imported with only one date above the pixel numbers. I could do this manually, but I have many years of data to import. And would like a way to kind of copy/paste these multiple items at the same time. Any ideas? .......
View Replies!
View Related
Counting Items With Multiple Criteria
In column A, it contains the monthly salary data of each employee, then in column B, it contains the classification level data, Like Grade A, Grade B and Grade C. In this exercise, it want to find out the statistic as follows: 1. How many employee's monthly salary is below 10K and their classification level is Grade A, B or C 2. How many employee's monthly salary is above 10K and their classification level is Grade A, B or C So any formulars can do that in instead of using the sorting method?
View Replies!
View Related
Sharing Variables In Multiple User Forms
In VBA i have 3 userforms, the first 2 take the data and store them in variables. The 3rd form is supposed to take the variables from the other two forms and do some calculations with them. Although i cant get the 3rd form to take the stored variables from the other two forms. Is there a way to use stored values from other userforms?
View Replies!
View Related
Pulling Items From A Multiple Column Range
I need to be able to pull the information into another section of the workbook and place it into order (ie Black 1,2,3,4) and then drop down to the next row and place Blue 1,2,3,4 etc. I am using a drop down menu to select the Course, and want the times to then populate to the right, each in its own cell. Have tried the loop code available on a few different topics here however has not quite worked.
View Replies!
View Related
Vlookup To List Multiple Items With The Same Key
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 Replies!
View Related
Move Multiple Selected Items To Another Listbox
The following code populates a forms' second listbox (Elements_lbx) with True. No amount of diddling (by me) can get the selected items from form's first listbox (Content_lbx) moved over to the second. (NB. the list box isn't the standard VBA listbox but an open source: ListEX from Marco Bellinaso.) Private Sub CommandButton2_Click() Dim lbx_Sel As Long ' loops through ListBox to test if it is selected For lbx_Sel = 0 To Content_lbx.ListCount - 1 If Content_lbx.Selected(lbx_Sel) = True Then Me.Elements_lbx.AddItem Me.Content_lbx.Selected(lbx_Sel) ' 'Clear the selected item Content_lbx.Selected(lbx_Sel) = False End If Next End Sub
View Replies!
View Related
Multiple Menu Items Under One Heading 2003
I've got several add-ins that I'd like the end user to install and have accessible under one menu item ("Assessments") in Excel 2003. So far, the code below successfully adds the item, but it only shows the item of one add-in. How can I get it to show all the items under the "Assessments" category? Private Sub Workbook_Activate() Run "AddMenus" End Sub Private Sub Workbook_Deactivate() Run "DeleteMenu" End Sub Sub AddMenus() Dim cMenu1 As CommandBarControl Dim cbMainMenuBar As CommandBar Dim iHelpMenu As Integer Dim cbcCutomMenu As CommandBarControl
View Replies!
View Related
Selecting Multiple Items From A List In One Cell.
Is it possible to restrict the values of cells in a particular column to entries defined in a list BUT to allow each cell in that column to display multiple items from the list (seperated by a comma for example). I've attached an example of what I would like to do - In Sheet "2010 Data" I want to be able to select multiple values in column F....(the values are defined within the list named "Platforms" on the worksheet called "Lookups"
View Replies!
View Related
Creating Drop Down Lists With Same Multiple Items
Looking to create a drop down list on the top of a column that will find all entries with that numerical value. For example, lets say I have four entries with the value 1234 spread out through the columns. When I click the drop down menu, it should only have 1234 once and when I click it, it shows me all the rows with that entry.
View Replies!
View Related
Index Match Function For Multiple Linked Variables
I have a worksheet that has 6 columns of numerical data that all column datasets are referenced together for each row. So for example the data in row 5 in all colums is related. Column C through F have 4 numbers that refer to the data in the first 2 columns. These are also ordered by row. I need to look in column A for 0.00, and column B for 3.14 Both of these must be in the same row or I need the closest value. When these values are found in columns A & B, return the values from the same row in Columns C through F.
View Replies!
View Related
Calculating Totals For Items With Associated Quantities Over Multiple Rows
I am trying to accomplish is to associate each product on the Distribution tab in 'E' to its associated quantity in 'F' so I can count the total number of each product and display this in 'D' on the Totals tab. Once this is done, the total for each product would me multiplied by the associated price in 'C' on the Totals tab to achieve the total item value for each item in 'E'. I have included the current results and what the correct values should be. As you can see, I tried to use 'Countif' with no success. I could not find any solutions in the forum that were close enough to this situation to work.
View Replies!
View Related
Lookup Details For Multiple Chosen List Items
I was wondering if there was a way to create a pop-up list to appear when a user selects a certain cell that would provide the user with a list of (in this particular case) inventory items. The user would select which items they require for the task at hand and the total $$cost of the items would appear in the cell once is is deselected.
View Replies!
View Related
|
TRACKER
