macrco

Hi folks, I'm pretty new to using VBA and macros in Excel and am hoping someone can help debug a macro I found to create custom data labels for a map. My goal with this is to label a county map of Colorado and make the text large enough to see clearly - it's way too small using the Map Labels...

Hi I have a folder with many excel files, I want to filter out all the cells with a background colour which are often the headings of table. From there, I want to copy and paste the heading(cell contents) into a new file. How do i use VBA/Power Query when the tables across the different...

Good morning everyone. You currently have a report where I must perform data repairs. In question, a copy and paste of data in specific columns through a specific line. graphically it is this. (https://i.ibb.co/FH8RmvZ/Animation.gif) Column A shows the line where I must carry out the...

Hi Please some one help me to find the solution for the below question? I have 2 sheets called Buttons and Database as shown in the below image. Upon button selection I would like to show only selected Name/Skills in Database sheet. eg: If "Dinesh" button selected show only Dinesh rows in...

I am making an index of a large number of files with a very long path, and I need that for each "/" each cell moves to the right. That is, if there are 3 "/" in a cell, that same cell must be moved 3 times to the right. is there a way to apply this to all my excel sheet? All help is welcome.

Hi, I had a Worksheet_Change(ByVal Target As Range) event, then I needed to add another event to the same worksheet, which I did. Then I read that it is a good practice to have an Application.EnableEvents = False and Application.EnableEvents = True statements in the code but I wasn't sure where...

Hey, Hope everyone is doing okay and keeping safe I have been tasked to make a Fund Performance dashboard using VBA I am able to get stock data from yahoo. Also managed to calcuated monthly returns from daily NAVs. However I am struggling to calculate Quarterly returns. Here is the code...

Hi @all, I would like to implement the following function in VBA as a procedure. =INDEX(Zones!$G$3:$S$273;MATCH($A3;Zones!$C$3:$C$272);MATCH($B3;Zones!$G$2:$S$2)) I have two sheets ("Data" and Zones"). I search in the sheet Zones for zone numbers, to be able to determine later also the...

Hi there, I'm looking for a macro which generate an 8 digit hexa number on a given input numbers. But before generate a random hexa-number, check if particular input is already in a cell (for example row 12) in column A, corresponding to that cell value (cell 12)in column B will be added in...

Cross-post ! So here is macro: Private Sub NoteZoom3() With ActiveWindow.VisibleRange NoteChangeSize .Width, .Height, True End With End Sub Private Sub NoteChangeSize(w!, h!, Optional scr As Boolean) With ActiveCell.Comment.Shape .Width = w: .Height = h...

Hi everyone, I need a VBA code that would merge every three rows (if data exists) starting from row 2, and covering column range of A to lets say J. Many thanks in advance,

Hi, I have two excel documents, "Book1" and "Book2". Book1 is exported from our business system. Book2 is a compilation of forecast from the businesssystem data that were exported. Today I have to manually put in the data from Book1 to Book2. I want to put a VBA Code in Book2 to import data...

Hi there, Can someone help me write this VBA code please? In column K (from K9 down) I have dates or blanks. I want to be able to push a button (POST) and if column K has a date in it (ie. isn't blank) then today's date should be entered in column L (L9 down). Once this date is entered in...

Hi experts, i am an newbie for the VBA and Power Query.. i will have to download reports from our old system and upload to new system everyday.. the downloaded file will have an pivot table output as below after cleaning data. what i need to be do is copy each output based on the kit no and...

Please help me on creating a macro which search multiple sheets in a workbook with a particular column name and display the count of values in that column and display in a new sheet with sheet name and the count. Here is my code, Sub Click() Dim sh As Worksheet, ws As Worksheet, LstRw As...

Please help me on creating a macro which search multiple sheets in a workbook for a particular column and display the count of values in that column and display in a new sheet with sheet name and the count. Thanks

Hi All, The below code creates a PDF from a named range in cell A55 on the "Menu" sheet and saves this to a folder based in a value in cell A52 on the "Menu" sheet. What I'd like to achieve, is that if the value of cell A115 on the "Menu" sheet is "Zone" then output the PDF file to a path in...