floppygoat
New Member
- Joined
- Jun 2, 2014
- Messages
- 20
Hi Guys,
I have been searching tirelessly for a clear way to create a code which I can apply to my current worksheet which will AUTOMATICALLY create, or delete, a new row once a previous row is filled with new information, or cleared of existing information.
This is necessary because I have a worksheet which serves as a meeting agenda with several topical "sections" of information e.g. "Change Orders," "Revisions," "Requests for Information," "Safety," etc. As you can imagine, the information, delineated as individual line items, associated with each section is bound to change from agenda to agenda. Therefore, to accommodate this "dynamic" range of information, it is necessary to add or delete the appropriate numbers of rows per section per week. This not only gets repetitious, but this worksheet is intended for use among my colleagues and I honestly cannot expect them to know how to add and delete rows manually.
I capitalized automatically above because I do not want to manually run a macro. Instead, I want the code to automatically recognize the changes and make the appropriate adjustment.
As it stands, the sections are not tables but cant be converted to tables if necessary.
The .xlsx anf .pdf files can be download here for reference: https://onedrive.live.com/redir?res...40&authkey=!AA6q0u6JZTKpzhU&ithint=folder,pdf
Thanks for your help,
TW
I have been searching tirelessly for a clear way to create a code which I can apply to my current worksheet which will AUTOMATICALLY create, or delete, a new row once a previous row is filled with new information, or cleared of existing information.
This is necessary because I have a worksheet which serves as a meeting agenda with several topical "sections" of information e.g. "Change Orders," "Revisions," "Requests for Information," "Safety," etc. As you can imagine, the information, delineated as individual line items, associated with each section is bound to change from agenda to agenda. Therefore, to accommodate this "dynamic" range of information, it is necessary to add or delete the appropriate numbers of rows per section per week. This not only gets repetitious, but this worksheet is intended for use among my colleagues and I honestly cannot expect them to know how to add and delete rows manually.
I capitalized automatically above because I do not want to manually run a macro. Instead, I want the code to automatically recognize the changes and make the appropriate adjustment.
As it stands, the sections are not tables but cant be converted to tables if necessary.
The .xlsx anf .pdf files can be download here for reference: https://onedrive.live.com/redir?res...40&authkey=!AA6q0u6JZTKpzhU&ithint=folder,pdf
Thanks for your help,
TW
