Loud Thinking:
You shall type/ select the following at desired cell
1. Name of the source data file with complete path
2. Desired Metastock format (You know in advance the type of Source data format)
3. Name of the final report file with complete path
Necessity of entering the path can be avoided, if you keep all the files in same folder.
On entering the above details the system would start fetching the details from source file and rearrange the same in Excel in 7 or 8 columns.
You want the above process to be repeated until you stop it. Understand you want to go on adding further rows in the existing file.
In the Mat7 example, the data is captured daily. In the Mat8 example the data is for the same date- different transactions. Other online software example, the data is on weekly basis which is producing the graph. Please advise, how you want the graphs to be shown as the data would need to be rearranged accordingly
I am proficient in Excel Macro, Pivot Table/charts with slicer, dashboard, functions and formulas.
About Myself
Good Day!. Let me introduce myself for building your confidence in me.
Worked at Sr. position with experience of marketing, Service, Production and IT
Excel Expert Group Member
Access Expert Group Member
Worked on Macro, VB, Pivot, User Form
Proficiency in Office tools ,SAP, AutoCAD, 3DMax, Coral,
Qualification- Mechanical Engineer
Available on Skype
Some Projects:
Developed complete ERP system for Marketing in DB4 (earlier to Access)
No space