Posts by zotee98

Re: Text Color Based on Cell Color

wonderful - exactly what i needed - thanks for the help.

i am using the gradient conditional format to set the cell color based on cell value but i need the text color to match the cell color. is there a way to do this with vba or standard built-in function?

thanks for the help.

does anyone know why excel updates external links when moved with partnered (linked)spreadsheets to new locations. basically i have 3 workbooks that are linked to each other and when i copy all of them to a new folder excel repaths the links to the folder i copied the spreadsheets into. this seems dangerous to me. i might not want the paths to change. any thoughts from others or am i alone in my thinking?

Re: Select Every Nth Cell In Column Range

thanks for the quick reply and help however -

unless i am doing something wrong its like it can only run for some many lines - like it can only handle doing this 100 rows or somewhere around there? any thoughts?

thank

What is the best way to select every third cell in column c starting with cell C5

Is there a formula or function that will return unique values in a column only. I have 1 column with a large data set with many duplicate items and i need to know only the items that are showing up. i have tried advanced filter but i havent had good luck. any ideas?

Re: Copy Sheet Data To Other Sheet

what would be the change for overwritting? - so yes i am overwritting

i need a macro that will copy the information from backup and backup2 from cells b7 to the end of the data set and copy it to the master sheet. i just dont know how search for the last unused row. thanks for the great help. the values on the backup sheets can change in numbers of rows.

Re: Return 3 Rows Above

sweet that worked great - thanks

i need a formula that searches for a value in column 1 returns the corrseponding cell in cloumn 2 in cell c6 then returns the 3 rows above the value in column 2. please see attached spreadsheet for clarification.

Re: Store Macros In Remote Folder

sweet worked like a champ - thanks

is there a way to store macros in a remote folder that load with excel so frequently used macros can be run without having to write them into the workbook? thanks

Re: Copy Data Loop

wow that worked great - thanks - this forum is sweet![hr]*[/hr] Auto Merged Post;[dl]*[/dl]

Sub CopyQTY()
    Dim ws1 As Worksheet, ws2 As Worksheet
    Dim x As Integer
    Dim sht1Rows As Long
    
    Set ws1 = Worksheets("Sheet1")
    Set ws2 = Worksheets("Sheet2")




    For x = 3 To ws2.Range("A" & Rows.Count).End(xlUp).Row
        sht1Rows = ws1.Range("C" & Rows.Count).End(xlUp).Row
        ws1.Range("A" & sht1Rows).Offset(-4, 0) = ws2.Range("A" & x).Value
        ws1.Range("B" & sht1Rows).Offset(-4, 0) = ws2.Range("C" & x).Value
        ws1.Range("B" & sht1Rows).Offset(-3, 0) = ws2.Range("D" & x).Value
        ws1.Range("D" & sht1Rows).Offset(-3, 0) = ws2.Range("B" & x).Value
        
        If x = ws2.Range("A" & Rows.Count).End(xlUp).Row Then Exit Sub
        ws1.Range(Cells(sht1Rows - 7, 1), Cells(sht1Rows, 8)).COPY ws1.Range("A" & sht1Rows).Offset(1, 0)
    Next x
        
End Sub

why can i not do a -4 for "ws1.Range("D" & sht1Rows).Offset(-3, 0)" i am totally stump

Re: Copy Data Loop

i cant find one that applies to this situation. my problem is when i paste excel moves the cells down the number of rows i pasted. instead of a4 it becomes a9.

i am needing a way to place information in a template and copy this template for as many items as i have. As seen in the attached spreadsheet on sheet1 the template is 6 columns and 5 rows. The colors correspond to the information needed on sheet 2. this template includes data from row 3 on sheet 2. I need a macro that will copy this template and return the next row of data from sheet2. this has me stumped. Also the data changes on sheet, so it may have many rows or just a couple. Thanks for the help.

i am needing to issue a dos command in excel? basically i need to send a target link to a file. i cant use a hyper link for several reasons, and this is the only way i know how to go about this. any ideas?

Re: Insert Data From Form Into Spreadsheet

sweet worked great - this forum is awesome - have a great one - - -thanks again

Re: Insert Data From Form Into Spreadsheet

please see attached spreadsheet, my previous post only made sense in my head. thanks for the help

i have a user form in my spreadsheet that uses option buttons and text boxes for user entry. i need to take the values and true false entries from the option buttons and place them in cells. i am alittle lost with this. please help - ! thanks for your time

Re: Build Hyperlink From Cells

sweet thanks - worked like a champ - guess i could have checked to see if hyperlink existed in the excel base formulas - thanks again