automation

Greetings, I have an excel document that tracks items on a "to-do list", I have an active and historical tab. Active for anything that is still outstanding and the historical for anything that has been completed. I am running a code that will automatically transfer my active tasks to my...

Hi everyone, I appreciate everyone who takes a moment to read over the problem I'm trying to solve. The image below is a list of 10 records that equal a total of 4 sets of "Washes". Problem: Humans have to manually identify washes and remove from "Master" Sheet. We currently have to highlight...

I am seeking guidance on using VBA to automate the generation of monthly financial reports, including balance sheets, income statements, and cash flow statements. Our trial balances are generated through Microsoft Dynamics and we employ an internal mapping to link all TB accounts for financial...

as you can see i have a table in which i have employee names & id, then i have columns where i have typed month, week, and the date- I have this so i can track where my resources are working and should be working to make the project finish on time. I am using =COUNTIF(Sheet2!$D$7:$D$899," ")...

Dear All, I have a 3 sheets in a workbook with many slicers and it is pain to clear them one by one and then reselect every time to do various analysis. There is only one/two slicers that will have fixed values. I am looking for a VBA code, which will be assigned to a button. on clicking it...

Hello guys, I really need help solving this, it would save me tons of hours. I will explain what I need to do. I have about 400 txt files that look like this: I did some notes with red text: And I have to format this data so that it looks like this: Like I said I have 400 text files which I...

I am trying to run a macro calling the Solver functions on multiple sheets. The Solver area works on a single sheet, but returns the error message on the 5 worksheets I am attempting to calculate. Any advice is most welcome. Also, running this macro switched calculation mode to Manual. I have...

I am trying to scrape data from website on bases of product name. There are different rows in web table for a unique product. Some have single row from which I have to grab data, some have two rows and some contain multiple rows. What I want to do is count the number of rows of that product, and...

I am looking for a solution similar to the following thread VBA to place images inside a PDF??? but instead of adding the image at the bottom of the PDF, is there a way to find a specific text on every page and add the image next to that text? The position of the text to find is different on...

Greetings Everyone, This is a sample worksheet, where there are group leaders, their email address and funds used by group members, I want to update each group leaders about stats of funds by group member each day via outlook. We can have any number of group leader and any number of group...

I've got the below setup, trying to have a filepath reference the workbook name listed in CurrentIndia, highlighted below. I've named the range officially CurrentIndia in NameManager: But everytime I edit the formula or re-confirm it, the Update Values window pops up everytime, and I have to...

I have a set of formulas on a separate sheet from where I need them. I have them listed as the person and the formula needed to calculate their specific value. If I try to use a VLOOKUP the equation populates but acts as text and not a formula. I've also tried using an INDIRECT function to add...

I have a macro button that copies the sheet to another sheet and deletes everything from th original to have it blank for the next use. Currently the sheet is going to the end of the lists of sheets but I want it to go to the beginning of the list. My current code is as follows: Public Sub...

Hello :) I have a problem with my macro that should find me a lowest result in the column and add 1 to it. Macro is started from my outlook and should work on unread emails in my Inbox. Result of Macro should be name of subfolder where my email should go. In Outlook I have code: Public Sub...

Apologies if a silly question but haven't been able to find the answer by Googling! I would like a cell in a table of data to update automatically based on a criteria. Basically I want to define the catergory, which is names of businesses, and when data in the table corresponds to that business...

I have a workbook that has an initial form that I fill out and once I'm done I press a form control button that copies everything to a new sheet and deletes all input information from the initial form except the logo and the form control box. Currently the form control box stays active in the...

Hello excel experts, I have a VBA code via the magic of ChatGPT: Sub DuplicateTemplateSheet() Dim templateSheet As Worksheet Dim newSheet As Worksheet Dim sheetList As Worksheet Dim sheetName As String Dim lastRow As Long Dim i As Long Dim tbl As ListObject ' Set a reference to the Template...

Hi all , I am trying to copy part of an element text and paste it in another element ,in its search box. The element contains a a policy number that i need to check in another system and it looks like this 60.22.9591 / RANDOM VENDOR NAME I need to get the numbers before the "/" and remove the...

Hi all, I am trying to find a column letter based on a text ,contained in a cell. I managed to find the letter, but the next part is what bothers me. The column letter(declared as "trcol") is a part of a loop that goes through the table and copies certain values based on that column.So that...

I am currently automating several procedures on a webpage using selenium type library in excel. Currently i am facing the following issue: my code finds a table is supposed to click on each row , do some other things,come back to the page in the table and proceed with the next row. The issue is...