Mark as solution
Although the "Mark as solved" concept has never been used at the MrExcel Message Board since Bill launched the forum in 1998, the new feature "Mark as solution" is different in that marking a post as a solution does not lock the thread. This allows members to offer alternative...
Greetings Folks,
I have tried to figure this out but I've yet to come across something that will allow me to make this happen.
Every morning I have to open an Access File and press the "Run All" button which will do the macro that's found in the "Code" area.
Is there a way that I can setup...
I made a careless mistake and left the 'Lock project for viewing' box unchecked and sent out copies of one of my models. A project password already exists. I had just unchecked the 'Lock' box for my convenience while I did some annual updates, but then forgot to check it again before sending...
hi can you help please I have the code below which once updated updates other workbooks as they are all linked together, but for example if book 17 and book 18 is open and someone updates book17 then book18 doesn't update and becomes a read only file and wont save, can you help please?
Option...
Hi there,
First my apologies if there is an answer to this already in the forum, but the amount of info is a little overwhelming and I'm taking the quick route; hope you don't mind.
There is a register related to my work that I have to check every week to see whether there are new entries or if...
Hi guys
i have the data below
<tbody>
name
jan
feb
march
april
may
jun
jack
10
15
17
17
</tbody>
I have created a sparkline based on this, I dont have the data for may and june as of yet.
Can i set this sparkline up so it automatically updates when may and jun data comes?
at the...
I have a chart in a sheet that doesn't update when a macro I wrote runs.
After if I click on the chart it updates.
Any idea what I can do for quick fix.
Is there a way of changing the GMC range automatically for the formula below?
=DMIN('CEA - ALL'!$A$1:$O$1172,15,GMC!A1:A2)
When this is copied to the row below it updates to A2:A3 but I want it to change to A3:A4, A5:A6 etc
Is this possible?
I have sheet "A" with shapes which updates when changes is made in sheet "B". I need to protect sheet "A" since no one touch the shapes. The problem is that since sheet "A" is protected, updates fail. I need a macro that unprotect the sheet, then update and then protect the sheet again.
Is this...
I.m running XP and updated my Office a couple of days ago. Ever since I've had to uninstall an Update (KB4462157) each day or it won't load.
From Googling it seems I have to turn off Automatic Updates. Can this be done for Office/Excel or must it be Global for the whole computer.
I don;'t think...
Hello! I have a simple, yet not so simple problem to solve. At work we get hundreds of bank transaction files from the bank. We have an employee who has to go into each file and change the account number to the account name. This is not a value add task if you know what I mean.
I know what...
I have a checkbox on each row of my spreadsheet.
How do I code a VBA module (?) that runs each time the check or uncheck event fires, and updates a cell on that row?
I might be approaching this completely wrong. Please feel free to scold.
In my workbook I have a sheet called Master Tracker for tracking all things including installation dates. Weekly we receive an updated file from another team called Weekly Updates that has install date changes. What I...
I subscribe to a service that sends real-time updating stock prices directly to my spreadsheets. (Hoadley Financial Add-Ins for Excel.)
Using various posts on this site, and much trial and error, I cobbled together a little VBA code that monitors these stock prices and notifies me when my open...
Is there a way to edit cell M2 on Sheet1 where it updates on Sheet2 as well, but if I edit it on Sheet2 it updates it on Sheet1 WITHOUT grouping or selecting the tabs? Can I somehow specify that a certain cell is live and active through all sheets?
I currently have an equation on all sheets...
hi all.
i'm trying to work with live data updates on onedrive.. but can't seem to get things to work seamlessly, so i'm toying with the following;
Sub TESTOPEN()
Application.ScreenUpdating = False
Dim wb As Workbook, sh As Worksheet
Set wb = Workbooks.Open("MYFILE")
wb.RefreshAll
wb.Save...
I am using this formula to number items on a sheet. When I add or delete rows the row numbers for each item updates to give the correct count.
=IF(B3600<>"",COUNTA($B$2:B3600),"")
How do I continue the number count to multiple sheets
Hi there. Very new to VBA and macros. Not sure what im doing.
At the moment i have recorded a macro that pulls information in from another excel spread sheet and sorts it. But a new spread sheet is brought out every week with the same name except from two numbers in it.
Is there anyway i could...
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.