Copy rows into existing sheet based on the value of a cell.

I am having some trouble developing a macro that will allow me to only copy rows to a new sheet that do not have a $0 value so anything that isn't 0. This copys to an existing sheet.

N AccountCcy Reg Type E BALANCE B BALANCE E (OVER) UNDER B
acct2 CHF NR 13,215,454.00 13,215,454.00 0.00
acct3 CHF NR 153,215.00 35,132,132.00 34,978,917.00
acct1 CZK NR 153,215.00 35,132,132.00 34,978,917.00
acct2 CZK NR 16,464,514.00 16,464,514.00 0.00
acct3 CZK NR 13,215,454.00 13,215,454.00 0.00
acct1 DKK NR 16,464,514.00 16,464,514.00 0.00
acct2 DKK NR 153,215.00 35,132,132.00 34,978,917.00
acct3 DKK NR 16,464,514.00 16,464,514.00 0.00
acct1 EUR NR 13,215,454.00 13,215,454.00 0.00


basically I would need only those with values in the E UNDER B column to be copied and pasted into an existing sheet called E Adjustments.

Originally Posted by Richard Buttrey

Have you attempted to use Data Filtering? Try capturing the code with the macro recorder then when you have that post back here since it will no doubt be possible to simplify it.

Please Login or Register  to view this content.