How to generate automatic report in Excel?

excelos

Active Member
Joined
Sep 25, 2011
Messages
329
Hello,

I have an XLS template with text and some fields that I want to update them automatically.

Can you tell me please how do click a button and do stuff like:

1) count the number of lines in a sheet apart from the header
2) count the number of lines in a sheet that the field under a specific header has value1 or value2
3) calculate the percentage of the above to the total number of lines apart from the header

Also, can you tell me the macro that will create this "Some text here [value from 1)] and some other text here [value from 2)] plus [value from 3)]

Thanks!
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

excelos

Active Member
Joined
Sep 25, 2011
Messages
329
Ideally, I would like to make use of Excel Functions, e.g. use the COUNTIF, INDEX/MATCH etc to find the numbers I need.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,542
Messages
5,529,453
Members
409,878
Latest member
DDhol
Top