New Excel Worksheet

[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

 

[chiph]

You might try asking in the VBA forum. This forum is for Visual Basic 5 & 6 programming.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first