Making automated invoice filling system with Excel.

**HenerH** · 11-05-2013, 04:07 PM

Hello.

I'm turning to this forum with a big problem. I'm new around here and I hope that I will get some useful advice here.
I have a problem with a bill template in Excel, where specific cells are filled automatically (information could be taken from another Excel file or access database). I found different solutions on Google how to import whole access database or how to import a column of cells, but I want to import information cell by cell automatically.
How is it possible to do such a thing in Excel? Do I have to use the macros?
I want to create a system of saving large amount of bills to PDF. If you don't have a solution, maybe you have an another good idea which program should I use?

Thank you in advance,

Hener.

**HenerH** · 11-05-2013, 04:47 PM

Please. A little help wold be nice.

**HenerH** · 11-17-2013, 06:10 PM

Im quite noob with google, i think. I just needed vlookup function.

But there is another problem now. Vlookup function doesnt work in XML map. Is there any similar way to do it in XML map? Please help.