ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Modifying a database (https://www.excelbanter.com/excel-discussion-misc-queries/88398-modifying-database.html)

Oldjay

Modifying a database
 
I have a list named "Database" of church members on a sheet named "Records"
I export them to a sheet named "Contributions" This sheet has cols for each
of the weeks in the year. At the end I have a col "BN" that adds all the
contributions for the year. I then export this data back to the "Records"
sheet. Every thing works great until I add another member. This displaces all
the contributions below the new member.
Is there any way to correct this problem without adding all the weeks to the
database?
oldjay


All times are GMT +1. The time now is 08:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com