Hi everyone
This is my first post, I can use some help with a product drop list that fills invoice automatically on next sheet
I've attached a sample work book to give you a better Idea
Thanks for your help in advanced.
Hi everyone
This is my first post, I can use some help with a product drop list that fills invoice automatically on next sheet
I've attached a sample work book to give you a better Idea
Thanks for your help in advanced.
Last edited by Ray78; 03-21-2012 at 09:07 AM.
you can directly reference the cells, for example
=Calculator!D3
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
That's simple enough Thanks... This is related and more complicated for me! In my calculator I have over 16 columns! ordering,cutting and building Items etc. I need to eliminate some of these columns by consolidating.. choosing an item from drop down list in calculator sheet it would look for it in reference sheet and send it to invoice or a report sheet, one formula has to be for text and other numbers
tried this formula =IF(Calculator!$D$3=Reference!$D$2,Invoice!$B$3,"") in InvoiceB3 but I get nothing in it
I attached a new sample work book
Thanks in advanced
Give this a shot in invoice cell B3:
=VLOOKUP(Calculator!D3,Reference!B:D,3,0)
It worked great on the first row of the invoice but was getting #N/A on the rows underneath so I went back and used F4 key on the table array fixed that issue now I have to hide the second #N/A on the same rows on invoice, probably from not having any data from the calculator sheet I will try to use the ISNA function so I don't get #N/A when printing out invoices
Thanks for the help.
you could also use IFERROR
=IFERROR(VLOOKUP(Calculator!D3,Reference!B:D,3,0) ,"")
That's a lot shorter than this
=IF(ISNA(VLOOKUP(Calculator!F2,Reference!$D$2:$F$5,3,0)),"0",VLOOKUP(Calculator!F2,Reference!$D$2:$F$5,3,0))
This project is starting to come together very nice. sales quote, materials needed with cuts waste, cut sheets, job profit report and Invoicing
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks