#vba

Hi. I have data in multiple workbooks in a folder with the same template and I need to extract those circled data into one master workbook as below I have a code to loop thru all the workbooks in the folder but I do not know how to do the data copying/extracting. Thank you for any help!. Sub...

I have an xlsb file that contains VBA macros, a csv file that contains a bunch of values. (when the macro is running, the csv file is already open) And I need to open a xlsm file and copy a range of data from this file to a range of cells in the csv. code below is copying the data to the xlsb...

I have an excel file that contains a macro that is used to clean up a bunch of csv files. after I run the macro, I keep the csv file open, then I would use this userform to copy data from the excel that contains the macro to the csv when I select 1250, qty of 1, these data are copied to the...

Hello all, I want the user of my worksheet, via input box prompt, to both select a range of cells and a number to be added to that range. I'm not a vba expert at all, but I could collect these pieces of codes from many sources to achieve my goal. And because of not being an expert, I'm stuck...

Hi, Wanted to make a worksheet where I can save bid/invoices in a different sheet (to keep track of it) but I also wanted to save it in a specific location each time I click "Save All". Right now I have it so that it saves in a specific location, but I want to make it so that I can put the...

Hi, i was wondering if i could get some help with a problem i was having, once per month i need to download about 10-15 pdf files (updating them) and manually take data out of the files and add them to an excel spreadsheet. I have adobe acrobat pro V 10.0 and have been trying to create a...

I have this code that copies the text from column B to in front of the text in column K (same row) See screenshot below, code worked on 163, but not on K164-167; it also worked on K175 but not on 176-179. Any reason why it is doing this? also, What if I just want to add the text and a space...

I have these excel files that contain either Yes or No in column E, and a text string in column D. If column E on a row is Yes, AND if there is no letter J at the end of the string in column D, then J needs to be added to the end. so in the screenshot below, the value in D8 needs to be F21223AJ...

The code gives an error before pasting if the array is empty. What could be the best solution to bypass if there is not data store in the array? Nary is out of subscription. ' Find and add matched cases into another array ReDim Nary(1 To UBound(Ary), 1 To c) For r = 1...

smart people of Mrexcel, I have this code to calculate the total amount of a certain item, and display the total after the last row in the excel. after this row is added after the last row, I want to remove any row that contains the keyword "Sealant" (these can be any row, any number of rows)...

Hi all, can anyone please help me to write VBA code or Excel formula? I need to sum up the Qty if the Supplier and Size matches and to have it in Result Worksheet. Thank you in advance.

I have this macro that removed certain parts of the text if the number of characters in any cell in column K is longer than 40. However, it is also adding a 0 to any cell in K when the number of characters is 0. See picture below code also below. Any help is greatly appreciated Sub...

I have this macro that adds an empty row (only column A will contain a value same as the cell above it) between two rows that contain different values in column B in the example file below, a new row is added after rows: 14, 20, 27. The code is doing everything that it was intended to do except...

I have a subroutine that counts the total square foot of a paint (CS-55) in any given excel file, converts it to gallonage, and add a row to the end of the file to display this gallonage number. below is a screenshot of a test file, the square footage is in column C, and description is in K. If...

I have this VBA code that converts the quantity of an item from how many inches to how many rolls this code is not working on a particular file, see below, there are 276 inches of this item using this equation: ((n / 12) \ 14.5) * 2, and the returned result is 0 ? Test file below...

I have this code that counts the number of "CHAIN & EYEBOLT" in some excel files, then adds one row at the end of the file to show the total number of this item. The new row should always have: column A (value from cell above), C (total number of the item), B, D, I and K with the static values...

I have this code that adds 5 new rows after any row that contains Solmax or AGRU in column 11, also contain Liner in column 11, and contain Sanitary in column 15 the code is working fine when these criterias are met...the problem is it adds these 5 rows even when column 15 does not contain...

I need to modify some excel files, if column K contains "AO", "COVER", and column N contains "Tampa" then any "Riser", "Cone", 'Top slab" (column K) with the same item label (column B) gets the letter J at the end of the value in column D so in the screenshot below, rows 2 and 3 will be: F14632J...

Hello, I am trying to track some testing specimens at work, and I would like to have to automatically populate a date when the status drop down menu is changed. For example, I have a status column located in column G. The status has a drop down menu including Not Received, Specimens Received...

I need to add a blank row before when value in B changes, in the example file below, a blank row will need to be added after the highlighted cells. How do I approach this issue with VBA? Note: the value in column B can be any length, sometimes it is just a number, sometimes it is a combination...