Excel help?

N

neroazzurro

Regular Member

Mar 11, 2015

343

26

• Nov 7, 2018

• #1

Hello,

I need help with creating excel template.
I need template for issuing invoice (not hard to make).
Other part I need template to calculate products on stock and give them name and serial number.
So on invoice I can only type name of product and it will get info from database (like serial number, price etc).
Is it possible in excel?

 

lacover

Junior Member

Oct 7, 2018

112

79

• Nov 13, 2018

• #2

I'm not an excel expert but I think it would just be easier to write a program in C#. In this way, you can have the job done and even save the data on excel files using the excel APIs.

 

donaldz

Newbie

Nov 29, 2016

3

0

• Nov 13, 2018

• #3

If you're open to a manual approach, I use waveapps. com/invoicing - (remove the space after "." before com) - it's free and a lot sleeker than excel

 

E

eletrico

Newbie

Jul 21, 2014

9

1

• Dec 9, 2018

• #4

Hi, yes is possible, you just need to have a sheet where you paste the data, ans with couple of formulas, and giving name to coluns it will catch what you want..

 

t2van

Banned - Constantly insulting other members

Feb 18, 2018

1,178

3,080

• Dec 9, 2018

• #5

You need two sheets.

One with your invoice template on. The other with the products. Then you use Lookup Function (loads of videos on it) to search the one sheet and populate the field and then use basic sum commands to work out totals etc. You can export the template as a PDF.