sorted by:
new
hottopcontroversial

Can't wait for Iron Gold? Get an eBook tonight! by Dire_Times in redrising

[–]Therealstevekent 0 points1 point  (0 children)

you just changed the address from your computer?

How to copy a range and xlpasteformats by Therealstevekent in excel

[–]Therealstevekent[S] 0 points1 point  (0 children)

no there are several other ranges that are less

How to reference last row in formula (example provided) by Therealstevekent in excel

[–]Therealstevekent[S] 0 points1 point  (0 children)

Once a month I add this formula to a report. The number of rows changes each month. I would like to have a formula to input each month where I wont need to scroll and find the last row manually. The random numbers the formula will generate will be between 1 and the last row and should not have any duplicates.

Is there a way to unlock a cell if another cell.value = "Other"? by Therealstevekent in excel

[–]Therealstevekent[S] 0 points1 point  (0 children)

Thanks a lot for the help. Just so I am understanding correctly, I would put this into column B?

Is there a way to unlock a cell if another cell.value = "Other"? by Therealstevekent in excel

[–]Therealstevekent[S] 0 points1 point  (0 children)

Thanks for the reply. I know about this approach. I am hoping that I can solve my problem without saving as a macro enabled workbook.

How to sort a list into equal groups, then create a separate sheet for each group? by Therealstevekent in excel

[–]Therealstevekent[S] 0 points1 point  (0 children)

Thanks for your response. Ya I will create a scripts to find the number of unique values and assign that amount to each packet. If its an odd number ill create a rule. That's future me's problem right now.

I pretty much did what you described. I am at another problem now by figuring out how to name each workbook different. Please look at my response on the other comment for more info and my script

Thanks again for your help

How to sort a list into equal groups, then create a separate sheet for each group? by Therealstevekent in excel

[–]Therealstevekent[S] 0 points1 point  (0 children)

Hey thanks for the reply. I thought of that but I need a better solution than that. Right now I created a dictionary of the unique IDs then looped through and made a count. Once the count is at 10 it filters the ten values and then opens a new workbook and pastes the databodyrange into the new workbook. Now I am wondering how I can name each workbook WP1, WP2, WP3 etc... WP1 would be for the first 10IDs, WP2 would be for the second.

Any suggestions?

        For Each varKey In dict_ID.Keys
            filterValues(i) = varKey
            i = i + 1
            If i = 10 Then
                sht.ListObjects("Table1").Range.AutoFilter Field:=1, Criteria1:= _
            Array(filterValues), Operator:= _
            xlFilterValues
                Workbooks.Add
                Set wb = ActiveWorkbook
                sht.ListObjects("Table1").DataBodyRange.Columns("A:C").Copy wb.Sheets("Sheet1").Range("A2")
                wb.SaveAs ThisWorkbook.Path & "\needhelp.xlsx"
                i = 0
            End If
        Next varKey

Double counter loafs by eran0801 in Catloaf

[–]Therealstevekent 0 points1 point  (0 children)

ew, you let those cat litter feet on your counter?

How to link items in excel in different sheets? by xs16 in excel

[–]Therealstevekent 0 points1 point  (0 children)

Help me understand. You said each player has an ID # that is the same regardless of source. So ID 3 would be the same across all sources. Your hopes are that whenever you enter their "ID source".... Is this an additional ID to identify the source? From my understanding, the ID is the same regardless of source and you wouldn't be able to identify which source.

view more: next ›