vlookup maybe

[kms]

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!

 

[Shairal]

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.

 

[Jacob Skaria]

Please clarify

You have mentioned that ColF contains either "posted" or "not
posted".....and you need all "posted" items entered into Sheet1 Column A
without any spaces...

You have not specified which column from Worksheet2 needs to be populated to
Sheet1 ColA