scripting

Good Afternoon everyone, Hope you are doing well. As you see the attached pics - "Master Data" is my main data sheet. I want a VBA script which will automatic update and move data in "Master" data sheet from Sheet1, Sheet2 and Sheet3. It means if I change "Status" column in Sheet1, Sheet2...

Hi everyone, Hope you guys are well. I need a VBA Macro Script which will automatic convert the "Excel Sheet Column" name into the "new tab". For example, I have 5 columns - column1, column2, column3, column4, column5. I need a VBA script which will convert these columns into the 5 new tab...

Hi all, first off thank you in advance for reading and considering to help. I am looking for assistance on a copy paste macro to copy data from Sheet2 to Sheet1. the macro must Compare the values of columns C in the 2 sheets and if they are equal: copy/paste the whole row in sheet2 Example...

I have a problem in a specific sheet: I need only country,network,NetworkName and currency columns, but in sheet all messed up. As you can see in network Colum there are name and MCCMNC code also same in network name Colum so basically I need to separate all data and make proper format by...

I have a problem in a specific sheet: I need only country,network,NetworkName and currency columns, but in sheet all messed up. As you can see in network Colum there are name and MCCMNC code also same in network name Colum so basically I need to separate all data and make proper format by...

Dear all, I wrote a VBA macro (partly mine and partyl snippets from the Internet) that lists all files that are contained in all zip files the macro can find in the starting path: folder_path = "C:\Users\[MYNAME]\Desktop\prod". This works. It runs through every Folder down to zipArchive which...

Go easy on me. I'm more of a decent hacker using other's code not a programmer. 1st post here. Tried using recursive code I found based on MS scripting (which I barely understand) to parse directory tree to fill an array with all paths. It seems to be parsing fine as I can tell HOW MANY dirs it...

I have provided this request before. Tables were not visible in that thread. So creating a new one. Can someone help me with creating excel macro for the following. Data will be entered in the "Main" Table in Worksheet 1 (Main Worksheet). Shown entries for a project with two units - Unit 1 and...

Hi all! I'm trying to activate the Microsoft Scripting Runtime Reference within my code as I'm using FSOs in other parts of the code. I don't get any errors, but it's not activating the reference either. The path below is my actual path. Any help is appreciated. Thanks in advance! Sub...

I have a master sheet which has multiple data like Date, Item Name, Weight, Price which is updated daily by appending new data below the old data in the same sheet I wish to automatically prepare multiple sheets based on different items present in the column "Item Name" in the master sheet...

hello all, Normally I would use Index/Match but I'm looking for a VBA solution. In column A I have a list of numbers. In column B I have a list of names. In column C I have a date. Can a scripting dictionary have 2 keys (in column A & B) and 1 item (in column C)? Match the value in columns...

Wrote this mass of VBA code in order to compare sentences for equality. Any recommendations for speeding it up? Not looking to use other programs (though it would be easier) as VBA is the only current one I have access to. Looking for better algorithms for assignment issue as well as removing...

Hi, I was wondering if it is possible to create a scripting dictionary that is equivalent to a vlookup for a report that I am trying to create. Basically I have my Sheet1 where I have my list of "ID" then some other data, and the new amount, which is taken from from Sheet8 - a data dump I get...

Hello All, I'm trying to accomplish what I thought would be a fairly simple thing in terms of programming but it seems I've run into a bump. I'm attempting to create a Macro so that with the current active cell I can press my predefined hotkey\shortcut and it will do 3 things. Firstly will add...

I have 2 sets of data that I need to compare, each set is roughly 500,000 rows. I tired to do a vlookup but it was taking far too long to complete (30+ minutes before I cancelled it) I've been reading that I want to use a scripting library to accomplish this, but I cant quite figure out how...

I have a large collection of files (many thousands) and I only want to keep those containing a certain string in its filename (that is, "10-K".) Here is a picture of what I want do to -- except for those files containing "10_K" in the file name, delete the others. (This is a sampling of the...

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...

Subfolders collection of FilesystemObject has a count but you can't reference it? Subfolders.Count = 12 prefect Folder.Subfolders(11) not allowed - errors Error 5 Invalid procedure call or argument likewise Folder.subfolders.Item(X) Is the Count of any use other than to tell how many there are?

I believe I have exhausted all the searches I could do on this subject and since I have not solved my first problem I hope I can post and get an answer for both of my issues... Background: I recieve a report from an old database in email as a message, I copy that message to word and save it as...

Hello All, This is my first post here. Is there a way in Access VBA (or any other way (really)) to split Access Reports (by group change) into individual reports and send them to a directory based on the group? In other words, if I have a report for each professor within the report and I want...