Hi
What is the best way to create individual bills for each one name?
And then how to print all of them at once, print only one or selected ones?
Each bill must have all info in its row, plus the list and sum of all expenses in n28:p40 plus the dates, liters and price of oil purchase, total purchased value, liters and value burned and liters and value left over.
instead of image plz attach your excel file it more clarity.
Click on "Go Advanced"
In next window click on "Manage Attachments"
Click on "Choose File" & select respectie file from folder
Click on "upload"
After complete "uploading file" click on "Close this window"
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Here is the file requested.
No ideas anyone?
I guess no one could understand what you are asking.
You need to provide us some of your exact desired result clearly showing the logic behind it.
I think he is looking for billing/invoice template, where he can print a single record or selected records of customers. I guess!!?
You got it!Originally Posted by qadeerume
Take a look at sheet 2.
Last edited by drgkt; 01-17-2017 at 01:02 AM.
Dear Drgkt, As per your file sheet2.
I have made changes (As per our think) with "Data Validation List" in "A3" cell & index match vlookup formula in gray cloro cells.
Please look file.
If you need any further modification or changes, revert back.
Dear Drgkt, As per your file sheet2.
I have made changes (As per our think) with "Data Validation List" in "A3" cell & index match vlookup formula in gray cloro cells.
Please look file.
If you need any further modification or changes, revert back.
1. Please save in excel for xp (2002 .xls) format
2. I want to be able to send individual bills to all*, or one or a few selected.
There must be a way not to do this 23 times!
No ideas about this at all ah?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks