vba & excel

Hi. I have a question about data validation. Is there a way to remove one of the strings from data validation list if it's already been used in a row above in the specified range? A quick example of what I mean. Lets's say in column A1:A30 each cell has a data validation list of 'A', 'B', 'C'...

Need help in coming up with VBA code logic . My requirement is as follows: Sheet1 (Input Sheet) ProjectID ProjectName 2022 2023 2024 Project 1 Name A 100 200 300 Project 2 Name B 400 500 600 Project 3 Name C 700 800 900 Sheet2 (1st Output Sheet Read the first entry from...

Hello Excel experts! I am in need of a macro in Sheet A that creates a tab delimited blocks.txt file from range A36:C50 in Sheet B in directory C:\Users\user\Desktop\AsBuilt\blocks.txt Also, since I will be using this same file to import blocks in AutoCAD, I wouldn't mind if the newly created...

I am intending to merge every cells between the two objects "FirstCell" and "SecondCell". Still a relatively new user to vba, hence not really sure what went wrong. I have also declared "EmptyRow" in a previous function. Thank you!!!

Dim lastRow As Long, i as long lastRow = ThisWorkbook.Sheets("report").Range("b1000000").End(xlUp).Row lastRow = lastRow - 1 i = lastRow ThisWorkbook.Sheets("report").Range("c&i:p&i").Formula = "=SUBTOTAL(109,$c$2:i)" What is meant by the code is to add a sum to specific columns starting from...

Hi Mr. Excel, I need a logic that would copy Sheet1 (Data Table) into Sheet2 Sheet2 (End Result should look like this) In this sheet, MaterialA should be repeated 13 times and each of the months values should be copied vertically against the respective month. I needed help on how to do this...

Hello, Can anybody share a reference on how to use Excel Business Translate (Excel - Microsoft Translator for Business ). I was not able to find any references. Thanks!

Hi All, I'm new to this forum so I apologize if the question has already been answered. I am working on a spreadsheet that fills out shipping details to a customer. What I am looking to do is execute a VBA code that will locate the column and perform the vlookup. Typically, I would just create...

In my program if the user does not proceed with the correct method of clicking the row in a listbox to select the row and then click on the delete row button, error message 381 is shown. if the user now clicks on "End" button the form totally closes and the login window is shown. if the user...

HI Team, I tried to find solution to my query on mrexcel forum. unfortunately, I did not get exact solution to my query. Here I need a macro to get the sheet2 ColumnB data into sheet1 ColumnE. Macro to vlookup sheet2 ColumnA data in sheet1 ColumnC text if found get Sheet2 ColumnB data into...

Hi guys, I need some help in my vba code. I am trying to pastespecial a screenshot of my excel file into email. For some reason unknown, I always get an error message when I try to compile the code- compile error can't find project or library. Strange enough, when I change the code to paste...

Hi guys, I'm really hoping someone can help me. I'm wanting a schedule that will hold up to 30 appointments per time slot per day. I have created a calendar that you select the day on, then select the time and fill in the appointments as necessary (please see screen shot). I've managed to get...

I have a rather large workbook I use to analyze data from different sources. I copy and past data into 16 different worksheets and then use VBA to format the data so it's readable. The data is pulled in to a single worksheet I use to rollup all of the information into a table with a pie chart...

Hi, I have a workbook with multiple worksheets within it. For each sheet I want to filter based on the contents of one column but need the filter to work like the search autofilter i.e. to filter based on the contents of the cell containing any part of the term not the whole. An example of this...

Suppose I have two columns ColA = Calling programs and ColB = Called programs, now I want to build a hierarchy between calling and called program and print them with the calling dependency lvl column as below. Note: Calling program for which called program is SPACES, is the initial program...

Afternoon, My son is setting up a vinyl wrapping solution for interiors, and I was hoping to create a calculator for how much vinyl he would need to purchase for each job. Does any one know if there is some vba to calculate how much of a roll 2M Wide x 15M long would be used from a mix of...

Hi Guys, I am wondering if there is a way to transpose data that are in two columns B & C,ie (Attribute and Value) relating to a unique reference id, that is in column A (Product Code) with B & C grouped together separated by a colon : and each Attribute: Value combination is separated with a...

I wanna change the font and size of the entire left header and make part of that header Bold. Since this doesn't have a cell reference I'm having difficulty trying to figure out how to do this. Advance Thanks for all the answers. Note that the header info is being fed in using a userform to get...

Hi, I need help please! I have this code but I need it to work automatically. The idea is= I need to gain the data from the range "A6:W29" but only cells with data and to do it in every sheet except for "RESUMEN" "S.Inicial" and "S.Final". Right now I can merge all the info but running the...

I will need to create a button that can be named "Validate". By clicking on this button the total in cells E20 and F20 will be copied into the "Paste" sheet in the corresponding case. (Name and date)