Making a list

  • Thread starter Thread starter scottymelloty
  • Start date Start date
S

scottymelloty

Thanks for the reply, this does work but is not ideal for what i want
the data in column two is updating constantly linked to a database so
dont really want to do anything with the original data , i just want
new sheet to update automatically with anyone who goes under zero.

Example

Sheet 1
Column A Column B(Data constantly updating)
AAA 354
BBB -20
CCC 100
DDD -90
EEE 5000
FFF 176

Sheet 2
I want to come up with a list of all the names in column A Sheet 1
that have gone under zero but i want them altogether with no gaps i
between on the new sheet.

Thanks

By the way if you have 10 rows and a gap inbetween each row is there
function that will just list the rows with data in, i could get it t
work that way, thanks agai
 
In sheet2

In D1 Type Sheet1 column B's heading eg. Figure
In D2 type <0

Then goto Data>Filter>Advanced Filter

Select Copy to Another Location

In the list range Select the data in sheet1, eg Sheet1!$A$1:$B$50
In criteria range $D$1:$D$2
In copy to $A$1:$B$1

This should copy the list as required.

Let me know if this helped
 
Back
Top