Automatically insert rows in associated spread sheets
Closed
ManxEd
Posts
1
Registration date
Wednesday July 26, 2017
Status
Member
Last seen
July 26, 2017
-
Jul 26, 2017 at 02:58 PM
ManxEd - Jul 28, 2017 at 03:00 PM
ManxEd - Jul 28, 2017 at 03:00 PM
Related:
- Automatically insert rows in associated spread sheets
- Insert check mark in word - Guide
- Download automatically while roaming - Guide
- How to insert photo in word for resume - Guide
- Insert draft watermark in word on all pages - Guide
- Sheets right to left - Guide
1 response
stankirsolkar
Posts
6
Registration date
Friday July 28, 2017
Status
Member
Last seen
July 31, 2017
Jul 28, 2017 at 12:01 PM
Jul 28, 2017 at 12:01 PM
It's tough to help without looking at the data first.
Here are some suggestions based on what I understand:
Use Excel tables. It helps in automatically account for new data points.
Use drop down lists in column column of the subsidiary sheet. That ways, you can simply code it to pull data when you select the new name from the drop down. You can do this using lookup formulas.
Again, tough to help without looking at the data.
Here are some suggestions based on what I understand:
Use Excel tables. It helps in automatically account for new data points.
Use drop down lists in column column of the subsidiary sheet. That ways, you can simply code it to pull data when you select the new name from the drop down. You can do this using lookup formulas.
Again, tough to help without looking at the data.
Jul 28, 2017 at 03:00 PM
I have created a spreadsheet accounts packaged for use by small clubs and charities.
I have this on my GDrive and have amended the actual program to eliminate private material, so that it is a set of model accounts
This system works without any problems and I designed it to enable a treasurer who is not a book keeper to be able to produce proper accounts with very little problem.
Obviously the workbook starts, after a few lines, with a list of the club members.
This list is connected to 2 other members lists in the accounts spread sheet and 11 separate but connected spread sheets.
When a new member joins the club his name etc must be inserted on a new row, and to avoid any problem with data being wrongly related to a member, all the other sheets need a row to be inserted in exactly the same order as the first additional row.
It is vital that no mistakes are made.
If you wish, I could allow you to share the actual documents and user instructions in return for your email address
Kind regards
ManxEd