Hi, I have a relatively simple question but it requires a bit of a description, so please bare with me. I have a trading spreadsheet programmed to generate "buy" and "sell" signals from price data that I import. So when I import price data into column "A", column B,C,D, etc, automatically calculate moving averages of different length (10,25,50 days, etc) for the price data. Then, based on the moving average data, I've programmed column "O" to return either "buy", "sell" or "blank". Column "P" returns the price associated with a buy (same row as signal in "O"), column "Q" returns the price associated with a "sell" (again same row as signal), and columns P and R return the dates of the buy and sell respectively. These signals span 1000s of cells and I need to be able to get that data into the next worksheet without the blanks. So I need a formula to basically say if "something" is in a cell in column "P" (for example), put that value in column A row 1 in the next worksheet, basically ignoring all the blank cells but collecting the data into a nice condensed column. I've been copying and pasting the data for now and then sorting it, and then deleting the extra cells, and then doing more calculations afterwards but I'm getting sick of this process and want to automate the process. Can anyone help me with this simple (hopefully) formula? Here's what a little of the spreadsheet looks like:
Sorry, I can't seem to get my image of my spreadsheet inserted. Perhaps my explanation is clear enough on its own. TIA.
Sorry, I can't seem to get my image of my spreadsheet inserted. Perhaps my explanation is clear enough on its own. TIA.
