macro - all sheets

I recorded a Macro, to get this, but the record can't actually work with returning the value and going to the next row on it's own. I'd really appreciate any help. If this can be done with a Formula or VBA macro, i'd greatly appreciate, thanks. Sub MacroTest () ' ' MacroTest Macro ' 'fileX...

I piece together weekly reports for my team. I keep row heights at a minimum 75.00, 100 pixels and maximum 203.25, 271 pixels. To take a lot of time out of this task and make it automated, I would like to conditionally format (though probably not possible based on my research) or enter a code /...

Hello All. I created a macro wherein the data captured from SAP and imported via power query will automatically pasted on another sheet of the same worksheet, what happened is that even though the query is updated once I ran the macro it captured the previous data generated from power query...

Hi, I am trying to create a macro or a script where it automatically deletes all rows that has a blank cell. When recording the script on Excel it recognizes the steps that I am doing but when I use it on a different sheet it doesnt do it properly. Please help. Name Location Sale Aaron USA...

Hi, first off I have gone through a number of posts that seem the same/similar to my request but the code will not work for me. I have 33 worksheets that I would like to be renamed by the value in A2 on each of those sheets. Ex. If Sheet3 has 12345 in A2, I would like that sheet named “12345”...

Hi I have the code below that is not working. I have two problems, it runs for the first row of my file then the message box pops up and then it stops and then if I run again, it restarts from the top and it replaces the numbers on column E with new numbers. 1) How do I get the macro to...

Hi , I Am currently creating an Audit Tool for Excel. I have create a VBA where the function will calculate the total number based on each name and its respective class from a raw data in Tab "Raw Data" and populate them into Table Below .However , To do the audit , i would ask the auditor to...

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 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