View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Darius Darius is offline
external usenet poster
 
Posts: 41
Default change of data location

unable to macro, can anybody help please
I have bunch ofdata in Excel and want:
1- to insert an empty cell in Col G start from G4, (G4 content goes one cell
down etc) jump evrery 8 cell, (e.g. G12, G20 ,... up to G49181 as last cell.

2- copy data from T3 to G4, T12 to G13, T21 to G22 and continue by jumping
for both T and G as 9. Last cell to copy from is T49180 and copy to G49181.

Appreciate your help