software

Try t organize the T1 bit in all worksheets to be in the same cell say
A1 and try this example.

EndRow = Range(quot;a1quot;).Value
Range(quot;T5:AC5quot;).Select
Application.CutCopyMode = False
Selection.Copy
Range(quot;T6:Tquot; CStr(EndRow)).Select
ActiveSheet.PasteThanks very much for your help. I will also try this approach and see which
is the best - thanks again.

quot;flummiquot; wrote:

gt; Try t organize the T1 bit in all worksheets to be in the same cell say
gt; A1 and try this example.
gt;
gt; EndRow = Range(quot;a1quot;).Value
gt; Range(quot;T5:AC5quot;).Select
gt; Application.CutCopyMode = False
gt; Selection.Copy
gt; Range(quot;T6:Tquot; CStr(EndRow)).Select
gt; ActiveSheet.Paste
gt;
gt;