plozgivemehelp
New Member
- Joined
- Jul 26, 2019
- Messages
- 1
Hi all,
So basically I am trying to create a standardized tool that I can give to customers, and it will return graphs and values for a number of metrics. I want the sheet to have a button that says something along the lines of "Add data here" and they can add their data from another workbook with a standard format. Then, my other macros can do the necessary calculations and create the proper graphs.
I have never worked with VBA to import data from another sheet, so I am primarily inquiring if this is possible, and if it is how would I go about implementing it so that someone external could easily import their data and get back the concise analysis. Thank you!
So basically I am trying to create a standardized tool that I can give to customers, and it will return graphs and values for a number of metrics. I want the sheet to have a button that says something along the lines of "Add data here" and they can add their data from another workbook with a standard format. Then, my other macros can do the necessary calculations and create the proper graphs.
I have never worked with VBA to import data from another sheet, so I am primarily inquiring if this is possible, and if it is how would I go about implementing it so that someone external could easily import their data and get back the concise analysis. Thank you!
