Hi,
I have a template for stock price. How do you drag a range of cells in another workbook of a particular worksheet when i have selected a particular stock in the open workbook in a listbox?
I want to change the Open, High, Low, Close, Volume of the "Chosen Stock.xls" when I have selected a particular stock. The stock price data is in another workbook called "Hong Kong Blue Chip Stocks Data". How can I copy those data when I have selected say 0001.HK, then the list of stock price will update without copy and paste from the "Hong Kong Blue Chip Stocks Data"?
Thanks
Drag a range of data if a cell condition is met
-
-
-
Re: Drag a range of data if a cell condition is met
I need to get a clearer idea of what you want.
1. You want to be able to select from a list the available stocks e.g. 0001.HK, 0002.HK, 0003.HK
2. When you select the stock what data do you want pulled from sheet in Hong Kong Blue Chip Stocks Data(Test) and placed into the Chosen Stock workbook - if you select 0001.HK from the list what data in the sheet named 0001.HK do you want pasted into the Chosen Stock workbook - I know you want Open, High, Low, Close, Volume data but is it all the data in the sheet or only certain rows e.g. based on date rangeIt is easy to generate a form with a listbox containing all the stocks (essentially a list of the worksheet names in the Hong Kong Blue Chip Stocks Data(Test) workbook (except the summary sheet I assume)
Once the stock is selected from the listbox I just need to know what data is collected and placed into the Chosen Stock workbookPlease be very explicit in what you require and I will write the code for you
Regards
Anthony
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!