Auto-populate data from 3 major worksheets to several sheets on a workbook

**CBarlow** · 10-12-2009, 02:38 PM

I have never really used VBA And I am currently have a huge work book that has 3 Main pages which are Tithes, Offering and Attendance. It also has 40 individual worksheets with Church member info. I need to create a macro which auto-populates a master worksheet from the individual user sheets in a shared workbook.

Sheet 1 one of the master sheets "Attendance".
Attendance sheet Will consist of Dates per Sunday services.
Column B 4-Oct Column C 11-Oct Column D 18-Oct Column E 25-Oct
Row Will Consist of Names Example
A2 Angel Haji
A3 Anthony
A4 Antoinette Tate
A5 Aryiah
A6 Ben Scott

Sheet 2 is the second Master sheet "Tithes"
With the Same Format as Attendance

and Sheet 3 Is the Third Master Sheet "Offering"
Again with the same format.

There will be an undetermined number of individual worksheets to accommodate new church members.

Each worksheet will be identical, using columns A-C with Cell A1 having the Church Member Name and row 2 having the headings:

Attendance, Tithes and Offering. Their Will also be information about the church member Below Such as Phone, Address, email, Married?, Children, Birthday, First Service and how did you hear about us?.

There will be a varying number of rows in each of the individual sheets Depending on if there is any extra info I need about the particular Member.

I would like the macro to run every time data is entered into one of the individual worksheets. If this is not then it would be ok to update every time the workbook is opened.

I would love if someone could help because now I am Just seem to be entering the information twice and it consumes so much time.

**shg** · 10-12-2009, 02:43 PM

Welcome to the forum.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

While you're doing that, I'll move this thread out of the Access forum to an Excel forum.

Thanks.