Hi All,

Need help in build a macro to do the following:

Current scenario:

1) Transaction ID is available in a excel format.
2) Need to validate the transaction ID by entering the same into a internal website (since the website has data to all other process, cant get direct access to the server for the next 3 months), where it shows if the transaction is valid and what is the amount, customer details done on that transaction.
3) The Amount and Customer details needs to captured into a notepad.

This entire exercise is being done manually now. Would like to know if the same can be run by a macro.

Thanks in advance ...

Hemanth