COMPLETE EXCEL STEPS TO CONNECT YOUR DATA?

Hello,

I would like to know if there are links on how to connect data in making invoice,summary,saving it to another workbook and doesn't slow your excel using VBA and without VBA. Example.How to make userform that transfer it to a data worksheet then make nice looking summary report.Best example for this is issue invoice with look up outstanding balance then less inventory. Better if the report have alarms like change color,pop up or message box that inform your needs.
I am looking on how to make one.how to connect them all together. It would be nicer with video.
Thank you and hope to get answers.

Thanks

Thanks for the Link. Was looking for more but I found all i need to know in free training Video here. Lesson learn Check,Search,Study,Examine,Reflect then question.
Best Site here!

Nick's picture

take a look at