Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-06-2021, 04:39 AM
kyotokisses kyotokisses is offline Adding extra row / multiple rows using prompt Windows 10 Adding extra row / multiple rows using prompt Office 2010
Novice
Adding extra row / multiple rows using prompt
 
Join Date: Apr 2020
Posts: 11
kyotokisses is on a distinguished road
Default Adding extra row / multiple rows using prompt

Hi all, sorry if this has been asked before.

I'm currently working on a document for our tenants and because the tenants' leases can range from 1 to 5 (or more years), and we would like to create a form and lock it to minimise human errors from modifying the original template, I'm looking for a way to insert additional rows for the rent table, either by a prompt asking how many years of lease or whether additional rows are required before moving on to the next field. Please let me know if there are any other options which may work as this was the only one I managed to think of.

1.PNG

Briefly, all the fields (including the year) will have to be editable. Appreciate any help on this!

Edit: to add, this is nested within a full table containing other information, but it can be split from the main table if necessary to make it easier.
Reply With Quote
  #2  
Old 01-06-2021, 04:42 AM
macropod's Avatar
macropod macropod is offline Adding extra row / multiple rows using prompt Windows 10 Adding extra row / multiple rows using prompt Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,726
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

Adding a new row to a table in a document with formfields:
https://www.msofficeforums.com/word-...html#post38312

Adding a new row to a table in a document with content controls:
https://www.msofficeforums.com/word-...html#post87989
https://www.msofficeforums.com/word-...html#post38461
https://www.msofficeforums.com/word-...tml#post145675
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 01-06-2021, 10:18 AM
eduzs eduzs is offline Adding extra row / multiple rows using prompt Windows 10 Adding extra row / multiple rows using prompt Office 2019
Competent Performer
 
Join Date: May 2017
Posts: 237
eduzs is on a distinguished road
Default

If the number of years is limited, it may be simpler to leave the master document with all possible lines and exclude those that are not going to be used.
__________________
Backup your original file before doing any modification.
Reply With Quote
  #4  
Old 01-06-2021, 01:26 PM
macropod's Avatar
macropod macropod is offline Adding extra row / multiple rows using prompt Windows 10 Adding extra row / multiple rows using prompt Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,726
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

But then the user would still need to delete the unused rows to obtain a professional-looking result. In a document with protection, a macro would still be needed for that.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding an extra field/column to an outlook calendar entry. Option is greyed out asearle Outlook 0 05-01-2020 12:42 AM
Adding extra row / multiple rows using prompt Somehow getting extra blank rows with borders kevinbradley57 Excel Programming 3 09-19-2018 01:01 PM
Adding extra row / multiple rows using prompt Copy Multiple Rows to new workbook when multiple criteria is met. flds Excel Programming 5 09-30-2014 09:58 AM
Adding extra row / multiple rows using prompt Adding Rows to a Table SuzeG Word VBA 8 01-02-2014 08:05 AM
Autofit adding extra lines John_G Excel 0 11-20-2012 08:19 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 08:20 AM.


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