athbarbara
03-14-2011, 04:23 PM
Hello!
I am really new to the use of VBA in EXCel and I am trying two days to Figure something out. I have several worksheets with data about stocks and I have created in Sheet1 a table with their names and Dates. I want to put under a date the return of each stock using VlookUp in a macro, but everything I have tried is pointless....:banghead::banghead: How can I make the VLookUP function to move each time one cell down and get the information for the stock from its worksheet..?:dunno
Can anyone help me please??:help:help:help:help:help:help
I am really new to the use of VBA in EXCel and I am trying two days to Figure something out. I have several worksheets with data about stocks and I have created in Sheet1 a table with their names and Dates. I want to put under a date the return of each stock using VlookUp in a macro, but everything I have tried is pointless....:banghead::banghead: How can I make the VLookUP function to move each time one cell down and get the information for the stock from its worksheet..?:dunno
Can anyone help me please??:help:help:help:help:help:help