Hi sheet 1 to sheet 4 are identical,
They have live data from stocks that is auto updated every 30 seconds
Each sheet uses rows 2 to 20
column A = Stock name
column C = total amount sold in pounds
column O = price stock last sold in pound
column P = formula =(C2/O2) which gives answer of units of stock sold
Everytime 50 stocks are sold, is it possible that data from column A,C,O,P can auto copy to 1st available row on Sheet5
Example
A7= apples
C7=£100
O7=£2
P7= 50
1st avaialbe row on sheet 5 would read
A1 =apples
B1 =£100
C1 = £2
D1 = 50
Hope someone can help.
They have live data from stocks that is auto updated every 30 seconds
Each sheet uses rows 2 to 20
column A = Stock name
column C = total amount sold in pounds
column O = price stock last sold in pound
column P = formula =(C2/O2) which gives answer of units of stock sold
Everytime 50 stocks are sold, is it possible that data from column A,C,O,P can auto copy to 1st available row on Sheet5
Example
A7= apples
C7=£100
O7=£2
P7= 50
1st avaialbe row on sheet 5 would read
A1 =apples
B1 =£100
C1 = £2
D1 = 50
Hope someone can help.