Hi

I am hoping that somebody may be able to help with this

I am trying to semi automate a worksheet to cut and paste Company account
information within the same spreadsheet

For example one of the worksheets may have 60 rows I need to select Company
A - cut it and paste it into a blank row + 2 then go on to to select Company
B and perform the same operation. The entire spreadsheet has about 50 or so
worksheets - getting this sorted out would save me a lot of time

Any help would be much appreciated


Thank you