If cell value is greater than £0.00 then copy row to front sheet

[akderitend]

Hi

First post and not exactly brilliant with Excel

I am attempting to finalise a price list workbook and, in order to do so, need to be able to copy entire rows if particular cells have a greater value that £0.00

As you cann see in the attachment, the tab "item & price build up" consists of several drop downs and vlookups. If an item is selected, I want that entire row to be copied to a new tab (to be located at the front of the workbook)

Hopefully someone can help!

cheers

Andy

[bonny24tycoon]

Hi There,

I just amended the Item & Price build up column a little and build this for you.

Ensure you turn on Macros and run it. Pricing Database.xls

Hope this helps.




Thanks,

Bonny Tycoon


**If I was able to help please click the small star icon at the bottom left of my

post **

[akderitend]

Sorry, just noticed, can the macro be edited so that, if the "total" column > £0.00 it copies the row?

[bonny24tycoon]

Sorry, just noticed, can the macro be edited so that, if the "total" column > £0.00 it copies the row?

I have now amended the macro to look at the total column >0 to copy the row. Find attched Pricing Database.xls

If I was to add more rows to the "saint gobain" tab, will the macro update to suit?

Yes, it should. Let me know if it doesnt



Thanks,

Bonny Tycoon


**If I was able to help please click the small star icon at the bottom left of my post **

[akderitend]

Hi

Thank you for that, works exactly how I wanted it to.

If I was to add more rows to the "saint gobain" tab, will the macro update to suit?

cheers

[bonny24tycoon]

Sure, Let me amend this for you.



Thanks,

Bonny Tycoon


**If I was able to help please click the small star icon at the bottom left of my post **

[akderitend]

Bonny

Apologies

I have just finished updating the spreadsheet - can you put the macro into this one?

cheers

[bonny24tycoon]

Hi There,

No worries,

I have done this for you I have put the macro button on the Item & Price build up tab. Pricing Database.xls



Thanks,

Bonny Tycoon


**If I was able to help please click the small star icon at the bottom left of my post **

[bonny24tycoon]

Great,..


Can you mark this thread as solved or can a moderator do it?




Thanks,

Bonny Tycoon


**If I was able to help please click the small star icon at the bottom left of my post **

[akderitend]

thanks for your help