vba

Hi, I am looking for a VBA code to look through Multiple workbooks in a folder, look through a column, match to an inputted Date/Value then past the whole row where this matched date is into a Master book. I currently have this only for a single workbook and it works but I keep getting an...

Typescript is the language of Excel scripts, available at certain Office 365 licenses. Unfortunately, my company chose to disable this feature, so at this time I cannot use it. However, we can write TS outside of Excel. This article shows how to output TS data to a text file that Excel can read...

I'm still pretty green when it comes to coding in VBA. I've tried multiple different strings of code to try and accomplish this - all of them have worked in terms of getting me to my desired site in Microsoft Edge, but I haven't gotten any further. I've only ever been able to successfully write...

I am trying to evenly assign work amongst employees based on their availability and language. Please help, thank you very much in advance.

Hi, its a Friday afternoon and my brain wont work at all. I have 2 worksheets. In one worksheet "Worksheet1" I have a defined table with 2500 rows of data with 2 fields, "ID", "Name" and "Amount". the values in the first "ID" column are unique and the "Amount" column is blank with nothing in it...

I tried many times to write the vba code for below process but it didn’t worked. Could anyone please help me? Start from sheet 2 1) filter to show dates that before today+2 in column AI 2) filter to show blanks cell in column A 3) Do the same with next sheet 4) pop up massage Done once its done...

Hi there! I am using this macro to sort through a master inventory list and transfer a row if the inputted "Vendor" is found when the InputBox populates. However, after the input, the InputBox keeps popping up and infinitely looping. How do I make it so that once a vendor name is entered, the...

Hello . . . I have a very simple piece of VBA (below) that works perfectly well copying a line and inserting it below itself, as intended. However this doesn't work when a filter is applied. Can anyone kindly suggest a fix? Sub WLM_Insert_A_New_Line() ActiveCell.EntireRow.Select...

I'm rolling out an Excel/VBA frontend that will use an SQL Server backend. I am going to have both Mac and Windows clients, so I'm unable to use ADO and recordsets. My research found two libraries that will work with VBA and let the Mac execute SQL statements against my database. * Openlinks •...

Hi. I have a spreadsheet for some assessment results (See my other posts). the cells are condition formatted so that they turn red when the assessment has failed. I am trying to get a formula to count the cells that have turned red, for each individual trainee, however the normal count functions...

I have this code that creates a copy of my excel sheet and puts it an email in outlook. this works perfectly. However, I run a filter with a change event once a loan officer is chosen in cell and I would like to modify my macro to strip out all the other data so the user that receives the...

Hello all, I have problem with VBA macro in excel. I see error 13 type mismatch, after try to import data to excel sheet. First macro import data from several files from the specified folder (*.xls excel files), but it stop with error at: "If Target.Column = 1 And Target.Row > 1 And Target <>...

Hi All Another problem. Im seeking a function or macro to move all the data from a selected series of rows, into the top most row of the selected area. Example below. There are 12 rows of Romboutsia (84 to 95), and all rows will (/should) have 1 data point. Im looking to move all the data from...

I created a file which will calculate sales rep commission based on terms and conditions of the commission agreement. All sales rep performance data is filled in on one tab, and then through selections on drop down boxes, the file will generate the correct payout to be paid to relevant sales...

Hi, I'm new to VBA & couldn't find an answer that matched closely enough for me to adapt for my purposes. I have a sheet which will have further rows added to it so need the query to also be variable to the last row with data. Sheet1 has a series of selection options which fills data in...

I have code that executes an autofilter to show data based on the value in cell d6. However, when the user hits the delete key the autofilter shows now data. If the user hits delete on d6 I would like to make the value of the cell 0. Is this possible? Code when there is a change: Private Sub...

Having trouble with latest date code for pivot table vba code. Trying to streamline our process of entering equipment hours and I started getting into vba since it seems like it's the way to go, I found some code that should do this but I can't get it working in my particular instance. Listed...

Hi all, Super novice here trying to get something done for my wife and a non-profit she is part of. I hope someone can help save me some time as I have been at this for hours. I have a set of raw data on one page that is organized by row. (a2, a3, a4...) I have a separate page with name tags...

I have a large Excel data base of bacteria Genus'and i need to match the name in one worksheet, to another worksheet, copy that whole row, and paste into another worsksheet. Example... I have 3 worksheets A, B, C Worksheet A has 1000's of rows of names and many columns of data to each row...

Hi I need some help and I hope I am explaining this correctly, I have attached a photo of my spreadsheet and I need to increase the value of column (M) so that each value has a minimum profit of 2.50 Column (M) is determined by column (I) so I need something that will adjust column (I) until...