Find Cells That Sum Up To Given Values

Sep 11, 2006

I have a coloumn (i.e. A) with hundreds of numbers. I'd like to be able to write a number in a cell (i.e. B4), and have Excel find and tell the coordinates of those cells in coloumn A that sum up to the result I wrote in B4. I also would like to be able to "hit a key" and see the next possible set of result-cells.

ADVERTISEMENT

Forcing Cells To ALWAYS Find MIN And MAXIMUM Values From A Specific Range Of Cells

Feb 1, 2010

I'm working on a project for my company. We make plastic tanks and for quality control we want to start recording the thickness of the tanks in different areas/zones of each tank.

Attached to this message is an Excel sheet that I've been working on. From "Sheet 1", it records inputted thicknesses into WorkSheet "1098". On the top of "1098", it shows all of the recordings, and just below that are the "10 Most Recent Entries".

Right below the "10 Most Recent Entries", there are formulas to calculate the Min and Max Values. Whenever a new entry is recorded, the selected cells for the Min and Max formulas change. Is there a way to force the cells to always stay the same?

View 3 Replies View Related

Find Cells That Sum Up To Given Values

Sep 10, 2006

I have a column (i.e. A) with hundreds of numbers. I'd like to be able to write a number in a cell (i.e. B4), and have Excel find and tell the coordinates of those cells in column A that sum up to the result I wrote in B4. I also would like to be able to "hit a key" and see the next possible set of result-cells.

View 7 Replies View Related

VBA Cannot Find Values In Cells Formatted As Table

Jun 9, 2014

I am pretty new to VBA and have been wrecking my brain and reading just about every Thread there is on this and still can't figure out why I am not getting the code to work.

I am trying to get data from Column "Sale Price", stored in Table "MasterInventory" on worksheet "Master Inventory" to populate a textbox in a UserForm by means of Vlookup.

Upon running the code below I'm getting Value Error 1004, and during Debug when I hover over "MasterInventory" it shows "MasterInventory=Empty"

Also Im trying to figure out how to do it so I can call the "userform" up from any worksheet and add the entries in the table on worksheet (Jan, Feb, Mar, etc.) for the month depicted in the TextBox "Date" on the Userform

The code looks like this:

Private Sub CBx_PROD_AfterUpdate()
'lookup value in Col F [Sale Price] based on Product (Col A [Description] in Table [MasterInventory])
With TB_SP
If OB_Y.Value = True Then
Me.TB_SP.Value = Application.WorksheetFunction.VLookup(CBx_PROD.Value, MasterInventory, 6, False).Value
End If
If CBx_PROD.Value = "" Then
Exit Sub
End If
End With
End Sub

View 6 Replies View Related

Find And Replace Different Values In A Range Of Cells

May 8, 2008

I would like to be able to replace all cell values in a range of 20c by 20r (i.e. 400 cells). In all cases the condition would be the same (find all cells with a value greater than than zero), but then replace with different values.

e.g. Cells with value >0 in range CX119:DQ138 replace with "NT", then cells with value of >0 in range DR119:EK138 replace with "NU"

I thought you could do it with find and replace by just selecting that range of cells but can't see how to set the conditional >0 bit.

View 9 Replies View Related

Find Average Of Absolute Values Of Visible Cells

Apr 20, 2013

I am trying to calculate the average of the absolute values of a range of visible cells. I use filters to extract the data rows I need from a large spreadsheet. Then I need to calculate statistics on the resulting data, i.e. the visible cells. The line I am using to calculate this is:

VB:

ThisWorkbook.Sheets("Tracker Channel Stats").Cells(newRow, 4).Value = WorksheetFunction.Average(Abs(R.SpecialCells(xlCellTypeVisible)))

However, what I get back is simply the value of the first visible cell in the range, i.e. the average of the absolute value of one number is that number. how to make this work

View 1 Replies View Related

Find And Replace Multiple Values Within Individual Cells?

Mar 13, 2014

So I have a list of organizations in Column A, with multiple names (anywhere from 0 to 50 names) for each org. in Column B.

Org
Names
Company A
Brown, Jones, Smith, West

[Code]...

I want to do a find and replace for all of Column B, where all the names are replaced with their respective color values. If possible, I'd like this to all happen with the individual cells (so for example, B3 might go from "Brown, Jones, Smith" to "Red, Red, Blue").

