I have several sheets in a workbook, the first one is called "daily", the others are called "stock1", "stock2", "stock3",...., "stock20".
In the sheet called "daily" I paste everyday information abouth the sheets "stock1", "stock2", etc. This is the information I copy in the "daily" sheet
SYMBOL CLOSE OPEN HIGH LOW VOLUME
Aapl.* 7,689.00 7,836.03 7,790.00 0 4
Abt.* 783.53 783.53 778.35 0 0
Ac.* 61.05 61.09 61.4 61 1,118
Alfa.a 184.02 181.54 185.52 181.55 1,564
Alsea.* 18.3 17.73 18.3 17.73 538
Then I want to copy the information of each stock to it's sheet to have the historical information so I can make a chart. The information that I copy to each sheet looks like the following:
Date Open High Low Close Volume
03/10/2011 380.37 382.64 373.17 374.60 23876300
04/10/2011 374.57 381.80 354.24 372.50 44035800
05/10/2011 367.86 379.82 360.30 378.25 28075700
06/10/2011 373.33 384.78 371.80 377.37 29008700
07/10/2011 375.78 377.74 368.49 369.80 19123500
10/10/2011 379.09 388.81 378.21 388.81 15769200
11/10/2011 392.57 403.18 391.50 400.29 21609800
12/10/2011 407.34 409.25 400.14 402.19 22206600
The information in the "daily" sheet is replaced everyday with the information of the sesion of that day; so I want that once I paste the information in the "daily" sheet automatically updates the other sheets. Once the update is done to be able to put the information of other day in the "daily" sheet and updates the other sheets, like the example I put above these lines
In the sheet called "daily" I paste everyday information abouth the sheets "stock1", "stock2", etc. This is the information I copy in the "daily" sheet
SYMBOL CLOSE OPEN HIGH LOW VOLUME
Aapl.* 7,689.00 7,836.03 7,790.00 0 4
Abt.* 783.53 783.53 778.35 0 0
Ac.* 61.05 61.09 61.4 61 1,118
Alfa.a 184.02 181.54 185.52 181.55 1,564
Alsea.* 18.3 17.73 18.3 17.73 538
Then I want to copy the information of each stock to it's sheet to have the historical information so I can make a chart. The information that I copy to each sheet looks like the following:
Date Open High Low Close Volume
03/10/2011 380.37 382.64 373.17 374.60 23876300
04/10/2011 374.57 381.80 354.24 372.50 44035800
05/10/2011 367.86 379.82 360.30 378.25 28075700
06/10/2011 373.33 384.78 371.80 377.37 29008700
07/10/2011 375.78 377.74 368.49 369.80 19123500
10/10/2011 379.09 388.81 378.21 388.81 15769200
11/10/2011 392.57 403.18 391.50 400.29 21609800
12/10/2011 407.34 409.25 400.14 402.19 22206600
The information in the "daily" sheet is replaced everyday with the information of the sesion of that day; so I want that once I paste the information in the "daily" sheet automatically updates the other sheets. Once the update is done to be able to put the information of other day in the "daily" sheet and updates the other sheets, like the example I put above these lines
