search a workbook, regardless of No of sheets and then run a comparision b

[Aelemar]

I'm wondering if it's possible to create a macro that will search a workbook, regardless of how many worksheet there are and run a comparision between the active cell entry and a fixed column. I'm trying to create a document for were I work to allow once you enter a number it compares it to a column and if it is greater then equal to that number it runs a cut and paste function to the bottom of the workbook.

Basically we have a column of QTY Required (which is being used as the comparison column), I'm trying to use the active cell function so whenever data is entered it will run the macro however i quickly realized that you need a second column to filter results so that the macro doesn't take the data you don't want it to take hence the reason why i want to add a second comparision between between another column which would be QTY completed and compare it to QTY required and if both the active cell and QTY required fill the set conditions it runs the function cut and paste. Hope it isn't too confusing... I'll try and post some of which I'm working on later if that helps but it's been quite a bit of time since i've used VB so i'm really rusty.

[Ikaabod]

This will search each worksheet in a specified column

Please Login or Register  to view this content.