Dear Members
I have a sp sheet that fetches data from the web using SMF functions. To avoid refreshing often , I wish to store some data and refresh once in 3 months or so
To this end, I wish to automate some basic tasks and hence this request
what do I have
----------------------
1. I have a list of tickers on cells A2 -> A 50 on Sheet titled "list"
2. I have a second sheet called "financial statement data" where the SMF functions are in place and I have something like a financial statement
what do I wish to automate using XL VBA
-----------------------------------------------------
1. go to cell A2 on sheet "list"
2. copy contents
3. then go to sheet "financial statement data"
4. value copy data in clipboard (ie which was taken from A2.list) to cell B2 of sheet "financial statement data"
5. this will refresh sheet "financial statement data"
6. then copy the entire sheet "financial statement data"
7. then create a fresh / new sheet after sheet "financial statement data"
8. Value paste clipboard to new sheet
9. Paste format to new sheet (so that the new sheet will have values and formats, but no formula)
10. Rename new sheet to value on cell B2 of new sheet
11. skip 1 or add one to a variable to move to cell A3 on sheet "list"
12. loop steps 1 to 11 above untill you reach last value on sheet "list" column A
sample sp sheet uploaded here http://bit.ly/Xvy0VR
thanks in advance for any help on this
best regards
Subu
I have a sp sheet that fetches data from the web using SMF functions. To avoid refreshing often , I wish to store some data and refresh once in 3 months or so
To this end, I wish to automate some basic tasks and hence this request
what do I have
----------------------
1. I have a list of tickers on cells A2 -> A 50 on Sheet titled "list"
2. I have a second sheet called "financial statement data" where the SMF functions are in place and I have something like a financial statement
what do I wish to automate using XL VBA
-----------------------------------------------------
1. go to cell A2 on sheet "list"
2. copy contents
3. then go to sheet "financial statement data"
4. value copy data in clipboard (ie which was taken from A2.list) to cell B2 of sheet "financial statement data"
5. this will refresh sheet "financial statement data"
6. then copy the entire sheet "financial statement data"
7. then create a fresh / new sheet after sheet "financial statement data"
8. Value paste clipboard to new sheet
9. Paste format to new sheet (so that the new sheet will have values and formats, but no formula)
10. Rename new sheet to value on cell B2 of new sheet
11. skip 1 or add one to a variable to move to cell A3 on sheet "list"
12. loop steps 1 to 11 above untill you reach last value on sheet "list" column A
sample sp sheet uploaded here http://bit.ly/Xvy0VR
thanks in advance for any help on this
best regards
Subu