I do data entry of my expenses in sheet "A" and for different locations. then I do total of different expense in report in sheet "B".
In Sheet "B" I have rows of "expense head" and column of "months" to show total of monthly expenses under different heads for different locations.
What i want is If I click cell containing total of expense then it should show all the details location wise and particular monthwise in separte PDF file.
Please find below sheet for example. If i click total 1488 then it should show all electricity expense entry of apr-12 for old stores in seprate PDF file.
I need your help. Thanks in advance.
Location Old Stores
Sr. Expense Apr-12
1 AMC
2 Cable
3 Electricity 1,488
4 Events
Bookmarks