Prev: Sumproduct formula
Next: Conditional Formatting Pivottables
From: kms on 27 Apr 2010 14:50
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!
From: Shairal on 27 Apr 2010 15:10
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!
From: Jacob Skaria on 28 Apr 2010 01:52
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

--
Jacob (MVP - Excel)


"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!
 | 
Pages: 1
Prev: Sumproduct formula
Next: Conditional Formatting Pivottables