Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-15-2020, 03:05 AM
Justin Justin is offline Add Row to Weekly Schedule Planner1 Windows 7 64bit Add Row to Weekly Schedule Planner1 Office 2016
Novice
Add Row to Weekly Schedule Planner1
 
Join Date: May 2020
Posts: 9
Justin is on a distinguished road
Default Add Row to Weekly Schedule Planner1

I'm not familiar with the use of Excel. I have opened a piece of Excel software called a Weekly Schedule Planner1, & have begun entering information into the fields of the boxes provided above the weekly planner, but there are not enough rows to accomodate my requirements. I used the help function to guide me through inserting a new row to a box. (Home>Insert>Insert Sheet Rows). On selection of this function a new row is created for each box, which is fine, but it adds the new row to the top of each box, which I don't want, because then I have to cut & paste the text from each row beneath & move it up one row, until the new row free is a the bottom of the box, which is what I desire. How do I get the new rows to add to the bottom of the boxes?




I am also getting a formatting alteration. When I add a new row & go to add text, after clicking on the row, instead of the whole row being outlined by the thick green line, only a small section of the row is outlined. And if I type into the box, I can type the whole length pof the row, but if I click on a piece of text to delete, such as an typing error, a small box appears covering only a few letters of text, & even though I can delete 2 or 3 letters of text within the small box, if I click on the next few letters of the word to re-locate the small box, the letters I previously deleted, using backspace, appear again. As far as I am aware, the formatting should be duplicated. Why do I find always that ms products are so complicated to use. Most modern software uses intuitive & simple drag & drop systems for basic movement, but this system seems archaic. Every time I want to use a new part of ms office I spend days on forums learning to do the most basic of things..



Thanks.
Reply With Quote
  #2  
Old 05-15-2020, 07:10 AM
Logit Logit is offline Add Row to Weekly Schedule Planner1 Windows 10 Add Row to Weekly Schedule Planner1 Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

"Every time I want to use a new part of ms office I spend days on forums learning to do the most basic of things.."

Welcome to the world of Microsoft !

I may or may not be able to assist but ... you will need to post your workbook so it can be reviewed and better understood what is occurring.
Reply With Quote
  #3  
Old 05-15-2020, 07:20 AM
Justin Justin is offline Add Row to Weekly Schedule Planner1 Windows 7 64bit Add Row to Weekly Schedule Planner1 Office 2016
Novice
Add Row to Weekly Schedule Planner1
 
Join Date: May 2020
Posts: 9
Justin is on a distinguished road
Default

I may or may not be able to assist but ... you will need to post your workbook so it can be reviewed and better understood what is occurring.[/QUOTE]


If you click on the 4th row down in any of the upper 3 boxes then you will see how small the typing box is. If it is stretched the inside of the box becomes grey & sometimes offers a dropdown menu with options of either a tick or a cross.

This is the row that's added from following the instructions: Home>Insert>Insert Sheet Row.



Here it is:
Attached Files
File Type: xlsx Weekly Schedule Planner for Forum.xlsx (43.7 KB, 14 views)
Reply With Quote
  #4  
Old 05-15-2020, 10:08 AM
Justin Justin is offline Add Row to Weekly Schedule Planner1 Windows 7 64bit Add Row to Weekly Schedule Planner1 Office 2016
Novice
Add Row to Weekly Schedule Planner1
 
Join Date: May 2020
Posts: 9
Justin is on a distinguished road
Default

Don't worry about it. It's too complicated for my purposes. I don't want to be formatting boxes & txt fields & sizes & spaces. I just want a week planner I can use that I don't have to spend hours figuring out how to undo something I didn't realise I had done. Thanks for your time anyway. I will search for a different piece of software.
Reply With Quote
  #5  
Old 05-15-2020, 10:47 AM
Logit Logit is offline Add Row to Weekly Schedule Planner1 Windows 10 Add Row to Weekly Schedule Planner1 Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

.
Paste this macro into a REGULAR MODULE :

Code:
Option Explicit

Sub Addrisk()
Dim i As Long

On Error Resume Next

Application.ScreenUpdating = False

With ThisWorkbook.Sheets("Weekly Schedule Planner")
    For i = 1 To .Range("A1000").End(xlUp).Row
            ActiveCell.Range("A" & i).EntireRow.Copy
            ActiveCell.EntireRow.Insert shift:=xlDown  'insert and shift down
    Next i
