Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

How to summerize data in Excel 2007

0

Hi,

I have created my all invoices in excel 2007 each on saperate sheet. Now I want to summerize invoce data in one sheet consisting Invoce No., Invoice Date and Party name from all invoices.

Can anyone help me in this regard?

Answer
Discuss

Discussion

It's possible, but you should do one of two thingsĀ 
Putting a sample file that has the summarize sheet and at least one sheet that has an invoice

Or giving us a good description of them that indicates the cells of every value that you want

And 1st one will be better
MRVMV (rep: 52) Jul 19, '16 at 7:58 am
Agree with MRVMV, this is an easy task, you just need to give more info.
don (rep: 1989) Jul 19, '16 at 9:51 am
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login