Calgarypuck Forums - The Unofficial Calgary Flames Fan Community
Old 11-14-2018, 10:19 AM   #61
Wormius
Franchise Player
 
Wormius's Avatar
 
Join Date: Feb 2011
Location: Somewhere down the crazy river.
Exp:
Default

You want the same date in all of those cells, or incremented by some amount?
Wormius is online now   Reply With Quote
Old 11-14-2018, 10:22 AM   #62
Wormius
Franchise Player
 
Wormius's Avatar
 
Join Date: Feb 2011
Location: Somewhere down the crazy river.
Exp:
Default

You should just click on the first instance, and double-click on the lower right corner where it becomes a plus-sign. That will auto-fill everything until the end of what Excel thinks is the end of the column.
Wormius is online now   Reply With Quote
Old 11-14-2018, 01:10 PM   #63
Huntingwhale
Franchise Player
 
Huntingwhale's Avatar
 
Join Date: Sep 2008
Exp:
Default

I think I figured it out...just converted the dates/times to total seconds and it makes it a lot easier to manipulate.

Still sucks though.
Huntingwhale is online now   Reply With Quote
Old 11-16-2018, 03:53 PM   #64
Superfraggle
First Line Centre
 
Join Date: Nov 2003
Location: Calgary, for now
Exp:
Default

Probably too later, and not totally sure I understand what you are trying to do, but my guess is you just want to advance by one hour every row going down?

If so, in cell B2, enter both the date and the time (8/1/2018 1:22:52 PM). Format it so that it only shows the time. In A2, just refer to B2 (=B2) and format that one to show the date.

In cell B3, just enter the formula (=B2+(1/24)). That will advance it by one hour. Then just copy the formulas in the two columns down until you get where you want to be.
Superfraggle is offline   Reply With Quote
Old 12-04-2018, 11:12 AM   #65
PsYcNeT
Franchise Player
 
PsYcNeT's Avatar
 
Join Date: May 2004
Location: Marseilles Of The Prairies
Exp:
Default

Alright here's a fun one.

Lets say I want to create a WFM log for employees, so I create a "Roster" sheet on the first tab. I use the Name Manager to create a Name called "Roster", that refers to column A in the "Roster" sheet. Then, if I use the formula "=ROSTER" in the first column pf every subsequent Sheet, it will show a live update when a new employee is added to the ROSTER tab.

However, if I have formulae (using INDEX+MATCH or otherwise) or data in each row on the other sheets, when a new employee is added to the ROSTER sheet, it bumps the rest down in column A, but all the other columns stay in place.

Ultimately, how do I make it so when an employee is added to the Roster (and ergo added to the =ROSTER reference), it also effectively inserts a new Row in every associated sheet and keeps my formulae intact?
__________________

Quote:
Originally Posted by MrMastodonFarm View Post
Settle down there, Temple Grandin.
PsYcNeT is offline   Reply With Quote
Old 12-04-2018, 04:36 PM   #66
PsYcNeT
Franchise Player
 
PsYcNeT's Avatar
 
Join Date: May 2004
Location: Marseilles Of The Prairies
Exp:
Default

Figured it out using a combo of VBA, Index+Match function and workbook group edits.

Got rid of the Names altogether.
__________________

Quote:
Originally Posted by MrMastodonFarm View Post
Settle down there, Temple Grandin.
PsYcNeT is offline   Reply With Quote
Old 01-17-2019, 05:28 PM   #67
mrkajz44
First Line Centre
 
mrkajz44's Avatar
 
Join Date: Oct 2010
Location: Deep South
Exp:
Default

I want to set up a check-box at the end of a proof in a spreadsheet that I use for multiple legal entities. The check-box must be clicked to show the user did a final check of the proof. However, is there a way to force Excel to un-check this box if something in the proof changes? That way you'll know if the user did the final check and confirmed everything was okay and nothing was changed afterwards. Any ideas?
__________________
Much like a sports ticker, you may feel obligated to read this
mrkajz44 is offline   Reply With Quote
Old 01-18-2019, 09:22 AM   #68
mrkajz44
First Line Centre
 
mrkajz44's Avatar
 
Join Date: Oct 2010
Location: Deep South
Exp:
Default

Never mind on my question above, I've found a different solution. I'm going to add to the control page a threshold that is acceptable for the proof to be out. Sometime the proof will have to be zero, and sometimes within 1,000 is okay. By putting the threshold in the control panel page, I can update the threshold and then have an automatic check if the proof is reasonable.
__________________
Much like a sports ticker, you may feel obligated to read this
mrkajz44 is offline   Reply With Quote
Reply

Tags
excel

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -6. The time now is 10:10 AM.

Calgary Flames
2017-18




Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright Calgarypuck 2016