Ioanna has attended:
Excel VBA Intro Intermediate course
Graphs and Storing Input Data and Outputs
I would please like to know more about:
(1) creating charts
(2) ways of storing input and output data separately when i'm using an excel workbook as a calculation tool. the aim of this would be to keep the size of the tool small and to keep a record of input and output data for future references. also, could these be automatically stored into an access database? is this the best way to store input and output data after they have been used/produced?
Thank you!
RE: Graphs and Storing Input Data and Outputs
Hi Ioanna,
Thank you for your question and welcome to the forum.
Please find some chart code attached to this email which will help you.
I will pass the second request to a colleague of mine who will be in a better position to assist you.
Regards
Simon
Attached files...
Outlook word and chart code.docRE: Graphs and Storing Input Data and Outputs
Hello Simon,
Thank you very much for such a quick and helpful response. I'll have a go!
Regards,
Ioanna
RE: Graphs and Storing Input Data and Outputs
Hi Ioanna, thanks for your query. Automatically storing the input and output data in an Access database is certainly possibly but a bit involved. It not only involves coding the connection to the database but also attaching that to the Worksheet_Change event of the spreadsheet itself. We cover material of this nature on our Advanced Excel VBA course and a conversation about what you want to achieve would be a good idea then.
Hope this helps,
Anthony