If that's not possible, I could divide all the names into individual cells and then find and replace.

View 3 Replies View Related

Find And Copy 10 Values - Paste To Various Cells On Second Sheet?

Jan 7, 2013

Purpose:
Build a roster from:
Sheets(Settings).Range("A21").Value (this value is variable)

Problem:
Find that A21 value in Range T2:T100 (each value in the range is unique)
Copy that value to Sheets("Roster") E8
and the next 9 values to
E14
E20
E26
E32
G2
G14
G20
G26
G32

Reason for posting: I've been trying to do this with vba but sheet formula will probably work, I can always Copy/Paste Special/Values to clear the formula. Keyword searching has resulted in no progress.

View 2 Replies View Related

Macro To Find Correct Data In Cells That Have Multiple Values

Jan 27, 2014

Script Example.png (Picture)
Script Example.xlsx (Example Workbook)

I have a report that I pull that I pull fairly often that is in this format and shows which footage of products each store is getting (out of over 1800 stores)!

Above is the format that it comes back as. And here is a spreadsheet that shows what steps I take to find correct values in detail.

So each FTG has an ID# and Desc. The ID is in text format and each ID is seperated with a comma, no space. Description also. Date is seperate by a space and comma. Stores change footages a lot so I want to find out which footage is effective today (1/27/2014) For ex: Store 63 would have the 5ft effective right now because we are between 5/23/08 and 5/22/14. So each ID# and Ftg Description is in the same order as Date.

