visual baisc

This might be very easy for one of you but I can't anymore, I am not that expert in Visual Basic. I'm trying to make a new file that asks with a button for two files. Both have vehicle information, one in column A and the other one has same information in column B (as the images show). The...

Hi All, The following code moves data to an archive sheet, based on the value selected from a list in column P. It also looks to see if filters have been applied and ensures the data is moved to the next available row, regardless of filtered data. It works perfectly, however, I'd like the...

I am looking to make a Macro in VBA that when run: creates a new sheet called "results" after the first sheet (to the right) on the original sheet search Colum B for if any of an array of words is present in a cell if it is to select the row and move it to the sheet called results delete the...

Hi all, I currently have the following VBA code attached to a macro that sends out an email and attaches a word file to it when I click it and sends this out to a list of emails (and also BCC's a list of emails): Now I want to edit this file so I can target a list of emails in the emails...

Hello. Here is what I'm trying to do. On a monthly basis and within the same directory I could have 5, 10, maybe 20 files that need to be processed. This number will vary.... Directory - C:\Monthly Processing Now on a monthly basis, the files within Monthly Processing will also be named...

Hi All, Currently, no field can be empty, when I hit save. My question is, how can I make it so that when Primed is selected and any other fields are empty it would auto writes N/A on the database when I click save? Function ValidateEntries() As Boolean ValidateEntries = True...

Hello I hope some genius out there can help me. I have a cell in sheet 1(call it the source cell), hyperlinked to a hidden sheet. The text in the source cell and Sheet Name are the same, so when i select the cell, the hidden sheet opens. Here is the VB routine i am using: Private Sub...

Hi, I have a question, I hope I can explain my self clearly I have a form called userform1, this form is to show information about people , I can find them by id or by name, I can modify information from that form. As you can see, beside volunteer name box, there are two search buttons, if you...

I have a question, is it possible to copy the values from 2 cells in one workbook and paste the sum of those two values in a single cell in another workbook? Using a VBA macro Example, A1 and A2 in workbook1 worksheet 1. Copy the values of those two cells and get the sum of those two values, A1...

Hello, I was wondering if there is a way to have three workbooks. Workbook1 has multiple sheets, example sheet1, sheet2, ect, with tables with cells containing questions and then the cell next to it where values can be typed into. Workbook3 has the a similar format but the cells that need...

Hello Guys I have in my excel spreadsheet a high number of pivot tables and a worksheet called "Data". I would like to know if is possible after delete some lines in this Data tab, if the all pivot tables can be refreshed automatically. Can you pls help me?

i need to make an list to keep up with inventory. I have 4 columns. Column A is the facility it was sent to, column b is the it item number ( 1- 120), column c is for the date sent out to the facility and the column d is the date that the item was sent back to our office. what i need is a code...

Hi all, I wonder if I could get your advice if possible to perform the below requirement. The below code is assigned to a shape within excel which basically turns off or on excel formula calculations when the button is clicked. Sub btn_autocalc_Click() If Application.Calculation = xlManual...

I find this code on site. Private Sub Workbook_Open() UserForm1.Show End Sub It's not working. I want to open «Visual Basic» after starting «Excel» then open the window 'Module1' for example. Is it feasible?

HI. I have an app. that read many files. now requestme the files must be clasificated in different folders. Now i read the files from application.path & "\data\*.xlsx", but now the folders with files are out of application.path. now!: .................................................. ...

Hi There We have a Fingerprint reader for our staff Time & Attendance. Attached the standard report from the device - untouched https://www.excelforum.com/attachment.php?attachmentid=607220&stc=1&d=1548060569 Now in this report, it give a daily breakdown of the Employee Check IN, Breaks and...

Hello everyone, I'm not well versed on VB or Macros, and that will be Obviously apparent when you see my workbook. I'm trying to write a code that will allow me to hide and unhide sheets based on once cells value. However, my code writing is terrible. I've been racking my head for 2 or 3...

Hi All, Hope everyone is well. I wanted to create a macro in excel in which when I run it will look into outlook and for this specific email and copy and past the table data from this email into a same size empty table into excel. In more context I have to copy and past this from the email...

Hey, Friends; So lets say I have 4 box sizes with their dimension in a list. I also have an array of objects to fit in the boxes with their own dimensions. I only want to fit one item in one box so i want the box that fits the item the best. Under my "box that fits" column, I'd like a formula...

Can anyone help with the below, I am trying to pull the data from the table at the following website (all pages 1-7) +Digital – Fund Centre I have the below code BUT its only pulling through the table headers ... any ideas? ' return the document containg the DOM of the page strWebAddress '...