vba

Hey Everyone, I am in Word VBA trying to populate a table that sources from an Excel file. The Excel file has hardcoded numbers and no formulas at all. There are several worksheets and currently, there is only one Named Ranged, which is StartRow. StartRow is workbook scoped and highlights the...

Good morning, I have a workbook on a shared drive that saves automatically. I am trying to suppress the "Saving" pop up box when it does save. Can anyone help, please?

I have a code to copy data bewteen two different workbooks while the source file is closed and it's working perfectly but with one problem which is when the source file is closed with active filters in the table i get a problem in the data copied to the destination file So, what I need is to...

Hi Board members; I haven't been coding for a while now and have been frustrated by the above topic. I have queried on the web numerous times today using "Excel VBA" followed by a space, with various topic queries and have made progress but the code I last found for horizontal alignment isn't...

Hello, I need help writing a macro for a spreadsheet. I would like the macro to time out a spreadsheet after ten minutes of activity. I would also like a pop up window to ask they user if they are still working, and if they do not respond to the pop up to automatically save and close the...

Hello everyone, this is my first post :) So, for some years I have had a macro-enabled workbook that I also use as a library file of common procedures I can use. In my last job, I created several Excel templates that were used for reporting. Each template was a unique report and contained some...

I would like to try some VBA code that remembers where the cursor was (row number) but go to the required column, and I have no idea where to even start. I currently have a hyperlink that allows me to go to the today's date column, but always goes to the top of the page, instead of the row the...

Is it possible to make a macro automatically execute (run macro) every time a new email arrives? Can something like: Private Sub Application_Startup / Triggered() be added to the code? Or at least add a macro command to click the blue button = (run macro) every time a new email arrives or to...

Hello! I'm trying to get a VBA code to work where Excel detects if a date value is present in column M in Sheet1 and, if so, copies the entire row to the next blank row in Sheet2. Then Excel should delete that row from Sheet 1. Column M will be dates in short format (mm/dd/yyyy). I need the...

So I have a table of widgets and the layers of material needed to make them: TypeLayer 1Layer 2Layer...

So, I have macro-enabled templates for office use. I found a VBA code to KINDA address the problem I was having. Not everyone here is very Excel savvy, so I know they wouldn't be able to remember to save the workbooks as macro-enabled workbook. I found the code for that: Private Sub...

Hi, I am having difficulty with the following data sheets and VBA code i was wondering if anyone could else Essentially what i want to do worksheet 1 - there is variable dates starting from E - BC Worksheet 1 - task items start in range B4 to maximum row 200 Column C is the number of...

Hello, just very interested how to do it , tried everything i knew. Got the next lesson: Set the name of cell B15 to 'criterion1' and the name of cell B18 to 'new'. Assign a validation (input check) to the cell named 'criterion1', which allows you to select one birth month from the list. Write...

I have a single pivot table slicer that contains 39 different last names. When I click on a last name it populates a dashboard with that athletes testing metrics. My goal is to create a VBA code that will loop through all 39 athletes and print individual reports for each to my default printer in...

Hi there, I do a lot of Index Match type of stuff where I'm cross-referencing reports exported from multiple sources, and trying to match account numbers. Some of the account numbers are entirely numeric, while some are alphanumeric, so matching frequently breaks because of the way the data is...

Hi Guys Good to be back I have one sheet which actually a check list for banks KYC/DD documents which is made according to coutnries. Therefore, in one workbook it can have 20 sheet or 19. What i want is VBA to go through the whole sheet compare the today() formula to column J of every sheet...

Hi.... I have made this macro in VBA: Sub ErstattTxt() 'definitions Dim i As Long Dim OldFormula As String Dim OldFormula2 As String Dim NewFormula As String 'loopstart i = 1 'grabbing exsisting formula in active cell OldFormula = ActiveCell.Formula 'Remove the =character in exisiting...

Hi All. I have an MS Office 365 Excel workbook which analyses data and provides charts to show results and "filterable" data. I have buttons for navigation from a dashboard. When I navigate to any sheet for the first time it has parts of the sheet greyed out. If I navigate to another sheet...

Hi Tech, Need help with VBA-generated QR Code based on values in certain cells......................... Series, Firstname, Lastname, Math Grade, Stat Grade, English Grade, Email, Tel, Notification. Thank you

Hi, Please I have this function, which is part of a a Sub macro in VBA, it replaces my old way of filtering, I want to use it as a standalone code for filtering in excel in any active sheet. By just pressing a shortcut like ctrl + w and it works on that sheet. Function FilterX(ws As...