usdrws

Hi again, so I have this file selection thing working ok, so the address of the file that i want to use as a data source is in cell "Z2", but I am not sure of the correct syntax for referencing it. I figured it would be "Indirect" but i get a 'Compile Error' "Sub or function not defined"...

Hello, I want to delete all rows if column N reads "NULL". I was given the last two lines of this macro a while back from someone (I believe from this forum) and it has worked in the past. I applied this to my current macro but I am getting a debug error when I get to the last 2 lines. Can...

What went wrong this code..? For k = 2 To UsdRws 'UsdRws To 2 Step -1 If Cells(k, 1).Interior.Color = vbYellow Then Rows(k).Copy Sheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Offset(1) Rows(k).Delete End If Next k

I have a spreadsheet with a header row and columns A-P. In column H I have multiple names and they do duplicate. I have used the code below and it creates the new worksheets/tabs based on the names in column H and copies over the header. I can't seem to get this to copy over actual data. Part...

Hi, I Have the code below that randomly selects 5% of rows in the active worksheet and pastes it to another. The problem is that this macro delivers duplicate rows. Is there any way to edit the code to ensure duplicates are not in the new worksheet? Thanks Sub RandSelect() Dim Qty As Long...