scripting

  1. F

    VBA Macro - Automatic Update "Master" data sheet from multiple sheet

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

    VBA Macro - Convert the "Excel Sheet Column" name into the "new tab"

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

    Copy/Paste Macro from Sheet2 to Sheet1 based on on another column values

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

    How to fix a messed Excel sheet and make a proper format?

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

    How to fix a messed Excel sheet and make a proper format?

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

    Retrieve textfile properties of file in zipfolder

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

    MS Scripting for directory tree parsing

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

    VB Script for Data consolidation

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

    Use VBA to install Excel Microsoft Scripting Runtime Reference

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

    Create multiple worksheets in an excel file using strings in one column and auto update such worksheets based on the master sheet.

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

    scripting dictionary with 2 Keys and 1 Item

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

    Any recommendations to speed up VBA comparison function? [long]

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

    Scripting Dictionary as a vlookup

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

    Help with setting what I think Should be an easy macro

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

    Help with Scripting Library

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

    VBA - Delete all files not containing certain string of text in filename

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

    Open and Save PDFs using Excel Metadata

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

    Subfolders collection of FilesystemObject has a count

    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?
  19. G

    formatting and deleting cells and rows from a txt import in excel

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

    Script/VBA, other possible solution to automating report bursting and copy to folder/directories?

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top