If this is just a one-time thing, just filter on Posted items and
copy-and-paste the data you want into your new spreadsheet.

"kms" wrote:

worksheet 2 contains A1-H130. I need to pull data from column F11:F130 into
sheet 1. The cells in column f either contains "posted" or "not posted". I
need all "posted" items entered into sheet 1 column A without any spaces
between the rows in column A. What formula can i use to do this?

thanks!