macro - all sheets

Hello, I am very new to VBA and trying to find out how to make this work. So basically I have a Checkmark from D2 to unlimited. When Checkmark is clicked > Display Message I have the following code written so far but I don't know how to display my message without having to run the...

Hello I would like to run this code on all worksheets. Currently, it works well on one sheet. How do I change the code? Many Thanks Sub Sort_by_colour() ' ' Sort_by_colour Macro ' ' Columns("A:A").Select ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Clear...

Hi! Wishing you all a Happy New Year! This new year- My goal for this year is to ask for help and to understand macros and formulas more but since my workbooks seem a little tedious. I wanted to reach out because I have this extensive workbook with multiple formulas but I'm sure there is a...

I've been seaching everywhere to find a way to auto filter the table (column E8:E) on all my sheets (more than 100) containing a filter that updates when an employee changes quarter (Dw Day week, DWE Day weekend etc.) It would be nice if it would update automaticly or just when someone opens the...

I have a column as ZIP code based out of USA that can have maximum length as 5. If I give 11, then it can take 000 as predecessors and become 00011. I tried formatting cells option but that has options to make it 0011 or 000-11 or 000000011. I am not getting options to make 00011. Any leads on...

I have a file that contains three detail sheets and a pivot. I'd like to filter all three sheets based on column A and create a new workbook for each value in column A. The new workbooks would contain the three detail sheets and the pivot only containing data that has only data for one of the...

Hello, I need assistance trying to figure out a way in which a formula will run based on a word within a specific column, and populate results in another column. EX. In column A if I have the word "Monday" then this formula will run and populate result in another column If I have the word...

Hello Gurus, Do you have any thoughts on how to code this scenario (see image below)? I was thinking of using Cell I2 in SHEET 1 as reference in order to pull the info from the different sheets (specific Data sheet and Others sheet). Appreciate the thoughts. :)

Hello New to this forum. Due to the legal need to delete data after 6 years, I need VBA code to do the following: - on X date - wipe all data from workbook, including all the sheets - delete version history (so it can’t be recovered) - if possible, replace with a message “data deleted -...

Hi Gurus, I have some columns that I need to delete however, there are embedded picture image in cells. I tried using below code but the picture are still visible. = = = = Sub Delete() Worksheets("Sheet1").Activate Columns("C:C").Delete Columns("X:Z").Delete End Sub = = = = Is...

Hi Gurus, Could you help me simplify below code which I recorded? Basically, I need to apply these conditional formatting and hoping that the macro will look for Change 1, Change 2 and Change 3 header name and reflect the number format for all tabs (as the column might interchange on the other...

I have a VBA macro that i want to run. It is supposed to pull MP3 + Wav meta data into excel. When I run it, it seems to work but doesnt actually pull in any data. Can anyone suggest what might be wrong? I am very inexperienced with VBA. Thanks, WC

Hello, I am extremely new to VBA. I am trying to do something very simple and I am running into this error. In my Excel Workbook, there are several sheets. The ones of interest are named "CAR Daily Report Macro" and "CAR Daily Report." I am setting up a macro to copy and paste data from another...

Hey, I wanted to copy the values of a coloumn. The coloumn has following formula "=INDEX('Planungsakte (2)'!E:E;VERGLEICH(C3;'Planungsakte (2)'!C:C;0))". VERGLEICH is the german term for MATCH. I just wanted to copy the values and paste it somewhere else in excel because i will delete the excel...

Hey guys, As the title says, i have two sheets named A and B. I import excel data from a report into sheet A with columns going from a - z, what i am trying to do is set up a formula or macro on sheet B that will automatically fill data from specific columns in sheet A to sheet B. IE Sheet A...

Heya I don't know much of anything about VBA or coding or whatnot so please forgive any ignorance I may have but if someone could create a macro for me that would be amazing! So I have an excel spreadsheet where I keep track of various entertainment I enjoy and in particular shows and any...

Hello: I have a workbook that has several spreadsheets. In some, but not all, of the worksheets in the workbook I need to add a formula to a specific column. I have a macro that will add the formula to all the worksheets but is there a way to omit a few of the worksheets from the macro?

Hi I need to do a homework but I can´t understand how to it. My teacher wants a Macro and a button. When I press the button she wants that the button sort the selected range. Please I need help, I hope someone can give me a hand with the code, it will be great.

Hi, My team pulls open orders weekly and puts them into a workbook. This workbook has all the columns/data I need but I want it in a specific format and it is also always put in the same place with generally the same name. I need to pull into separate workbooks the sum of units by the due date...

I use a spreadsheet to track when I need to call a client after a set period within a given territory. Each client territory is represented on a different sheet within my workbook. I already have a macro that can move a client, represented by a row of data, between any of the sheets of the...