# Posts by cambos444

• ## Returning 10 largest values when looking up in a list!

It's still just filling in the top location without taking into account "CA". Sorry!

• ## Returning 10 largest values when looking up in a list!

Well I feel like we're close! That formula is now pulling through the Top 10 locations, but not "CA" specific. I'm getting numbers, just not the right ones!

• ## Returning 10 largest values when looking up in a list!

Still no luck, I did press C+S+E.

The formula is working because if I amend "" to "9" at the end, a 9 appears. However, values from "CA" are just no pulling through.

• ## Returning 10 largest values when looking up in a list!

I didn't get an error but it didn't seem to work - the cell is just blank.

What would using "ROWS" do? I agree with the first part of the formula (I had tried this already).

• ## Returning 10 largest values when looking up in a list!

No I don't believe so - we run Excel 2013.

• ## Returning 10 largest values when looking up in a list!

Hi there,

I am trying to look up the top 10 values in California (or "CA" in the example) and then return them into a different sheet.

In the attached example, I would like Sheet 1, F5, to have the largest value in California, having looked up from column H in sheet 2. I would then like the second, third, fourth etc. largest values down to 10.

Sheet 2 - look up column H for "CA", return value in column C.

Columns D and H both have formulas in.

I've tried Large, IF. INDEX, Large, IF and can't get anything to work.

Any help would be greatly appreciated!

• ## For Without Next?! Help!!

Genius! Thank you. And if I want to paste the cells as values rather than formulas is that possible? Thank you.

• ## For Without Next?! Help!!

Thank you! I'm now getting an "Object Required" error on line 20 so I'm obviously really wrong on this one. Still learning!

• ## For Without Next?! Help!!

I'm getting a For without Next error and need help finishing this code:

• ## How to Copy/Transfer Selected Cells from Data Sheet into a separate Table if Row contains a certain word

Click “Summarise” button

“Bound” and “Quoted” from column F

P10m sheet – A7 into “Summary” Tab A6

M7 into “Summary” Tab B6

U7 into “Summary” Tab C6

L7 into “Summary” Tab D6

Sort into descending order on column D premium values.

If I were to add a second tab for example “\$15m xs \$10m” tab, it would add a separate table in the “Summary” tab next to the original table. Can this table be added automatically?

\$15m xs \$10m sheet – A7 into “Summary” Tab I6

M7 into “Summary” Tab J6

U7 into “Summary” Tab K6

L7 into “Summary” Tab L6

Is there a limit to the number of times I could do this?

• ## How to Copy/Transfer Selected Cells from Data Sheet into a separate Table if Row contains a certain word

Hi there, I am VERY new to VBA code and hoping someone can help with what is probably a very simple bit of code.

I have a data sheet (Sheet 1) with rows of data in it. If I select a dropdown in column F7 to "Bound" I then want to be able to transfer selected cells (A1, M7, U7 and L7, in that order) into another table on a separate tab.

I want to transfer A1 into A6, M7 into B6, U7 into C6 and L7 into D6.

I have managed to use the follow code to recognise the word "Bound" but I can't work out how to transfer only selected cells.

Any help would be greatly appreciated!