macro - all sheets

As a Macro rookie, I'm looking for how to exclude certain worksheets from a macro. The workbooks I'm working with are generated as a report output from our database. The format of them means that if there is no data then that worksheet only has info in cell A1 to say there is no data available...

Hope someone can help me. My base macro works fine when I run it on one worksheet (with any name), but when I run the macro below, which based on my research should run across all the workbooks, it only runs on the worksheet I'm on. My workbook will have a different number of worksheets, with...

Hope someone can help me. My base macro works fine when I run it on one worksheet (with any name), but when I run the macro below, which based on my research should run across all the workbooks, it only runs on the worksheet I'm on. My workbook will have a different number of worksheets, with...

Hi there! I'm working on a shared Excel tracker used by six team members. Each of us has an individual tab where we log incoming requests, and each request is assigned to a specific team, recorded in column I. Since workload fluctuates, requests for the same team may appear across multiple...

Hello, I need help writing a macro for a spreadsheet. I would like the macro to time out a spreadsheet after ten minutes of activity. I would also like a pop up window to ask they user if they are still working, and if they do not respond to the pop up to automatically save and close the...

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