coding excel

Hello! I need help getting VBA to Merge PDF's based on the path. I've attached a photo. Column A, B, C are file paths as they currently exist. I need VBA to grab and merge all of these columns files and use the Output location in column D as the reference for the new path name and where it...

I need help. I need to write a VBA code where I need to match an ID number from the answer sheet to each student submission ( open each student submission separate) once that's done I need to grade it and assign a grade. IF IDs match ( student to answer sheet) then it's a point, if they don't...

i need a vba code then help me read the body text outlook inbox if the body text is (please file) then move specific email into the folder ie C:desktop/dummyfolder/

I am trying to make a code that makes the program write data in a specific excel spreadsheet according to the value of the variable "MachineName" declared as public What happens is that the program does not allow me to do it because an error is detected on line 96 The error: The code...

I am in an internship in a company, I was offered a job in VBA that I am not able to do, the project's goal is to take a print of all forms of the application and export them to PDF with the data that I was inserting throughout the process and insert those forms in a folder whose name would be...

Hello guys! I need to make a database viewer on excel, a simple form to show some infos in one place. i`m new with VBA, so i`m trying to do by myself, but every time i got stuck with the code. here`s the thing, there`s more than 1 sheet and i need to work with it dynamically and with a image...

Hello everybody, I have the following list of information: Is there any way in which I can alphabetically order this list with respect to column B? Would greatly appreciate any assistance I can obtain! :) Thank you very much everybody. Best regards, David

I'm a new to this forum and I kindly need your guidance here on the below :) I have a excel macro-enabled workbook that I want "any user" to be able to use on their desktop. This workbook can be saved on any location on the user's PC. It requires "XML" files extractions to pull in the data...

Hello, I would like to change the colour of the cells based on a rule permanently. I used conditional formating for top 2 values in each of my columns. It was supposed to change the colour of top 2 cells in red and it did it, but after that I needed to copy and paste only the colour of the cells...

I know it may be a novice request and an even easier solution but I wanted to know what the VBA code would be to remove the duplicate in one column and its correlating data in other columns and only keep unique items. To explain: I have a spreadsheet with 7 (A-G) columns with numbers in Column...

Good Day, Im not a pro with Excel, and need some help with a spreadsheet collecting Data, I need to build a macro for the following: pulling Rack prices on Gas and Diesel out of Edmonton, and WTI Crude I have excel 2010 currently and want it to go into a spreadsheet daily so i can monitor the...

I run a report everyday that puts the the word "NULLIFIED" in either column "L" or "M". I would like to create a macro that would delete the a row that has the word Nullified if nothing else appeared under the columns G, H, I, J, K, L, M, or N in that row, however if there is other data under...

Hi, Here's my problem with my Userform. I have three(3) statuses namely, "Good", "Bad", "Normal" from which i wanted to appear in one of my userform's Textboxes everytime i tick a checkbox. Let's say i have 3 textboxes and i ticked one of them, my userform textbox would automatically show...

Hi, I've been trying to figure this out for days and cannot seem to get around it. I'm wokring on an excel workbook that will be used for various forms used for types of work (W2 employee, 1099 employee, etc), the workbook has various tabs that go according to the form needed and includes...

Hi everyone, To start off, my knowledge of coding is minimal and I do not have knowledge of this field. What knowledge I have is rudimentary at best though I do know how to use Excel, functions, pivot table etc. :crash: My needs are as below and I hope I be able to find someone here who can...

Excel code? Hi need a command that will be able to give me the number of applications which are "completed" by a certain agent for the current month. I have two sheets, the first has all the applicants details (name, contact details, status and date completedand the agent who referred them) So...