cutting and moving a row based on a value in a cell

Hi there,

I'm a newcomer to the wonderful world of excel and am trying to use macros to automate otherwise tiresome labour. I've had some success using record macro to replicate my actions, but I now have some macros that I want to be a bit more generic that I'm having trouble with.

I have a worksheet that is split into 4 separate sections. The number of rows in each section will vary from day to day and week to week.

I'm trying to create a macro (to be activated by a button) that will search a column (G) in one section and if a cell (for example G7) has a certain value (for example 'withdrawn') then it will cut that entire row and relocate it to another section.

Now, so far I have been able to get it adding into the other section absolutely fine, but I just can't get my head around how to get it to identify the rows to move.

So essentially I'm looking for a macro to identify the row and cut it and then the existing code can do the rest. There are about 10 possible values that cell could contain where I would want it to be cut. The way the spreadsheet is used there will only be one row in that section which contains one of those values.

I've been searching the web for a couple of days for solutions and have not be able to find someone else with the same request or understand similar macros well enough to adapt them to my purpose so any assistance would be greatly appreciated.

The difficulty I've been having is with having multiple variables in the cell that I want to cut. So in that example the variable is 'dbo' and only 'dbo'. In my case the variable could be one of 10 things and I have not been able to figure out how to get it to search for those 10 values.

Ah I had been trying to use the or function after the value = rather than the whole range statement.

I've also found one other issue, where 1row = .Range("A" & .Rows.Count).End(xlUp).Row is causing the macro to search the entire worksheet when I really want it to search only a specific area.

The specific area is a row that is named area called 'adder'. At the moment that is row 9, but it will vary (both higher and lower). I've been trying to replace .Rows.Count but I keep getting errors. Can I use that named area as a reference in this macro?