#vba #excel

Hello, I have a daily report on Excel which follows production figures and i need to make a macro to save time each day, the workbook represents a whole month and comprises of different worksheets each work sheet represents a day in the month starting from day 1 to day 31 Sheet 1...

My Userform not working to my VBA coding As per below Private Sub TextBox2_Change() End Sub Private Sub TextBox3_Change() End Sub Private Sub UserForm_Initialize() ' Initialize Sr. No. to 1 when the form loads TextBox1.Text = 1 ' Populate Combobox1 with Product Names from...

WE NEED DATA TRANSFER TO TABLE AND EASY DATA ENTRY ........... SO I WAS FAILLED... I Don't know how to write vba coding As per my Question DATA Range : J7:MJ Table Range : C7:C24

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...