vba

Hello, I feel very confused by this because I am still learning and trying to understand VBA with Userform. I have a worksheet where I would like specific data (Lab #) to be posted into another worksheet based on the Date entered. I will attach the an image (unfortunately my work does not...

Hi there, I'm made some progress but not quite there with this code. It correctly hides the rows if days = 365. However, I would also like it to hide the rows if it is blank (so 365 or Blank). Also, I have headers on Rows 26:27. I would only like these rows to be visible if any of the results...

I have a spreadsheet with details of attendees. The attendees maybe attending multiple locations, see columns I to N in the image. If there is a "1" in the the columns, I would like copy the cells A to H to the corresponding sheet. i.e. if there is a 1 in Perth column copy to the sheet...

Hi all, May you share with me, if you know, some resources/free courses online about Excel VBA Intermediate and Advanced that shows the information structured in chapters? I have searched the internet and according to what they say, there is no official Excel VBA certification and although...

100% VBA Plagiarist here, and I've been using the code from this post and I cannot love it anymore every day. LOL. That said, I would like to update a different piece of VBA. This currently prompts the user that the refresh is complete, changes to a different environment type (so the VBA isn't...

Hi all, I'm trying with formula to transpose a data which is in stacked in vertical way. There are blocks grouped by the CODE. For instance group with CODE=ABC has several parameters and corresponding values. I'm interested in PARAM_2, 4, 5, 6 and 7. * PARAMETER_5 sometimes the has more than...

Hi, Column B is a description field where the user enters data. To reduce the visible size of the table, I want to hide rows until they are needed. I would like, when they enter something in B20, 5 rows below are unhidden. Then when they get to B25 and enter data, another 5 rows are unhidden...

Hello I have sheet1 with a range of dates. These dates are either today or a period before today. I am trying (unsuccessfully) to print these dates into sheet2. I need to offset any date that is today by 1 day but if the date is before today leave it as is. Thank you for your time. S

Hi Experts I'm using following VBA to show Filter Drop Down Arrows For some reason it has stopped working. Please help 'To Hide/Show Filter Arrow On Error Resume Next Err.Clear ActiveSheet.ListObjects("Banks").ShowAutoFilterDropDown = True Selection.AutoFilter

I am new to macros/VBAs so I'm looking for help in writing this code. I have a spreadsheet that is used as a data source (SourceFile), which contains data in Columns F, H, and I. I would like to copy the entire column of all three columns and INSERT them into multiple workbooks that are saved...

Hello! I am looking for a support to have a VBA code as mentioned in the thread. Is there anybody who can help? Sub Test_CreateZipFile() CreateZipFile "D:\MyFiles\t\", "d:\myfiles\Test_CreateZipFile.zip" End Sub 'https://exceloffthegrid.com/vba-cod-to-zip-unzip/ Sub...

Hi all, I'm working on a macro where I have to swap around some rows on a sheet. So I've added some grouping labels in column B, loop though my 150 rows and move blocks in a certain order. Moving means: cut and paste at the top. Roughly speaking, this is what I'm doing (option Explicit is on)...

Hi, I want to move 2 worksheets from one workbook to opened 10 other workbooks with one click, is there any solution? EDIT: I want to replace two old sheets (has same name as new sheets). Now I delete in every workbooks two sheets and then for each workbook copy two new sheets. ### Copy...

I have a table in a file (that I'll call my Working file, for the purposes of this question) which lists out services and has an on/off selection for each service, similar to the below: ServiceOn/Off ABC1 DEF0 GHI0 JKL1 MNO1 I have a macro that runs through this list - If the...

Hi, Hoping someone can help me out here. I am trying to loop through the worksheets called PP-RF*, read the contents in Column A and then copy the record to a named sheet. This code loops through the worksheet names: I am having trouble with the copying of the record to the named sheet...

Hi Experts Need some help. Can there be some VBA to go to home tab? Thanks a lot 🙏

I have a VBA that works ALMOST how I want it to work. The code below works, only thing is, after saving the file ANOTHER save as dialog box opens. I don't want a second save as dialog box to pop up AFTER the file has already been saved in whatever file type they picked. Private Sub...

It seems that Autocomplete text in excel works only in the same current page of excel sheet while when I go down to a new page, it doesn't work I works on a daily list of tasts where I need to assign a team member in front of each task and as the team names are almost the same people so I need...

Row 'I' is a dynamically changing column, Row 'H' looks to see if the value of column 'I' has already been listed in column 'N' and returns "Listed" or "Need To Add" which tells us to add it into column 'N' so the formulas can fill and we can review etc. I am looking for a VBA to take away the...

I send bulk e-mails to the company I work for, and with the e-mails I send, I determine the need lists and classify requests. In the Excel file I use for sending emails, column A contains email addresses, while columns B1:G1 contain equipment names, and column H1:H contains notes. For each email...