vba & code

This is some (poor) vba code I wrote in order to take multirow information and unpivot it for a table that will be used elsewhere. I know unpivoting can be done in power pivot or even just in excel, but in my situation, having a macro run this code would be a whole hell of a lot easier. Thank...

Sub macGL_Detail_ImportAndFormat() ' ' macGL_Detail_ImportAndFormat() Macro ' Dim fileLocation As String Dim fileToOpen As Workbook Application.ScreenUpdating = False fileLocation = "\\company.corp\files\KDrive\DM Monthly Close\2024\04 2024\GL Detail\04 DVH Detail.xlsx" 'I would love to be...

Hello experts, I do have excel files (1 sheet per file but headers are different) to download everyday. I need to transfer them into a masterfile (grouped into sheets) then the process will repeat the next day but the masterfile is still the same. Basically the new values will be pasted to the...

Hi! I'm a complete begginer, so i don't know much about coding. I'm trying to create a button to run a macro that does the following: 1.- Save sheet2 in a specific location as PDF and saves the hyperlink in sheet24 of the active workbook in column 11 2.- Save a copy of some of the sheets of the...

Hi Team, We have a requirement to create multiple workbooks containing one-line questions and answers to share with our internal supplier team. We are looking for a fast and efficient way to generate these workbooks. Can anyone provide guidance or suggest techniques to streamline this process...

Hi there, I'm a bit stuck on some VBA code and need some help! I want to create some code for a macro button that will auto populate a value from cell A1 in cells Q19 and AJ19 and carry on doing this every 14 cells in both columns. It would be great if the VBA loop ends at row 355 as this is...

the cells have a number associated with it which looks something like this ,column A & B will never have any color the columns and rows are dynamic the Output is expected something like the below. the green columns B-C should only be populated when the whole line is green and only first...

Hi Everyone, I have an online appointment scheduler, using "https://www.squarespace.com/acuityscheduling". So far I have been manually copying all of the client information manually. Below is the information I gather manually from the website and put in my excel sheet. Is there a way I can...

Hi there I would like to know how I can set the following type of invoice numbers to be recorded on a different sheet by the use of a button form control and how I can use another button form control to automatically generate the next invoice number when I press the button as the sequence...

Hi all, I'm trying to automate the filling of a word template contract and I keep getting the 462 run-time error. The debug gives me the error colored in red below. I'm hoping for some directions on how to correct my code. I've tried couple of things already but nothing seems to be working...

While the saving box appears there is a cancel button at the bottom right corner. I want to prevent this button from appearing or prevent the saving box to appear all together. Essentially I don't want the user to cancel the save process. Please see the screenshot. Thank you!

Hi, I have a VBA project. There are two Userforms. On the first Userform, I chose some of them to be enabled and input a value in the respective text box. Then when I press the Next Button, it should control which Labels are enabled and which respective Text boxes have value so it should copy...

Thanks for reading! As show above, I need to create multiple (activex) buttons each hiding or showing a specific range of rows on another page but am struggling to find a solution. I have messed with this a little in the past but found my answers online and modified them to suit my needs. Here...

Hi to all I have two almost the same codes but for different ranges. Separately they working perfect, but If I combine them, only one working, in range ("F25:F50") and NOT for range ("E12:E24"). How to combine them correctly ? Joe4 it's your code, maybe you can help me again ? :) Thanks...

Hey all, Hope you can help me with the below challenge I face: I've got several folders with a lot of subfolders each, containing images (large majority is JPG, but there might be a few JPEGs, PNGs... ). Several users upload new images there all the time. So I am trying to get VBA to help me...

Hi; How can I enable and disable multiple text boxes using the combo box option button?

Hi I am not able to progress after getting output got cell J11. Looks like the loop isn't working. I am looking to get the month end dates in the row 11 from the start date to end date. Can any one please help me to resolve this?

Hi there, I am trying to write a VBA code in order to automate a PP to automatically update textboxes with excel data. The current approach is: Set Excel File Path: It defines the path to the Excel workbook from which the data will be read. Open Excel Application: It creates a new instance of...

Hello! I'm new to VBA, this is honestly my first time playing around in it, and I need some assistance. I have a group of cells on my excel sheet that I want to have copied and pasted into the email body, but everything I try comes up with nothing. :( Could anyone help? I also really need my...

Starting at A17 on Sheet 1 I have a row of data that I need the data from columns A,B,C,D and G (Column B is a specific ship date) copied to one of the ranges in sheet 2 that contain the 4 quaters of the year. The date in coulmn B determines which range of the quartely ranges it goes into. On...