When I have hundreds of stores, it is difficult to go through and get each one (even with the way I've been doing it.) But my ultimate goal is to create a macro to put only the current footage ID#, Desc, and Date in Columns C,D,and E. I'm not sure even where to start with doing a macro.

I usually just find the store with most ftgs, count them, insert that many rows after ID and Description columns, then do a text to columns (comma, delimited), sort by 2nd date column (so they all come up top) and then manually go through them and delete unneeded columns once I have them all.

View 7 Replies View Related

Histogram Function: Find Number Of Cells That Falls Within Each Of These Max Values

Nov 21, 2006

i m given 12 max value of my 292 cells. now im asked to find number of cells that falls within each of these max values?? im asked t use histogram. how will i do it?

View 3 Replies View Related

Find If Duplicate Values Exist In A Column, Concatenate Cells And Then Delete

Dec 17, 2009

I want to do, is search column A for claim numbers that match. When I do have a matching claim number, I want to concatenate the original cells ownership field with the said matching cells ownership field (or move into a column in the same row, I can always concatenate later). Once that is complete, I want to delete the row I took the information out of.

I want to join this data in ArcGIS, but as of right now, it's not a 1-to-1 relationship, so only a relate works. That doesn't help me as I want to display claims by ownership, and this can vary per claim. Company A may have 100% on one claim, and then split another claim 50% with Company B.

This causes a double entry on the claim field in this current spreadsheet I have, which requires me to clean it up by making multiple columns of ownership vs. an additional row for shared ownership.

My problem:

Column A Column B
1235555 Company A (50%)
1235555 Company B (50%)
1235556 Company A (100%)
1235557 Company A (33%)
1235557 Company B (33%)
1235557 Company C (33%)

What I would like to see

Column A Column B Column C Column D
1235555 Company A (50%) Company B (50%)
1235556 Company A (100%)
1235557 Company A (33%) Company B (33%) Company C (33%)

View 3 Replies View Related

Find Current Date On Several Sheets & Convert Surrounding Cells To Values

Dec 2, 2009

I keep track of values in a workbook. I accumulate them on a daily basis (business days) and keep track of the older values.

On the first sheet I have all current values automatically displayed.

All subsequent sheets contain the values for the different locations (>60) by one location per one sheet with multiple entries per location.

Most of the values do not change daily. So I copy the values from the previous day and paste them to the current day’s fields (the row below yesterday's values).

Today’s date (and prior dates as well as subsequent dates) are in column A, the values to be copied are in column B through AZ. With over 60 sheets this job becomes very tedious very quickly...

What I would like to be able to do, with a click of a button, is to go into each sheet (except the first one), go to the current date (in column A), select the field to the right of that date (in column B), go up one field, select both fields (today and last business day) and go from B to AZ (or A to AY in relative terms) copy all those entries, go down one field (to the same row as today’s date) and paste the content. Then repeat that for every following sheet…

As the date field that I am looking for goes down one field with each day I cannot use fixed points to copy and paste from, but have to use the date field as an anchor from whence to find the proper cells.

I do have some values in the following day's fields, that is why I need to copy two rows and not just the values from the previous day...

View 4 Replies View Related

Adjacent Cells - Search For Specific Values And Find The Total Number Of Instances

Jan 30, 2014

Any method to determine the number of instances a value ("4" for example) appears next to a specific value ("x" for example). I don't have a workbook; I'm just looking for any formula that can search for specific values and find the total number of instances that an adjoining cell contains data.

View 14 Replies View Related

Using Vlookup Or Similar Function To Find Missing Values Compared To Base Values

Apr 30, 2014

I am trying to find some missing values compared to 6 base values. For instance, I have a sheet with some names translated to another language, I am trying to find the languages some names have not been translated too.

For example, if I have six languages, Arabic, Japanese, Russian, Chinese-Simplified, Chinese- Traditional, and Korean to compare too, I want to find any names that are not translated in certain languages.

Sample:

John Japanese
John Chinese - Simplified
John Korean
Martin Arabic
Martin Chinese - Simplified
Martin Russian
Ramon Arabic
Ramon Russian
Sam Arabic
Sam Chinese- Traditional

View 1 Replies View Related

Find Same Values In Different And Unequal Cell Ranges And Refer To Values

Jul 2, 2009

I have data similar as shown in the following:

A1A11
B2AA1122
C3B22
D4C33
D44

The idea is to add compare the cells of the first column with the third column. Where same letters/words exist, the corresponding value of the first column should be added to the second column (where no letter exists equally, the space remains empty), so it will look like this

A111
AA1122
B222
C333
D444

the third column always will have at least the same letters as the first column, but new letters/entries can occur.

View 3 Replies View Related

Compare List Of Values In Order To Find The Common Values

Feb 11, 2013

compare some list of values in order to fiind the common values.

View 1 Replies View Related

Formula To Find The Sum Of Values That Were NOT Equal To My Quoted Values

Aug 21, 2008

Trying to find the sum of all cells in the array described in the formula that are equal to the values inside the quotations. I used this exact (as far as I can tell) formula to find the sum of values that were NOT equal to my quoted values and it worked just fine. Any ideas why formula 'A' will not work but formula 'B' does work? I have a feeling I'm missing something simple here!

Formula A - Does not work:
=SUMPRODUCT(--('Master Lead Sheet'!$J$2:$J$10000=$B2),--('Master Lead Sheet'!$N$2:$N$10000="REJECTED"),--('Master Lead Sheet'!$N$2:$N$10000="CONDITIONED"),--('Master Lead Sheet'!$N$2:$N$10000="APPROVED"))

Formla B - Works:
=SUMPRODUCT(--('Master Lead Sheet'!$J$2:$J$10000=$B2),--('Master Lead Sheet'!$N$2:$N$10000"No Answer"),--('Master Lead Sheet'!$N$2:$N$10000"Disconnected"),--('Master Lead Sheet'!$N$2:$N$10000"Wrong Number"),--('Master Lead Sheet'!$N$2:$N$10000"EMAILED"),--('Master Lead Sheet'!$N$2:$N$10000"needs to be emailed"),--('Master Lead Sheet'!$N$2:$N$10000"Refund"),--('Master Lead Sheet'!$N$2:$N$10000"REFUNDED"))

View 9 Replies View Related

Macro: Find Duplicate Values & Sum Values. Per Day Basis

Oct 13, 2006

I have data that looks like this:

day# id amount
1 56575 0
1 56675 0
1 56680 0
1 56683 0
1 56681 0
1 51810 0..............

How do you write an excel macro that looks at the number in the first column (day #) and finds all the duplicate id#s in the second column that are in day 1and adds the amounts together in the 3rd column then writes the first column number (day#), second column number(id#) and the third column (sum of the amounts of duplicate Id#) to an new worksheet. Then the macro would loop through day #2 and do the same thing. Notice that the values in the id column are unique in this data set below this is how I would like the data to look. I have accomplished this in a pivot table but my problem is I need a cvs file to export the final data into an external database which is why I need a macro.....

View 2 Replies View Related

Determine Values In Cells: Get The Lower Values Between To Cells And Have The Lower Valued Cell Highlighted

Oct 27, 2009

I M trying to get the lower values between to cells and have the lower valued cell highlighted,,,i have over 43 thousand lines of data to go throughand i was wondering if there was a quicker way to do this,,,for example cellA1 is $4.25 and cellA2 is $5.25 i want cell A1 to be highlighted,,is there a way?

View 2 Replies View Related

Sorting Values: Find Points With Similar "y" Values

May 5, 2008

I have x coordinates in column 1 with coresponding y coordinates in column 2. From my data of x,y coordinates I want to find points with similar y values. In my data I have defined groups of numbers, i.e. I have a set of numbers with y values around 30 (+-10), then a new group with y values around 60 (+-10), and so on... Sometimes the groups are not totaly separeted, there could be a few points with y values between 30 and 60. These points can be grouped with the closest group of coordinates (30 or 60). Each group of x,y coordinates could be copypasted in the columns to the right (columns 3 and up).

So what I want to do is find a group of coordinates. This group will have at least 40 individual points +-10 from a group mean. The coordinates need to be sorted out from the data and put in seperate columns.

View 9 Replies View Related

Values In Each Cells(A) Represented Back At Cells(B) But No Repetition If Some Cells(A) Contains Same Value

Dec 9, 2008

I did my search, but cant find and knows what key search to look/type for...

If i have data A1 through A10, such as 1 1 2 2 2 2 3 3 3 3

How can i get column B1 through B3 as 1 2 3 ?

View 9 Replies View Related

Generating Values In Number Of Cells Based On Adjacent Cell Values

May 22, 2014

What I have In Column B, I have the datesIn Column I, I have engineers name What I need I want a macro to generate Serial Nos. (1,2,3....... n) in column A If an only if the date in column B is today's date and the engineer's name matches with the PC's username

The following is my code

[Code] ....

Above code runs without errors but does nothing.

View 4 Replies View Related

Find Function Not Working On Cells Which Reference Other Cells?

Oct 31, 2011

I am using the find function to establish the row number in a spreadsheet for an edit process.

Code:
wks.Range("B:B").find("something").Row

the cells in Range("B:B") are linked to another worksheet. If I copy paste values on the cells in Range("B:B") the code above works a treat.

View 4 Replies View Related

Find Value In Cells, Merge Found Cells To One Column

Jun 23, 2007

I need to mine a huge spreadsheet of about 30,000 cells and make columns from specific words. As in.

I need to search for all words "table" even if the word is "My_table" or "aTable" and suck them into one column. I have to do this one several words.

Let me know if you have the solution. I am trying to write something but I am unsure of the syntax at this level.

View 9 Replies View Related

Replace Values In Range Of Cells With Varying Values?

Mar 14, 2013

I am trying to replace a range of cells with certain values but I can not figure it out. I'm almost there I think but don't know how to get the varying values I'm looking for. So I have a column (AJ in this instance) that has a bunch of "xx" values at different spots within the column. I want to replace those xx values with numbers 01 through 36. What I have below gets me just about there but it replaces every xx value with 01. How do I get it to go 01 on the first one, 02 on the second one, etc?

/code
Dim cell As Range
For Each cell In Range("AJ1", Cells(Rows.Count, "AJ").End(xlUp))
If cell.Value = "xx" Then _
cell.Value = "01"
Next cell
/code

View 3 Replies View Related

Find Values For Key

Oct 6, 2009

I have table values like below in sheet

Key values
ABCD
ACDE
BFGH
CIJK
CJKL
CKLM
BGHI

If i enter Value B in one of cell, it should pick values of FGH, GHI. Can this be done using formula or other methods??

View 2 Replies View Related

Find Containing Values

Feb 18, 2009

In Excel 2007 can you do a find that contains multiple valued cells? I know you can find one at a time but it takes to long.

Example.

column A

5963190,7281143,7283188
4559000
7286000
7289696
5963499,5962468
5881017,7281176,4556060

That is my list to search in.

Here is the list to find that may contain these values.

7289696
2419888
9741452
7283188
7281176
4997755

If either match I need them to Highlight a different color.

This will not work under the duplicate format because it will not pick out what may contain it will on pick exact.

View 9 Replies View Related

Sum The Values In Cells Based On The Values Other Column

Apr 25, 2006

I want to sum the values in cells E2:P110 based on the values column D. The
values in D are formulas resulting in something that appears to match D112 in
some cases. I'm using the following equation:

=SUMIF(D2:D110,D112,E2:P110)

My problem is that D2 :D10 have a formula in it and it's not matching. If
I enter the result of the formula, all is good. How should I deal with this?

View 11 Replies View Related

Find Values Corresponding To First And Last Day Of A Month?

Jan 28, 2013

I am looking for a smart way to extract the values corresponding to the first and last day of a month I specify from my time series. Column B has the dates (dd/mm/yy), column A is text(B,("mmm-yy") and column E has the values I need to extract. I have a column with all the months of the year: Dec 12, Jan 13, Feb 13 etc... and I need to pick the value in E that corresponds to the last observable day of each month and divide that by the value corresponding to the first observable day of the month.

[URL]

View 5 Replies View Related

Find Two Values In One Column?

Mar 11, 2014

I've got two question on how to 'find' some values in a specific data file, namely:

- the '52-Week High' of the share price (highest value of the share in that specific year)
- the value of the share price of the last trading day of that specific year (this isn't always 12/31/20..)

Simplified, my data looks as follows:

-In column 'A' I've a created a line of unique edentifiers (company CUSIP + year -> combined column D and E), in my set this column consists of 405 companies over 6 years of daily data -> aprox 460000 rows
-In column 'B' the date is shown -> its daily trading data
-In column 'C' the daily share price is shown
-In column 'D' the company's CUSIP (edentifier for specific company)
-In column 'E' the year

Sheet 1:
1.JPG

My final data set has to look something like this:
-In column 'A' the unique edentifiers (company CUSIP + year)
-In column 'B' the specific year
-In column 'C' the '52-Week High' of the share price (highest value of the share in that specific year) -> red numbers from sheet 1
-In column 'D' the value of the share price of the last trading day of that specific year (this isn't always 12/31/20..) -> green numbers from sheet 1
-> off course all the empty cells in column C and D normally contain the missing values

Sheet 2:
2.JPG

The big question is how do I manage to identify the red and green colored values (and link them to 'sheet 2')?

Regarding to the '52-Week High' (red colored in the sheets) I've already tried with the following functions:
- VLOOKUP: When I use this one I only get the most upper value, for example in the case of '8668102001' this would become '12'
- Combined INDEX/MATCH: The same problem as with VLOOKUP
- IF-function:In this case I get the max value of the entire 'C'-column, in the example of sheet 1: this would be '115'

Regarding the value of the share price of the last trading day of a specific year, I couldn't manage to come up with one.

View 5 Replies View Related

Find Values That Appear In Various Columns

Apr 18, 2014

I have 6 columns containing Agency IDs of different years. I would like to know which agencies appear in all the years. That is which agencies were funded for all the years. How can I do this? perhaps Vlookup?

View 11 Replies View Related

Formula To Find Value In Between Two Values

Apr 29, 2014

Bonus calculation model...

100% of sales target = 100% of bonus
110% of sales target = 125% of bonus
120% of sales target = 165% of bonus

etc...

How can I solve for someone who books 107% of sales target?

View 4 Replies View Related

Find The Average Values

Oct 4, 2008

Column B: The day of the week that the date is, Sunday, Monday, etc.
Column C: Every date in 2008
Column D: my data (the number to be averaged)

What I need the formula to do:
Look in Column B for every instance of "Sunday", and count them up (they count only if the data in column D is not 0) and use that number to average the number in column D

So if I have 52 Sundays and we are only 4 weeks into the year and the 4 data points are 50, 100, 75, 25. The average will be 62.5 instead of 4.8 (divided by 52).

View 6 Replies View Related

Find Top Ten Values And Return Value From Another Row?

Nov 23, 2013

I have a huge data base (daily temperatures dating back to 1872), but for simplicity I have limited the values to just a month for this question. What I want to do it list the ten warmest temperatures and then return the date in which it occurred. I am using the following LARGE function to get the ten warmest temperatures (Column B - high temperatures).

=LARGE($B$2:$B$31,$D2)
Column B = High Temp in Data Table
Column D = Rank in Results Table

This works great. However when I use the following Index function to get the date in which it occurred (Column A - Date), it keeps returning the first date in which it occurred when there are multiple occurrences of the same temperature.

=INDEX($A$2:$A$31,MATCH(LARGE($B$2:$B$31,$D2),$B$2:$B$31,0))

Column A = Date in Data Table
Column B = High Temp in Data Table
Column D = Rank in Results Table

In some cases, I have more than 2 occurrences of the same temperatures. For example, the high temperature of 23 degrees occurs 3 times during the month (1/4/2013, 1/11/2013, and 1/12/2013), but only the first one 1/4/2013 shows up in my results table. I would like the other dates to show up. These tables are listed below.

Data TableResults Table
DateHigh TempRankHigh TempDate
1/2/201311271/5/2013

[Code].....

View 3 Replies View Related

Find Part And Add Values

Apr 16, 2009

I don't know if this is even possible via VBA, but thought I'd throw it out there and see what you guys think.

In the attached workbook column D contains fields for the UsagePN. If a part is "rolled-up" in our order system to a new part number, then the OLD part number, (in colmn B), is associated with a UsagePN. What I need to do is, for every part that has a UsagePN in Column D, I need to find that part number in column B and add the inventory values from the old part number to the new one.

For Example:
Row 74 in the attachment has a UsagePN of AC1230105V. I need to take the values from cells G74 thru K74 andd ADD them to the existing values in G77 thru K77, which are the inventory values for AC1230105V.

In other words, since part number AC1230105 has rolled-up to the new part number AC1230105V, I need to add all of the inventory to the new part number, AC1230105V.

After this is done for ALL parts with a usage part number, I will delete all the rows containing UsagePN's.

Here's the catch, as you can see in the example, there is no consistency, so a simple formula like adding the values to the same part number with a "V" at the end won't work. I guess you would have to do something like for each row with a value in column D, dim that row so you can refer back to it, then search for a match in column B, insert a "helper" row below where the part number is found to add the quantities, then replace the original with the helper row, and then delete the helper. One of you guys probably knows a better way.

Keep in mind that you won't always find a match, so the macro needs to continue to the next part if no match is found.

I hope I was clear. This one looks like it will be a nightmare, but I hope somebody on here has some ideas.

View 14 Replies View Related

Find/Replace Values With X

Jun 8, 2009

I've got a piece of code I'm stuck on. Basically, I have a range of data and most cells are empty. However, I want to replace all the nonblank cells with an X. I can't quite figure out how to have the code replace something non-specific...

View 3 Replies View Related

Find String, Add Values

Aug 2, 2009

1) Find strings "CA", "Ca", "ca", "California", "california", "cali", "Cali" in Column F

2) If the string is found, then record the Real value at Column D of that row in Column I

3) Continue this until there are no more strings in Column F

4) Add the values recorded in Column I and display the final value at the bottom of the list.

View 2 Replies View Related

Find Values That Equal Sum

Dec 5, 2012

I have a spreadsheet that has a number of values and a separate sheet that has a paid total. What would be the easiest way to find the values in sheet 1 that total the sum in sheet 2? There may be more than one possible solution as to the items that total the sum.

View 1 Replies View Related

Find Last Empty Row And Sum Up All Values Above?

Dec 13, 2012

I am looking for a VBA code which will search for a last empty row in given range, and sumup all the values above it in the same cell...this has to be repeated for other columns as well. The column and row numbers may vary depending on another code. In any case the summation has to be in the last empty row...The excel table should look like as below, the last row is summation of all the values above..

A B C D
1 - - -
2 - - -
- 3 - -
- 4 - -
- - 5 -
- - 6 -
- - - 7
- - - 8
3 7 11 15

View 2 Replies View Related

Find Intersection From Known Values

Nov 20, 2013

I have store numbers (#3, #5, #6) (not consecutive, but ascending right to left) across the top, and dates (11/19/2013) ascending down the left.

I know date, I know store number. I need VBA code (excel 2000) to move cursor to the intersection of the two.

View 9 Replies View Related

Find The Lowest Values ...

Jan 19, 2007

i have in the range (Ag1:an1)the names of the months from january- august)in the range (Ag2:An55) ihave numbers in every cell now in every row for example Ag2:An2 i want to find the values less than 50 then i want to write thier month's names in the cells from Ap2:Aw2 i want to do this with every row from row 2 to 55

View 9 Replies View Related

ADVERTISEMENT