destnorows

I have a macro (below) used to clean up a file of addresses. One of my clean steps is to flag any addresses which contain number ranges (i.e. a dash "-"). It was working fine but now that I have a larger file with 10k+ addresses I think I need to adjust to make it less restrictive. Here are a...

I get a spreadsheet daily that has thousands of lines in it. In the first column are account codes. I am responsible for a few dozen accounts so the majority of the spreadsheet is information I do not need. What I would like to do is run a macro that simply copies all the row related to my...

Hi, I have the code below that I was trying to use to flag addresses where the state was AK or HI (State is in Col J on sheet Address Details). I am trying to copy all of these values to the sheet AK_HI Records but I keep getting a runtime error. Any help here would be greatly appreciated...

This might be impossible... but here goes.. So I made a code to locate a specific value "ack-", and to copy/paste into another sheet... Sub HEA_Filter_Dates_Times() Dim strArray As Variant Dim wsSource As Worksheet Dim wsDest As Worksheet Dim NoRows As Long Dim DestNoRows As Long Dim I As Long...

So the code I have runs good, but only has one problem... I cannot get it to paste to anywhere besides column "A" I have tried changing the column letter, but I get an error code saying the "copy/paste cell are not the same size". Any help would be appreciated! <code>Sub...

I have a code to copy the entire row if column B contains a certain text ("ACK-", but now I need to copy the entire row directly above the one with the certain text ("ACK-". Is this even possible? Any help will be appreciated. Sub HEA_Filter() Dim strArray As Variant Dim wsSource As...