macro

1. Is there a more efficient code than the code below, as I have to run it for each participant group i.e. 10 times and VBA won't allow it because it is too long? 2. Instead of the code starting to paste in column H as the dates will change frequently, can it look up the date in the upload tab...

I'm trying to write some VBA code that will tell me if a row containing exact data exists. The table (Table1) is formatted as a table with headers, and has 20 columns; the first three columns are what I am concerned with right now. - Some projects will have multiple associated sites - Some...

Hello all, I am wondering if there is a way to get macros from installed add-ins to show up in the Macro list (the one that pops up when you click on "Macros" in the "Code" group of the Developer tab)? Currently my screen only shows macros saved in open excel workbooks. I have a lot of macros...

I have "manpower plan" sheet, and the No. lists in Column "A from 1 to N (example is from 1 to 3), Month in row 2 from 1 to M (example is from “E” to “P”). Each time, I need to calculate the subtotal Manpower for each of Team (from 1 to N) including grant total for all teams by each month from 1...

I have 2 sheets, call it ‘upload’ and ‘final’. There are calculations that are run behind the scenes I.e. other tabs that require Columns E:AN from the upload tab to be copied and pasted one at a time to the Final tab. Need a macro, that essentially does this. Copies E56,E61,E66 from Upload tab...

I have this excel macro below, where the majority of the code "seems fine" until the last row, when the runtime error comes up, stating "Autofill method of range class failed". Seems like the problem in the code is the "fillRange.AutoFill Destination:=fillRange" How would I fix this? Thanks...

hello we have an excel sheet that contain a macro who create a word document every time we running it it fill all line with "all tests" even if the line 7 is empty. not sure why. plus the word doc created put text sometime in 2 lines instead of 1 here the code : Sub Main()...

Hi - I have an excel table with 6 Columns (fixed) and then I want to be able to fill in as much content in the rows without limitation. Problem: I want the table contents to fill into the charts and automatically and automate adjust, so that it’s easy to read with the same excel sheet if...

Hello I use a macro to save mail merged documents into word and PDF files; very handy. I must select all the rows above the row I need in the recipient list for it to work. If I only ticked "Sam" and left "Connor" and "Vincent" unticked, the macro will produce a "runtime error 5631" on...

Hello- I need help creating vba code that will move, transpose, and stack data from D2:F5 and B9:F12 into B19:H26 based on number of rows and columns in A1:B2. Any help or suggestions would be appreciated.

Dear Guys, I am just start learning VBA from the beginner and really frustrating on convert excel formulas to VBA. I would like to Generate a "Consolidated Balance Sheet" table (right side) from the raw Balance Sheet data on the left via VBA. Is it possible to do that? I also attached the...

Hi all, I am new to macros and have been trying to maintain our department's macros that were built by someone who is no longer with the company. The macros are used to pull store data such as address, city, general ledger information and other data. I tried to make some changes to add some...

Hello helpful peeps! I have a massive macro that is run every month on files that are received from an outside source. It worked last month, but this month I received an error. The file received has not changed, nor has the code. I don't get it. Any help is appreciated! The line where the...

https://drive.google.com/file/d/15bM1T31K9eEbvtOL64D2i63pQ_60Zjtf/view?usp=drive_link I have an excel that calculates business position for 481 branch locations. There are certain number of branches under each Regional Office (RO/RO Name). User can select the branch by entering the DP Code of...

I've created a workbook with several coded macros of which I've assigned to buttons in a custom Ribbon tab for the workbook. When I am coding new macros or changing code, I make a copy of the workbook and do it in the new copy so as to not corrupt the current version in case I make a mistake...

Hello, so I want the following thing to add to this (I am very new to VBA and learning this since last friday): - Send Mail from a specific Mail adress (emailItem.To does not work here) - Have a Signature automatically drafted e.g. when I click the Checkmark the Mail Editor opens but my...

Hi to all of you, I have an excel sheet with an Inputbox, where i'm asker to put the number of the month, the year and a third value. Problem is, it was working as intended during 2023, but now, it's swaping the month for the day. I'm in Europe, we use dd/mm/yyyy and I'm trying to make the...

I am really struggling with this and while its just the first part it technically controls everything else. Say I have 18 (I've only shown 12) rows and the data represented in these rows are dependant on a table (for want of a better word) The table contains 4 pieces of information which will...

I'm trying to automate the sort function in excel (by levels). So I would like to first sort Column B by A-Z Then the next level is sort Column N from oldest to newest date The problem with the macro below, is it sorts Column B fine (A-Z), but then it doesn't apply the "level" criteria, and it...

I have an excel macro to do the following For Column O, for each cell in Column O, if cell is blank, then for that row, clear all cells going right. For example, if Cell O7 is blank, it will clear all the contents of all the Cells from P7,Q7,R7, S7 etc. onwards. But leaving the cells on the...