I have a club workbook with 150 member Worksheets that need to be populated from the members list.
First Member is starting with A2
Second A3 etc...
The columns of the list are titled in Row 1
(A) Entity (B) Last Name (C) First Name (D) Number (E) D.o.B
Each Worksheet is titled "Entity 1" through to "Entity 150"
The corresponding Cells on all Worksheets are
Last Name (B3) First Name (D3) Number (B4) D.o.B (B5)
There is no Cell for Entity # as this is the reference for Sheet ID
The sheet will be updated with new members during the year so an "Update" button might/will be needed on the "Members List" Worksheet
This workbook is Locked and submitted as a Report at the end of each year and a new one started from 1 Jan, I am trying to make it as a template for subsequent Committee Members to make the data entry and general job a lot less time consuming and complicated.
Save the file as something else, and delete all of the data!
YOu really need a database, and pull reports as needed. If you need assistance designing or need help with the concepts, let us know. If you are going to learn VBA, you would learn how to build a DB just as fast!