Equine Investor
Board Regular
- Joined
- Nov 20, 2002
- Messages
- 103
Hi,
I have a workbook Sheet1, which has stockmarket prices in column O.
Column A has the stock code.
This data is copied to Sheet2
Column A Sheet2 has the stock code
Column B has the stock price copied from Sheet1 column O.
What I'm trying to get, is if the price changes in Sheet1 column O, (for any stock), it is copied to Sheet2 in the next available column for that stock.
I currently have a macro that does the initial part:
I have a workbook Sheet1, which has stockmarket prices in column O.
Column A has the stock code.
This data is copied to Sheet2
Column A Sheet2 has the stock code
Column B has the stock price copied from Sheet1 column O.
What I'm trying to get, is if the price changes in Sheet1 column O, (for any stock), it is copied to Sheet2 in the next available column for that stock.
I currently have a macro that does the initial part:
Code:
Sub Macro1()
'
' Macro1 Macro
'
'
Range("A5:A45").Select
Selection.Copy
Sheets("Sheet2").Select
Range("A1").Select
ActiveSheet.Paste
Application.CutCopyMode = False
ActiveWorkbook.Save
Sheets("Sheet1").Select
Range("O5:O45").Select
Selection.Copy
Sheets("Sheet2").Select
Range("B1").Select
ActiveSheet.Paste
Application.CutCopyMode = False
ActiveWorkbook.Save
Range("C1").Select
End Sub
Last edited: