Hi
I have created an Invoice template as attached. Now, every time I create a new Invoice with this template and click SAVE, I want some of the data from this Invoice (Customer Name, Inv Date and Due Date) to go to the next work sheet called Due Date and update itself automatically in sequential order.
I would like to know if its possible to do so in excel? If yes, can someone please guide me on how to do it?
Thanks
Dear Saj : As per your file i modify / addition in your structure.
Yellow filed select or enter.
In "B3" & in item code use Data Validation.
In column "C" / "E" using index match formula & column "F" sum formula.
you need copy from "A2" to "F27" Item code line of item 14.
& paste from "A29" (After one line of end of every inv)
In due date sheet : same index match formula using.
For more details please refer attach file.
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".
Thanks AVK! I am a newbie to excel, therefore will have to spend some time to understand the formulas properly. Will update on the thread. Thanks again!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks