Re: Copy Rows Based On A Cell Value
Will definietly have something to do with
This goes to cell A65536 and finds the next cell above it that has information in it - if the the data fills the range up to here, then it will find A1...reason being I use excel 2003 where the maximum number of rows is 65536 so I am guessing you will need to amend this to reflect the maximum number of rows in 2007 (there may be a better way, but not having used excel for a while or 2007 ever I couldn't be sure -think 2007 maximum rows is somewhere around 1 million (2^20)...)
Bring on the bank holiday !!!
:drink: :sailboat: :drink: