(Win 7 Excel 2013) Hey Guys. I have raw data that has three rows (account numbers, tickers, and values) and I am trying to set up a macro that will paste the values from one sheet into another. But the raw data is ever changing (tickers change, accounts are added, ect) so the cells are not the same. Is there a way to search the row and correlate the account number and ticker so it is moved to the correct cell on the other sheet? And if the account is not found return an error or highlight it so i could add that account? Thanks in advance.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
VBA paste help
- Thread starter WRADVISOR
- Start date
Similar threads
- Solved
