• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

extracting data from multiple pages

H

holmespoint

New Member
i have a stock and option portfolio that i track in excel. I have used the following formula to extract Option symbols from a data sheet into a master sheet. I have a similiar formula that gets data from a different sheet. I have 9 sheets in total that i would like all the options to go in one column from all the sheets. how can i have one formula that will pull all the option symbols into one column in my master option sheet?

=IF(COUNTIF(kpt!W:W,"OPTION")<ROWS(kpt!$A$9:A9),"",INDEX(kpt!A:A,SMALL(IF(kpt!$W$9:$W$88="OPTION",ROW(kpt!$B$9:$B$88)),ROW(kpt!$B1))))
 
Hi:

Upload a sample workbook. I guess a VBA solution would be more suitable for you rather than formula. Using formulas for this will increase the size of your work book considerably. I am assuming that your data runs into tens of thousands of rows.

Thanks
 
You must log in or register to reply here.
Back
Top