#vba #excel

Hello All, First post. New to VBA so really confused on what to do next. What I am trying to achieve: In Sheet 1, I have a drop down from "1 to 11" If someone selects 1, I want to hide Columns D:M in Sheet 13. If someone selects 2, I want to hide columns E:M in Sheet 13, and so on. This is...

Hi guys I want to transpose one column into different 13 columns but I don't know how to write the code. Can you help me? It should be like this: A B ----> A B C D .... C D . . .

Hello, I hope you all are having a good day! I have a problem and I need all your help. I have hundreds of signed PDFs from a folder and I need to combine them all into one binder. I can't combined them signed because the signatures will disappear, so I need to print As PDF first manually to...

'This macro will hide all the worksheet except the active sheet Sub HideAllExceptActiveSheet() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets If ws.Name <> ActiveSheet.Name Then ws.Visible = xlSheetHidden Next ws End Sub This code its working But We need 'This macro will Unhide all...

We need only Visible,"Deskboard" Sheet, When I click Deskboard After Hide All other sheet Also, I will Making Purchase Order Tracking System I was Jump Sheet Using Hyperlink Also. Pleased Need VBA Coding When I click Deskboard After Hide All other sheet Also = "Deskboard" Sheet is Trigger...

When "ITEM LIST" is selected in the range in particular cell, the HYPERLINK should be visible on the side. *My Hyperlink click and Jump Sheet 2 "Table 2" (Table 1 location = Sheet 1) My TABLE NAME IS = "Table 1" Range name (B3:B8) = "ITEM_LIST" How to possible This Query ??? Kindly Share...

Option Explicit Private Sub cmdSave_Click() Dim LR As Integer, Master As Worksheets Set Master = ThisWorkbook.Worksheets("Master") LR = Master.Cells(Rows.Count, "A").End(xlUp).Row If LR = 2 And Cells(LR, "A").Value = "" Then LR = LR Else LR = LR + 1 End If Master.Cells(LR...

@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 am working on a project on an Excel database. My source data has a column with values hyperlinking to a different source. They work fine when in the table, but when I create a Pivot, that column with hyperlink values shows up as plain text, and when clicked on them, they don't redirect as a...

Hi all I am in a trouble to sort out the following to find out exact sum of the pay based on certain role and time period: In one sheet there are names of the positions and per period pay amounts In another sheet, there are positions and the names as well as their tenure/working period during in...

Hi All I have a (hopefully) quick question as follows: 1) In VBA I need to copy in worksheets from a closed excel file (I can do this part!) 2) The target files that I am copying from have VBA coding that runs on open (a normal auto open macro) 3) I want to stop the auto open code running when...

How to Highlight RAW After Bold Text ??? "E2" cell text is bold after Highlight raw on red color with white font & bold also

Hi Gurus, I have this requirement where I need to search a Value from a cell [Worksheets("Vol Contri In-kind (budgeted)").Range("E6")] and check to see if it is found within a range [(Worksheets("Vol Contri In-kind (budgeted)").Range("A219:A240")]. If a match is found, I need a variable to...

In my Function/Sub I created the following two bits of simple code Sub MyTstToS3() Dim Bid As Long Dim Symbol, Descr As String Symbol = ".NVDA211217C320" Descr = MyToS3("DESCRIPTION", Symbol) Bid = MyToS3("BID", Symbol) Range("A1") = Descr Range("A2") = Bid End...

Sub fetch_data() Dim arr() Dim arr3() Dim arrp() Dim arr1() Dim filteredArray() Dim totalRange Dim i, j Dim Str Dim endRange As Range Dim wb As Workbook Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Application.EnableEvents = False Path = ActiveWorkbook.Path...

Hello all, Complete beginner here with VBAs... Basically I have various workbooks that capture quality scoring data for individuals, and one workbook that collates the information for a team. Workbooks are password protected so they cannot access eachothers files. I need the workbook that...

Hi folks, An expert helped me out with the below code which is pulling out the information from "transactions" and "purchases" worksheets to the "output" worksheet. I need to build-in one more logic - to exclude all the rows from the "perc change" calculations (column H, "output" sheet)...

Hi experts, I am struggling to write a vba code to count the unique values based on criteria. Can somebody help me please? Like, I have the data as shown in the mini-sheet attached. I need to find the unique number of items# from column2 if the Date is blank in column1. As per the sample data...

How to Match workbook to other workbook data & Get status (HOW To MATCH "BOOK2" WITH "BOOK1" , All data Match , to Get Status and Highlight 4 CELL matching How it possible ???