How to move up/down multiple rows?

Follow-up: excel/macro to move rows between worksheets

• Back in December 2009 you offered a solution to Claudia on conditionally moving rows from one sheet to another. I have adopted this for a worksheet we need for tracking invoices raised and paid to move the buinesses to each stage (or sheet) as each event occurs. The only problem I'm having with the sheet - and my programming (especially VBA) is very rusty - is that when it moves any transported row it offsets the entire row from column A to B. I noticed that there is an offset in the script but seems to a negative movement (ie to the left). Many Gary

• Answer:

  Gary, I don't recall the script. If you are asking a question about the script, then if you could post it with your question and indicate where you have a question I will be glad to respond or explain the script if you need. Tom Ogilvy