How do I consolidate data from multiple worksheets from the SAME workbook?

[Curzon88]

I want to combine multiple 'Total Sales' by category into one one master sheet within the same workbook.

[nick93]

Sorry if this isn't helpful but this is exactly what Excel's consolidate feature does. If you have a problem implementing it then post your worksheet.

[Curzon88]

I'm doing an assignment and it says this "A separate summary worksheet in each week's workbook will summarise and total the daily sales from each branch. The summary should automatically update if any of the branch is updated"

[easyexcelanswers]

You can link the values from other sheets to one sheet

So the totals would be displayed =Sheet1!G1

This would be the total from sheet1

[oeldere]

With this code.

Please Login or Register  to view this content.

And after that this code

Please Login or Register  to view this content.

And after that a pivot table.

[Curzon88]

The thing is, I'm not sure if that's what the lecturer wants.

[Curzon88]

Do I just copy and paste that into VBA?

[oeldere]

The thing is, I'm not sure if that's what the lecturer wants.

Why do you think we will know that, if you (as the starter of the topic) don't know waht should be done.

And yes this is VBA code.

[Curzon88]

Why do you think we will know that, if you (as the starter of the topic) don't know waht should be done.

The assignment is ******* weird. Apparently there's a way the lecturer want's it done only you have to interpret how it's done from instructions that for the life of me I don't understand. Technically speaking I know how to do it (Formulas, Functions etc.) I just can't understand how the lecturer want's it done. I'm seriously considering just posting the assignment online and offering to pay someone to do it.

[oeldere]

I just can't understand how the lecturer want's it done

The first thing I should do, is ask the lecturer.

Edit:

I translate lecturer and that is teacher, so that won't probably be of no help.

[Curzon88]

The first thing I should do, is ask the lecturer.

She's teaching three different classes at once. I'm lucky if I get 5 minutes per lesson with her. Plus because I'm in the advanced part of the class I should in her words "Be able to work out problems without asking for help." What should I do when I copy and paste the code into the VBA?

[oeldere]

Past the code in a module, like you did with module 1, 2 and 3.

After that run that code.

[sandy666]

Maybe PowerQuery and PivotTable?

(You didn't show how should the result look like)

[oeldere]

Why did you start a new treat on your same question?

This is against the forumrules.

5. Don't duplicate threads. If you have posted the question in one forum, do not post it again in another forum. You are duplicating efforts. If you feel the thread is in the wrong forum and needs to be moved to another forum, PM a mod / admin to do it for you.


It'd also be appreciated if you reply on the offered solutions.

[Curzon88]

You can link the values from other sheets to one sheet

So the totals would be displayed =Sheet1!G1

This would be the total from sheet1

Yeah, I just used your solution even though I'm pretty sure I'm not meant to do it this way. Oh well, the lecturer can choke on it.