city1

I have a table with population in it, I want to lookup one value and get N similar items. Where N = 5 or 10. 1. Get N similar items based on 1 column 2. Get N similar items based on 2 columns Say I lookup City1 I would like to find N similar items to City1 - Population. <tbody> City...

Hi, I am currently using custom sort to sort a big list. I want to apply the custom sort 39 or n times. Sub SortCity2() range("A42:H81").Select ActiveWorkbook.worksheets("Snabb2").Sort.SortFields.Clear ActiveWorkbook.worksheets("Snabb2").Sort.SortFields.add key:=range("A42")...

Hi, I have an outer FOR loop and an inner FOR loop and at the end of the inner FOR loop I am trying to check if a worksheet exists, if it doesn't create it and then dump the value of my array into the new worksheet. At the moment the code keeps generating new spreadsheets and I am not sure...

Hi, I have a list that is broken down by Transaction, but I need to change the orientation of it so the list is by the product (even if there are duplicate items) with all of the corresponding information from that specific transaction. Since I'm not great at explaining I'll just get right...

hello folks I'm trying to sum cell values accross different sheets in a wb, depending whether a sheet falls under a certain category I have a summary sheet where all the sheets are simply added toghther. there are about 40-50 sheets and each of them fall in 1 out of 3 categories. So i listed...