OK So Lets say i have two columns of data
column A has stock symbols and Column B has the price I paid or sold it for.
I am looking to write a Macro that would find all the matching symbols in column A- find the corresponding value on B and then paste it to another worksheet (To sum up the sum of buying/selling)
for example if I bought apple stock and paid 1,000 bucks one day and I sold it for 2,000 bucks another day, I want the macro to recognize..."Hey aapl was bought for 1,000 and sould for 2,000" profit is $1,000.
How would I write a macro that what allow me to
1. enter the symbol in a message/input box... (based on the symbols in the column would I dim a variable as a string?)
2. find the stock symbol in column A (each time it appears)
3. for each time it appears it sums the value in a different worksheet or column
Any Help is greatly Appreciated...
Bookmarks