End With

Application.CutCopyMode = False
Application.ScreenUpdating = True 're-enable screen updates

End Sub
See attached file.

To use, click on any cell in COLUMN A, then click the Command Button on the sheet.
Attached Files
File Type: xlsm Weekly Schedule Planner for Forum.xlsm (52.0 KB, 11 views)
Reply With Quote
  #6  
Old 05-15-2020, 11:08 AM
Justin Justin is offline Add Row to Weekly Schedule Planner1 Windows 7 64bit Add Row to Weekly Schedule Planner1 Office 2016
Novice
Add Row to Weekly Schedule Planner1
 
Join Date: May 2020
Posts: 9
Justin is on a distinguished road
Default

I really appreciate your assisting me like this. But as I said, I don't wanto to spend hours & days of my life on something that ought t be simple.

Anyway, I noticed you added an extra row & got the same result as I. I can't find any REGULAR MODULES, & the built in search function doesn't show any items called REGULAR MODULES either.


I added the code to a row but it disappeared.

Does ms really expect people finish off programming their software for them?


Many thanks.
Reply With Quote
  #7  
Old 05-15-2020, 11:14 AM
Logit Logit is offline Add Row to Weekly Schedule Planner1 Windows 10 Add Row to Weekly Schedule Planner1 Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

The advice of adding the macro to a REGULAR MODULE is for those who are
familiar with programming in VBA.

You can just use the attached workbook as is. It is already functional.
Reply With Quote
  #8  
Old 05-15-2020, 11:36 AM
Justin Justin is offline Add Row to Weekly Schedule Planner1 Windows 7 64bit Add Row to Weekly Schedule Planner1 Office 2016
Novice
Add Row to Weekly Schedule Planner1
 
Join Date: May 2020
Posts: 9
Justin is on a distinguished road
Default

Thanks Logit. I don't know VBA. Tyhe workbook though, by which I assume you mean the weekyl planner, has the same issue as the one I uploaded. The new rows have small fields when I assumed they should be the same format as the others. As I said, not to worry. I haven't time in my week, ironically, to learn so much stuff just to work what should be a simple to use planning tool for entering in my weekly tasks. It's odd though that there really don't seem to be many of this type of software when I search.

All the best.
Reply With Quote
  #9  
Old 05-15-2020, 01:00 PM
Logit Logit is offline Add Row to Weekly Schedule Planner1 Windows 10 Add Row to Weekly Schedule Planner1 Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

If you can state your needs specifically, what row / field etc you are wanting enlarged ... and other needs I can assist you.

Excel itself is not difficult to learn. And I do understand how busy your workday is.

Programming in VBA is another thing altogether.

But ... what you are saying you require should not require VBA programming. Just a few adjustments to the current workbook (Daily Planner).
Reply With Quote
  #10  
Old 05-16-2020, 12:00 PM
Justin Justin is offline Add Row to Weekly Schedule Planner1 Windows 7 64bit Add Row to Weekly Schedule Planner1 Office 2016
Novice
Add Row to Weekly Schedule Planner1
 
Join Date: May 2020
Posts: 9
Justin is on a distinguished road
Default

I want a space to enter a list of things to do which I can update regularly, perhaps up to 20 things. I like the idea of the different box types for different categories of tasks, which I could custom title myself. Id' like to be able to add events into the daily boxes, with enough space to add brief notes (so the boxes would need to expand accordingly. I'd also like the option to auto set repeat events over days or weeks or months. I'd like to have different coloured text for different types of events, meetings, deadlines, visits, etc. I'd like to be able to add daily events up to 3 or 4 months in advance.

These are the general features I'm looking for in a program. But I'd rather not have to build the program myself.

I appreciate your offer to aid me, but I'm not convinced the Excel Planner is a suitable tool for my needs.

Many thanks.
Reply With Quote
  #11  
Old 05-16-2020, 02:54 PM
Logit Logit is offline Add Row to Weekly Schedule Planner1 Windows 10 Add Row to Weekly Schedule Planner1 Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

Yes, you are correct. Without a lot of changes, the existing workbook layout will not work
for your needs.

You'll need to hire a programmer to create the product you envision or settle for something generic from the internet that is free.
Reply With Quote
  #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: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
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
Reply

Thread Tools
Display Modes


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:35 PM.


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