jackkim1997
New Member
- Joined
- Jun 22, 2018
- Messages
- 1
Hi, this is my first time here!
Currently my excel sheet has numbers that are static and I have to go on this program that holds data and look up each person and manually type in the values associated with each person on the excel sheet. Since those values change every day, I am looking for a way to automate it so when i click refresh all -- lets say in two weeks -- the values for each person is updated according to what it says on the program (installed in my computer)
How would I go about doing that? I was told that I need to write my own macro using VBA but I do not really know where to start or how to even go about this. I don't even know what type of database of source my data is. It's just a in-house program installed on the desktop where if you type in a person there are a couple numbers unique to that person.
Please help! Thank you so much.
Currently my excel sheet has numbers that are static and I have to go on this program that holds data and look up each person and manually type in the values associated with each person on the excel sheet. Since those values change every day, I am looking for a way to automate it so when i click refresh all -- lets say in two weeks -- the values for each person is updated according to what it says on the program (installed in my computer)
How would I go about doing that? I was told that I need to write my own macro using VBA but I do not really know where to start or how to even go about this. I don't even know what type of database of source my data is. It's just a in-house program installed on the desktop where if you type in a person there are a couple numbers unique to that person.
Please help! Thank you so much.