Copy and add data bsed on two different values-Name and subject

**mollybop** · 08-15-2018, 01:46 AM

Hi

I have an attendance workbook with sheets for each term, organized by student and subject and Im hoping to summarize the information on a master sheet at the end.

I think maybe its a simple array? But Im not sure, I would like the "Fp076 Master Attendance" to extract and sum all the absences, late, present from each term (T1, T2, T3, T4, T6).

Please help!

Thanks

**Winon** · 08-15-2018, 03:12 AM

Hello mollybop,

Please see if the attached sample Workbook is what you wanted, Unfortunately there are far too many formulas and reformatting to show it to you in this post.

Regards.

**mollybop** · 08-15-2018, 04:49 AM

THANK YOU! works great!

**Winon** · 08-15-2018, 05:51 AM

Hi mollybop,

Thank you for the reply and the Rep tap.

You are welcome, glad I could help.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Thanks.

Copy and add data bsed on two different values-Name and subject

LinkBack

Thread Tools

Rate This Thread

Display

Copy and add data bsed on two different values-Name and subject

Re: Copy and add data bsed on two different values-Name and subject

Re: Copy and add data bsed on two different values-Name and subject

Re: Copy and add data bsed on two different values-Name and subject

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Extracting data from one sheet to another bsed on criteria

[SOLVED] Honor roll calculation - add subject grades based on subject list + ignore some subjects

[SOLVED] Help comparing two files by subject+Date, subject+DatePlus1, Subject+DateMinus1

Server Downtime bsed in an 8hr period

[SOLVED] Cell Values in Subject Line

VBA / Macro help needed to auto update the Axis bsed on the cell value in Gantt Chart

Copy rows subject to several cell values

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions