sujittalukde
08-01-2007, 03:42 AM
I am copying data from website to a excel WB named "Inputdata" for stocks say stock code "SAIL". Data are related to "Quarterly Income statement", "Annual Income Statement", and "Annual Balance sheet". On completion of importing the data I want to save those data in a master WB say "Masterdata" with a pre formatted manner. nad say the masterdata WB will be kept at D:\Results.
When the user will change the stock code at the inputdata.xls at a cell A1 then the data should be transferred to the masterdata.xls with new sheets to be added at the masterdata. Suppose user has changed the stock code from "SAIL" to "TISCO", then the data of TICO shall be stored to the masterdata.xls as a new sheet. and so on.
How this can be achieved?
Attaching the workbooks for ready reference and testing.
When the user will change the stock code at the inputdata.xls at a cell A1 then the data should be transferred to the masterdata.xls with new sheets to be added at the masterdata. Suppose user has changed the stock code from "SAIL" to "TISCO", then the data of TICO shall be stored to the masterdata.xls as a new sheet. and so on.
How this can be achieved?
Attaching the workbooks for ready reference and testing.