Dear Sir,
I have a problem, In one sheet (Master Sheet) I keep on append the daily data along with so many details (I have attached my file for Ref.) now I want to raise one invoice automatically in another sheet based on the master sheet data. In the file attached based on the BL no. The invoice should be raised taking into the sum of each column with the respect BL no.
Please Help me.
Regards,
Murali Krishna R
Where in the attached file is the said invoice, please?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Yes madam,
In the master Sheet there are header columns the same should be consolidated BL wise and should be kept in the invoice sheet.
If the same header rows are not reflected in invoice sheet please ignore, but major header columns will reflect in the invoice sheet.
Regards,
Murali
Any body can help me please in this problem i am facing,
I am guessing the the pivot table on sheet 3 is what is being referred to as the 'Invoice Sheet'. If so, what isn't the pivot table showing that you want the 'Invoice Sheet' to show? If not, it might be helpful if you could provide a small sample (manually typed) of what you want the 'Invoice Sheet' to show.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
what exactly are you are looking for ?
Hey Krishco
I think I have worked on something similar.
Could you please explain me in detail the things which you are looking for ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks