Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #11   Report Post  
Old August 4th 10, 04:32 AM
Junior Member
 
First recorded activity by ExcelBanter: Jul 2010
Posts: 7
Default

Quote:
Originally Posted by wickedchew View Post
I have corrected the error. Sorry about that. It was looking at a different table.

The only way that you can make the selection bigger is that when the zoom is set to 100% instead of 55%.
Sorry that didn't work. I am trying to put in the monday schedule as follows within the TIMES worksheet

Nick L OPEN
George OPEN
Aaron OPEN
Nick S MID
Elwin CLOSE
Wayne CLOSE

What I get in the Monday worksheet under the todays schedule is the following

Nick L OPEN
Wayne CLOSE
David #N/A
Moe #N/A
George OPEN
Elwin CLOSE
Nick S MID
Peter #N/A

When Nick L is selected under the owner tab he is populated in every cell
Thanks

  #12   Report Post  
Old August 4th 10, 05:31 AM
Senior Member
 
First recorded activity by ExcelBanter: Aug 2010
Location: Philippines
Posts: 161
Unhappy

Quote:
Originally Posted by scubadivingfool View Post
Sorry that didn't work. I am trying to put in the monday schedule as follows within the TIMES worksheet

Nick L OPEN
George OPEN
Aaron OPEN
Nick S MID
Elwin CLOSE
Wayne CLOSE

What I get in the Monday worksheet under the todays schedule is the following

Nick L OPEN
Wayne CLOSE
David #N/A
Moe #N/A
George OPEN
Elwin CLOSE
Nick S MID
Peter #N/A

When Nick L is selected under the owner tab he is populated in every cell
Thanks
I got your point. My bad....

Formula changed in each work week. You may receive Circular Formula errors. Just change the name on G10.
Attached Files
File Type: zip DTL.zip (94.3 KB, 52 views)
  #13   Report Post  
Old August 4th 10, 04:43 PM
Junior Member
 
First recorded activity by ExcelBanter: Jul 2010
Posts: 7
Default

Quote:
Originally Posted by wickedchew View Post
I got your point. My bad....

Formula changed in each work week. You may receive Circular Formula errors. Just change the name on G10.
98% perfect. Just one more thing. The last three duties need to be done by the people on the CLOSE and not the MID.

Thanks
  #14   Report Post  
Old August 4th 10, 06:03 PM
Senior Member
 
First recorded activity by ExcelBanter: Aug 2010
Location: Philippines
Posts: 161
Default

Quote:
Originally Posted by scubadivingfool View Post
98% perfect. Just one more thing. The last three duties need to be done by the people on the CLOSE and not the MID.

Thanks
Do this for each worksheet for cells G36, G37 and G38

Replace the word MID with CLOSE

BEFORE

=IF(B37="","",IF(IF(VLOOKUP(OFFSET($AB$11,MATCH(IN DEX($G$30:$G$38,MATCH(MAX($AE$30:AE36),$AE$30:AE36 ,0)),$AB$11:$AB$28,0),0,1,1),$AB$11:$AC$28,2,0)="O pen",OFFSET($AB$11,MATCH("Mid",$AC$11:$AC$28,0),0, 1,1),OFFSET($AB$11,MATCH(INDEX($G$30:$G$38,MATCH(M AX($AE$30:AE36),$AE$30:AE36,0)),$AB$11:$AB$28,0),0 ,1,1))="",OFFSET($AB$11,MATCH("Mid",$AC$11:$AC$28, 0)-1,0,1,1),IF(VLOOKUP(OFFSET($AB$11,MATCH(INDEX($G$3 0:$G$38,MATCH(MAX($AE$30:AE36),$AE$30:AE36,0)),$AB $11:$AB$28,0),0,1,1),$AB$11:$AC$28,2,0)="Open",OFF SET($AB$11,MATCH("Mid",$AC$11:$AC$28,0),0,1,1),OFF SET($AB$11,MATCH(INDEX($G$30:$G$38,MATCH(MAX($AE$3 0:AE36),$AE$30:AE36,0)),$AB$11:$AB$28,0),0,1,1))))
AFTER

=IF(B37="","",IF(IF(VLOOKUP(OFFSET($AB$11,MATCH(IN DEX($G$30:$G$38,MATCH(MAX($AE$30:AE36),$AE$30:AE36 ,0)),$AB$11:$AB$28,0),0,1,1),$AB$11:$AC$28,2,0)="O pen",OFFSET($AB$11,MATCH("Close",$AC$11:$AC$28,0), 0,1,1),OFFSET($AB$11,MATCH(INDEX($G$30:$G$38,MATCH (MAX($AE$30:AE36),$AE$30:AE36,0)),$AB$11:$AB$28,0) ,0,1,1))="",OFFSET($AB$11,MATCH("Close",$AC$11:$AC $28,0)-1,0,1,1),IF(VLOOKUP(OFFSET($AB$11,MATCH(INDEX($G$3 0:$G$38,MATCH(MAX($AE$30:AE36),$AE$30:AE36,0)),$AB $11:$AB$28,0),0,1,1),$AB$11:$AC$28,2,0)="Open",OFF SET($AB$11,MATCH("Close",$AC$11:$AC$28,0),0,1,1),O FFSET($AB$11,MATCH(INDEX($G$30:$G$38,MATCH(MAX($AE $30:AE36),$AE$30:AE36,0)),$AB$11:$AB$28,0),0,1,1)) ))

Last edited by wickedchew : August 4th 10 at 06:03 PM Reason: Ugly formula, donchatink??


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert lines in more than one worksheet at a time... Marvin Excel Worksheet Functions 3 August 22nd 07 08:36 PM
Insert Rows Based on values in another worksheet Jason Excel Discussion (Misc queries) 3 June 24th 07 01:13 PM
insert data based on time BrianMcC Excel Discussion (Misc queries) 2 March 31st 07 02:02 PM
Excel to recalculate a worksheet based on a time interval HeireneM Excel Worksheet Functions 5 March 7th 07 03:12 PM
How do I insert rows in more than one worksheet at a time? Ohio accountant Excel Worksheet Functions 1 October 13th 06 10:14 PM


All times are GMT +1. The time now is 11:52 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017