• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Select items from data list into invoice

S

smisar

New Member
I have attached a sheet which has around 395 rows of items and three columns.
When I am making a new invoice or quote, in other sheet, I want to just click the check box in column no 1, the checked items appear in my other invoice or quote sheet, with description, quantity and price...

I hope I am clear, please suggest simple solution to this...

regards

Sanjay Misar
 

Attachments

  • sample.xls
    52.5 KB · Views: 5
What you say you want to do is to Push the item you select into the Invoice
Excel doesn't Push data, it Pulls data
Typically you setup the Invoice
Then on each line you select an Item and it will pull the data for the other fields

If you use the Search Box at the Top Right of this page you will find that several examples of Invoices have already been used previously

eg: https://chandoo.org/wp/2014/03/19/free-invoice-template/

There are also several good references in the comments
 
You must log in or register to reply here.
Back
Top