Please remember that while cross-posting is allowed, you need to include the links to your other post(s).
https://www.mrexcel.com/board/threads/need-suggestions-on-what-to-use-for-a-real-time-tracker-which-auto-refreshes-the-data-every-hour.1256648/
Thanks for trying Hui. Is there a good/better way to contact Chandoo? It seems like we need more of a super-admin presence in the forums. I've not been successful in my attempts to reach out to him.
Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
If you do cross-post, please put that in your post.
Also if you have cross-posted and get an Solution elsewhere, have the...
Status update: Sadly, I've not been able to get a hold of Chandoo or anyone who can actually implement the change to the forums. Continuing to try and reach out. Maybe they're on travel? :(
Sorry pecoflyer, but I have been researching and trying to see if that's an option with our current platform. I can see and we've discussed porting to a different forum platform, but so far that is being considered a larger undertaking than we want to do for just a "quality of life" improvement...
Hello everyone. Sorry for not seeing this until today; long weekend for me. I agree that conveying what version of Excel someone is using is a key piece of information. With the current forum tools available, there's certainly nothing stopping us from including that info in a signature. You...
Edit: Typo
Sub SendEmails()
Dim lastRow As Long
Dim OutApp As Object
Dim OutMail As Object
Dim strbody As String
Dim i As Long
Set OutApp = CreateObject("Outlook.Application")
'How much data is there?
lastRow = Cells(Rows.Count, "A").End(xlUp).Row...
@grcshekar
You have cross-posted again to another forum w/o providing links: XIRR modification to ignore some columns (excelforum.com)
As you've already been previously warned in this thread about this, and continued to break the rules, this thread will be closed. Please remember to follow...
Address and MATCH function tell the formula to look in G9. Then you told it to offset 2 rows in the first OFFSET function, landing you on G11. Then you told the outer OFFSET to go down 1 row and over 2 columns, landing you in I12, which is a blank cell. Thus, the value is 0.
Overall, this is a...
Calculate duration, and then do a stacked bar chart using Start time and duration. Format the Start time series so that the duration bars appear to be floating.
With your example data, I'm assuming Branch was supposed to go from 11 am to 1 pm (you had till 1 am).
The processes don't appear to...