I have a workbook that has 11 web querys on it and im trying to compile a list of stock symbols that will end up being itemized under a specific headers ie.(StockstoWatch, PremarketMovers, EarningsBeforeOpen) all in the same column on a master sheet. Im trying to figure out how to paste one column(each of varying size and location) from each sheet to column A on master sheet. I dont care if i have to create the header before or after pasting from each sheet but ill need everything i paste to get inserted at first row available then. Unless there is a way to have everything get pasted under an preexisting header that is already on the sheet.

This is what ive been working with but its copying entire row. I need to just copy whats in column C of the row where it finds the text then paste every stock with earnings before the open under its corresponding header on the master sheet.

Please Login or Register  to view this content.