VBA Codes with every 5 minutes interval & copy paste data from other work sheet

17255pp

New Member
Joined
Mar 5, 2022
Messages
1
Office Version
  1. 2010
Platform
  1. Windows
hi if anyone can help me with VBA Codes myself into stock market

i am having three work-sheets, name of sheets as follows

sheet-a). Sheet1
sheet-b). CALL OPTION
sheet-c). PUT OPTION

need VBA Codes

with every 5 minutes interval or jump need to paste below mentioned data from (B1:B72) of Sheet1

to sheet CALL OPTION cell number "F4" &
to sheet PUT OPTION cell number "F4"


ONLY For Your Knowledge,
Sheet1 column-B numbers from 900 onwards is TIME Indication for my other stock market worksheet calculation

900 means 9:00AM, 905 means 9:05AM, 950 means 9:50AM, 955 means 9:55AM AND SO ON with FIVE MINUTE JUMP

After every FIVE MINUTE myself wants 900, 905, 910 & so on these figures to reflect on sheet CALL OPTION & sheet PUT OPTION cell number "F4" only.

Thank You



900​
905​
910​
915​
920​
925​
930​
935​
940​
945​
950​
955​
1000​
1005​
1010​
1015​
1020​
1025​
1030​
1035​
1040​
1045​
1050​
1055​
1100​
1105​
1110​
1115​
1120​
1125​
1130​
1135​
1140​
1145​
1150​
1155​
1200​
1205​
1210​
1215​
1220​
1225​
1230​
1235​
1240​
1245​
1250​
1255​
1300​
1305​
1310​
1315​
1320​
1325​
1330​
1335​
1340​
1345​
1350​
1355​
1400​
1405​
1410​
1415​
1420​
1425​
1430​
1435​
1440​
1445​
1450​
1455​
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Forum statistics

Threads
1,175,457
Messages
5,897,531
Members
434,660
Latest member
Stoyf

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top