Excel Question involving VBA

[MikeCitizens]

Hello all,

I have an excell spreadsheet that basically looks like this

118118 bank name -12345.00 12345.00
118119 bank name 12345.00 12345.00
118120 bank name 12345.00 -12345.00
118121 bank name 12345.00 12345.00
118122 bank name -12345.00 -12345.00

I need to create a macro that takes this spreadsheet and creates a new one only pulling the lines if one of the figures are negative. So the new spreadsheet would look like this

118118 bank name -12345.00 12345.00
118120 bank name 12345.00 -12345.00
118122 bank name -12345.00 -12345.00

Can this be done using a Macro? I am new at using VB so Im a little clueless on this one. Would it be easy just using a Excel formula?

Please anything that you can help me with would be appreciated.

Mike

 

[PHV]

Take a look at Advanced filter.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[MikeCitizens]

PH

thanks for the response. Im a little unsure how to use the advance filter. I assume I can have this built into a Macro. Thing is my users need to run this excel daily and get the above result and they are worse off in excel as I appear to be.

I have read another thread. thread707-934163 thats similar to my thread. But it involves entering values into the second sheet before running the filter. Is there another way to do this? And it looks like he has one condition where I have two, how do I reflect this?

Mike

 

[SkipVought]

Mike,

1. Your data ought to have Column Headings.

2. PHV's suggestion requires a Criteria that will reside in AT LEAST 2 cells -- the FIRST cell has the Column Heading, then SECOND cell has the Criteria Value.

So if your 2 columns containing negative values have these headings...
[tt]
Amount1 Amount2
[/tt]
then your criteria would be
[tt]
Amount1 Amount2
<0
<0
[/tt]
in SIX Cells

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}