Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #12  
Old 05-17-2020, 05:28 AM
ArviLaanemets ArviLaanemets is offline Add Row to Weekly Schedule Planner1 Windows 8 Add Row to Weekly Schedule Planner1 Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

To add a row e.g. into weekdays box, select a worksheet row which is contained in this box (click on row number at left border), copy the row (richt-click with mouse on activated row and select 'Copy' from dropdown menu), and then paste a new row into same position (right-click on row number at left border again, and select 'Insert Copied Cells' from dropdown menu).

To delete a row, you select a worksheet row you want to delete, right-click on activated row, and select 'Delete' from dropdown menu.

When you add or delete a row/rows, you have manually edit white colored rectangle which surrounds your tool (its size doesn't change when you add or delete rows) To activate the rectangle, you have to click on any of it's borders. You can see e.g. left border, when you select columns A:B.

Data Validation List values (x or ✔) are defined from menu Data>Data Validation : Allow = List

When you activate from menu Formulas>Name Manager, you see 2 defined Names. The value for Name StartDate is read from cell with date for Monday of week below your planner header. The value for Name WeekStart returns error. Probably at some time someone tried to make the planner to work with any date from week entered (enter any date, calculate monday of same week as WeekStart), but dropped the idea, and Weekstart is now abundant. The name StartDte is used to calculate day numbers in weekdays box headers, and for determining text format in weekdays box body.

In weekdays box, day numbers are calculated adding values 0...6 to StartDate

In Weekdays box, several Conditional Formatting rules (menu Home>Conditional Formatting Manage Rules) are defined, which must format texts entered for current day as strikethrough, and colour Data validation selections green (✔) or red (x). Those rules are currently quite messed up - some rules are defined for ranges where is nothing to format, there are ranges where no needed rules are defined, etc.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate weekly consummation of ingredient Acc.mero Excel 0 07-30-2018 07:03 AM
Importing schedule into another schedule and keeping the links abby1428 Project 0 03-16-2018 04:21 PM
Weekly Calendar- at a loss 04herrs Excel Programming 3 02-15-2017 05:14 PM
Add Row to Weekly Schedule Planner1 Need weekly Work log template recommendation Shazamy Excel 2 10-04-2013 10:50 AM
Weekly Calendar Monoceros Project 0 11-05-2010 03:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:57 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft