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...
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...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.