vba & code

Hi, I currently have 2 steps of code which work fine but I want it to work off of one button press to take the data from one workbook to multiple other workbooks and save as per the name. The first set of code filters it but puts them into sheets and the second set of code converts those sheets...

I am trying to Copy from 1 workbook (S.xls) and pasting into (PD.xlsm). However I also get the same error 1004- Application-defined or object-defined error at this line "lastCol = sh1.Cells(1, Columns.Count).End(xlToLeft).Column" Sub Rectangle1_Click() Dim sh1 As Worksheet, sh2 As Worksheet...

Hi All, Please note I already have a code that works but I would like to do it faster. Dim X1, X2 as worksheet Set X1 = Sheets("DataBase Hierarchy") Set X2 = Sheets("Tool") X1.Select ActiveCell.Offset(0, -1).Copy X2.Select ActiveCell.Offset(0, 1).PasteSpecial xlPasteValues...

I'm having an issue with getting the MACRO to copy from the correct sheet when it is taking data from another excel work book. The issue is even though I have the sheet search on for the "TOP" it will copy form which ever sheet was last active when the excel was open. I currently have it set up...

I want to filter and split the data based on branch name (Branch List sheet), and also want to save that new excel workbook for each branch as per the same name as mentioned in the Branch List sheet. Please help me with LOOP function to complete my code.

Hello! Thank you in advance for visiting my post. I understand there have been a couple posts here already that ask for help regarding VBA code and moving data from one sheet to another based on a drop-down value, I appreciate your help nonetheless. ---------- We are approaching territory...

Hello everybody, I'm new here and also fairly new to Excel VBA. My problem is that I have two subs 'combined' in one sheet, but only one works. The first part of the code enables me to select more than one worker in column G from a drop down list and is working just fine atm. The goal of the...

Hi All, desperate for help. I have a scenario that I'd really appreciate a piece of VBA code to run. I have a table of information in sheet 1. It runs across the rows. Based on the data in the Score column (Column B) and the Age in the Age column (Column C). I would like the code to select...

Hi VBA Developers, Hope you are fine, Please note I have been trying to create a database but in this case, I only need a column with the data, based on some parameters but during the process I am confused since the code I think should have some loops. Probably my code is a mess, but...

Hi; I have a login form where the password is displayed with * How can I display the password using the checkbox?

This is some (poor) vba code I wrote in order to take multirow information and unpivot it for a table that will be used elsewhere. I know unpivoting can be done in power pivot or even just in excel, but in my situation, having a macro run this code would be a whole hell of a lot easier. Thank...

Sub macGL_Detail_ImportAndFormat() ' ' macGL_Detail_ImportAndFormat() Macro ' Dim fileLocation As String Dim fileToOpen As Workbook Application.ScreenUpdating = False fileLocation = "\\company.corp\files\KDrive\DM Monthly Close\2024\04 2024\GL Detail\04 DVH Detail.xlsx" 'I would love to be...

Hello experts, I do have excel files (1 sheet per file but headers are different) to download everyday. I need to transfer them into a masterfile (grouped into sheets) then the process will repeat the next day but the masterfile is still the same. Basically the new values will be pasted to the...

Hi! I'm a complete begginer, so i don't know much about coding. I'm trying to create a button to run a macro that does the following: 1.- Save sheet2 in a specific location as PDF and saves the hyperlink in sheet24 of the active workbook in column 11 2.- Save a copy of some of the sheets of the...

Hi Team, We have a requirement to create multiple workbooks containing one-line questions and answers to share with our internal supplier team. We are looking for a fast and efficient way to generate these workbooks. Can anyone provide guidance or suggest techniques to streamline this process...

Hi there, I'm a bit stuck on some VBA code and need some help! I want to create some code for a macro button that will auto populate a value from cell A1 in cells Q19 and AJ19 and carry on doing this every 14 cells in both columns. It would be great if the VBA loop ends at row 355 as this is...

the cells have a number associated with it which looks something like this ,column A & B will never have any color the columns and rows are dynamic the Output is expected something like the below. the green columns B-C should only be populated when the whole line is green and only first...

Hi Everyone, I have an online appointment scheduler, using "https://www.squarespace.com/acuityscheduling". So far I have been manually copying all of the client information manually. Below is the information I gather manually from the website and put in my excel sheet. Is there a way I can...

Hi there I would like to know how I can set the following type of invoice numbers to be recorded on a different sheet by the use of a button form control and how I can use another button form control to automatically generate the next invoice number when I press the button as the sequence...

Hi all, I'm trying to automate the filling of a word template contract and I keep getting the 462 run-time error. The debug gives me the error colored in red below. I'm hoping for some directions on how to correct my code. I've tried couple of things already but nothing seems to be working...