yusra I use Value Line which comes in PDF form. Now I am going to assume BB is Bloomberg and you are using the Terminal option. Now VBA is powerful, but it does have it limits. But let me try and expand on what you want. You would like to bring up an excel workbook with a program that would capture data off your computer screen and transfer what you are looking at onto an excel worksheet. If I am even a little bit close let us know.