script help

Hi, I have a data range in columns A:G. I want to remove data in each row in columns A:G based on duplicate values in column G. The following code works well to remove duplicates in column G alone however I want to remove the data in all columns of the row with the duplicate value. Any help...

I have a list of PDF URLs that I want to open and save using the metadata in the Excel workbook. Example: A | B https://link1.pdf | super_awesome_1 https://link2.pdf | totally_rad_47 https://link3.pdf | wowsers_cool_32 I want to create a script or process that will open each URL in column A...

Hi, I'm trying to transpose addresses in my "Address" column to a row and then scan down to the next block and repeat. If I can have my cake and eat it too, then it'd be awesome to have the dissimilar (shorter) addresses lined up with the longer ones. I.e. those without a suite or room number...

Hi. I am not really a coder and this is new to me but I have an extremely large spreadsheet I need to disect into a seperate workbook for each set of data. While browsing on this forum I saw many references for splitting data, but it always split it due to a certain value in a column. My...

Hello Everyone, I need some help with VBA scripting. I am trying to automate the following task The excel spreadsheet I have has data in cells A2, B2, C2, and D2. There are many rows one below the other. The data is as below: A2 = Orange B2 = New York C2= Ferrari D2= Summer I need to copy...

I got this VB script last time here. And it works great in 2003. But now we have 2007 and it does not work can you help me. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$3" And Target.Value = "HideDues" Then ActiveSheet.Unprotect ("cover")...

I am using a macro to update the a filter on a pivot table. The below script works great when the field is text however I can not get it to work with a date value. I have tried several differnt changes but cannot get it to work. It will clear the filter but does not appear to recognise the...

Hello, I have the following script, but am having trouble looping it. There are basically three parts that I have condensed. Does anyone have suggestions on looping this until there is nothing in next column's 138 cell? Below is the condensed version of my script. Thanks for any help...

Hello Friends I was wondering if anyone could help me with the following script. I've list of item numbers. Some items have unwanted prefix attached to them. I have list of unwanted prefixes in a saperate table. I wrote following script. It works for removing the prefixes but it also is giving...