marco

Hello, I’m trying to write a vba script to return all columns that match a list of numbers. Some numbers have multiple rows of data. I use the choosecols and filter function to return the data which works. Now I’m trying to write a VBA script that does the same thing. Problem now is that it’s...

I'm new to Macros, I'm currently putting together a spreadsheet to track finances. Each row has very little calculations that need to be copied, but I know how to sort that part with a macro so that's no problem. What I'm trying to do is make a button where I click it, and it adds another row...

Hello Everyone! Happy New Year! I am making a model and would like to create a landing page where I would type numbers and click on a button. When I click on this button it creates a copy of another sheet and makes the adjustment stated on the landing page. Is this possible, if so how can I...

Is there VBA macro where you can copy a value from a cell in one worksheet in a workbook and if that value is = to "X" In that cell then it paste the value "YES"/"NO" in a cell in another workbooks worksheet?

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 everyone, I'm trying to create a VBA program that will do the following steps 1. Loop through excel files in specified folder 2. Go through each file 3. Search in column B for "INTL" and/or "TRAX" 4. If "INTL" is found in column B, select that cell, move one cell over to column C, and...

Hi! I have excel file which is saved locally in OneDrive folder but is shared within office 365 so can't use VBA. So I need to run a macro from MS Outlook to copy data from the excel file and past it in the new email's body. Here is the whole routine I want to automate: 1) Open the excel file...

hi, how can I add column 1,2,3 here instead of column 3 only? I want to compare three column to get the unique value. str=ar(i, 3) Full Code Option Explicit Sub SumandRemove() Dim ar As Variant Dim i As Long Dim j As Long Dim n As Long Dim str As String n = 1...

Del Duplicate Row if Col A, B, C matched I had thousand row, so possible to use macro?

Hi How can I make the second marco print out the values from the first macro? for example I want to use the second marco to msg out x and y which are variable in first macro. Thank you so much. Sub myinputbox() 'to use msgbox Dim x As Integer Dim y As String x = InputBox("enter...

The pic1 show original, and the marco will auto fill down as show in pic2 (yellow)

I have set a button to run Marco for the subject action . However, the file name of Workbook A will change every day. I need to correct the file name of Workbook A in Marco before click button. I want to skip the correction step. Please help. Thank you.

Hello, I have a macro with VBA for this monthly chart that I make. I have a bunch of repeating lines of code that go for each day of the month but it ended up being too large of a procedure, so it doesn't allow me to execute it. I was wondering if I could get some help to possibly shorten...

Hi guys, I want to be able to use a value in a cell to give a ROW a named range name. The reason : I have 500 of them to name. I can easily dynamically pop the name I want for the row in a cell ( in this case I column G). Ideally, I want to write a macro to step through the rows, where it...

Can I skip/disable a sub code before run my marco then recover it like as following: Private Sub progress() Skip run/disable Sub Worksheet_Change(ByVal Target As Range) My Marco Recover/enable Sub Worksheet_Change(ByVal Target As Range) End Sub

Please,can someone help me write a macro. I have an“A.xls” workbook where I want to open then copy a range of data to “B.xlsx” file. B.xlsxfile has the same format as a.xls so the data being copied will fit the samerange. I then want to password protect the new workbook (B.xlsx) and rename...

Can someone please help me with possibly an advanced macro. I process a bunch of different reports with different sizes, sometimes single tabs, sometimes multiple tabs, different rows or columns of data and different formatting etc. But every report I send has a few formatting requirements and I...

I want to record a Marco to total column J and put the total at the end of the list. The difficulty is that I want to use this Marco on lists of various sizes. the curser May be anywhere on the sheet and when Marco is run it should always go to the end of column J. One sheet may be 250 lines and...

Hi, How do you get a marco to work with hidden worksheets?

Hello, I have written the following code, to copy relevant information into a different workbook, and then run a marco in that book. but it cannot find the Marco, "Macro3" Have I missedsomething? The data has pasted across,jut need t Marco to run. Thak Sheets("summary").Select If...