#vba

I have a Input Form / Table for Data Entry which is presented to a client for completion. As the Table could be 5 to 100 entries long I can not compensate for the unknown about of required rows. Each Table thus has a number of records provided, but needs to “grow” based on the data entry, to...

@how can I show a icon in Excel when I click on a Description column (Range (A15:A30) , if i will click after open Userform ? Icon Move After cell Selection. kindly Need VBA Coding

I have both sides of the code but do not know how to join them together. One part of the cod will pull the Windows user name but not work with a selected range and not work with if there is a change in that range. The other part works with with timestamping when ever there is a change within a...

If column O is exactly "Sanitary", I need to add up all the numbers in L that are on the same rows that contain partial keywords: "Base", "Riser", "Cone", "Adjustment", "Ring" in column K AND contain the same value in column B. so in the sample data below, rows 21,22,23,24,25 meets all...

I need to replace the value in column H with value from a cell in column U when criterias are met here are the criterias: If column O contains keywords "P-" and "MANHOLE" and if column F contains exactly "P1" then the value in column H in the rows that meet criterias above, gets replaced by the...

I need to modify the value 0 to 1 in column H if on the same row: (I am munipulating csv files, and the macro is in a xlsb file) 1. F is exactly "P1" 2. column O contains keywords "P-" and 'STORM MANHOLE" this should be very straight forward and it is not working..... help ! sample file and...

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