vba

I have a workbook that I need to select rows that have cells numbered in one worksheet, import them into another worksheet, sort them based on a value in one column, The first worksheet can be 150 rows long and would look like the table below (with data in columns C through O too)...

Hello all, Need some assistance. BACKGROUND: Every month a New Customer Report generates and new customers get added to the bottom of the Excel sheet. I manipulate the report some and send out to staff. I want to automate this and what I am struggling with is the code top copy and paste NEW...

I simply need to change the font of a row after the table last row + 2rows for cells from ("A: M") but I don't know how to write that in VBA code ... I have a code to Addnewrow and I wrote the last section in the below code but unfortunately wrong any sugesstion please Sub Addnewrow() Dim...

Hello, I'm looking for a way to get the name of a Form Controls Spin Button on a Worksheet, not in a Form. I'm working on a macro that builds a calendar, and I'm having to delete the button manually each time I want to clear everything and test my code. I'm trying to avoid deleting all...

I have created a userform with 3 buttons, "Save as .XLSM", "Save as .PDF" and "Cancel" What I would like is for this command box to pop up when we go to save the document (click on save as > browse) The buttons work just fine every time someone hits Save as .PDF. BUT, it will only work once...

https://stackoverflow.com/questions/79338433/the-vba-code-slows-down-the-worksheet-needs-to-be-faster?noredirect=1#comment139908100_79338433

In my line of work, virtually every company uses some combination and variation of VBA tools that essentially links Excel & Word documents to produce ±100 page report deliverables. Most of this is done through VBA tools either made by 3rd party technology solution providers, and some are...

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