Thread: Copy the 14 cells and transfer them to another sheet loop
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Crowbar via OfficeKB.com Crowbar via OfficeKB.com is offline
external usenet poster
  
Posts: 128
Default Copy the 14 cells and transfer them to another sheet loop
Hi Experts

On worksheet 1 i have in Column A about a 1000 entries

What I want to do is to transfer the first 14 onto sheet 2 and then print

Then I want it to transfer the next 14 and then print

I want it to loop through this process until it has printed all 1000

Can anyone help me?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200601/1
Reply With QuoteReply With Quote