LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change the location of external data feeding a pivottable Mark Parent Excel Discussion (Misc queries) 4 January 3rd 08 10:20 PM
Change Location of VBE References with VBA Peter T Excel Programming 4 July 24th 07 04:31 PM
How do I change the default location when Importing data? Hyerczyk Excel Discussion (Misc queries) 3 July 7th 06 05:53 PM
sort multiple columns of data but not change the data location... Possible? [email protected] Excel Programming 3 June 15th 06 09:15 PM


All times are GMT +1. The time now is 09:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"