Hi great forum!
Hope all of you have a nice day,
Im trying to figure out already for few days any possibility to make easier my workload in excel and looking for advices ( for sure im not first who is thinking of it)
The situation:
Working as a reseller and im building PCs/servers in configurator which it gives me raw lines with all components inside ( part number, part description, qty and price)
To send it to end customer im writing all the time a nice looking cover letter in excel and after saving as pdf. Until now i copy all the components manually and just adjusting fonts,colors and so on.
Now question:
Its any way that i can have a predefined version of my cover letter (standard words/dates/currency/background) already in excel stocked and all the time when im opening a raw excel with config just to press a button and it will be designed and filled in cover letter description?
I know that i could work on this with macro, but how to have already predefined format of my cover letter?
Any help is very appreciated.
P.S. before creating this topic i read others but did not found solution close to my idea.
P.S2. excel level around intermediate so might now know all features, just need few kicks where to dig.
Again,
Thank you
Bookmarks