Thread: copy range and paste into every 3rd cell of new range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
thomsonpa thomsonpa is offline
external usenet poster
  
Posts: 31
Default copy range and paste into every 3rd cell of new range
I have 2 worksheets and I am looking for a macro that will copy a range of
cells from one worksheet, then paste them to another worksheet, but leave 2
blank cells between each cell.

sheet to copy from "MON" range: A7:A80
sheet to paste into "MON LOG" starting at cell A5, paste then leave 2 cells
blank, next cell A8, etc. until all of the copied range A7:A80 has been
pasted.

Any ideas?
Reply With QuoteReply With Quote