vlookup maybe

  • Thread starter Thread starter kms
  • Start date Start date
K

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!
 
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.
 
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
 
Back
Top