Hello,
I couldn't include all data due to privacy issues, However my attached file explains the basics. So on Sheet2 there is a list of data, and Sheet 1 has a validation list to select from the list. Once selected the value gets put below the list (A3: and so on depending on data from Bloomberg lookup). I have formulas across the rows and filled down(B:C). However certain items from the list sometimes put in 300 full rows, instead of having my formulas copied down to 300, is there a indirect or addition I can make to my formulas (in B2 and C2) to have them fill to appropriate length from column A
Thanks
Bookmarks