So you're shifting one column to the right, does it have to be in the same row?
If it doesn't then it's easy, you don't even need a macro
MS EXCEL, Cell shifthing
|
|
 Jul 13 2006, 05:35 PM
Return to original view | Post
#1
|
 
VIP
11,594 posts Joined: Jan 2003 From: Area 51  
|
|
Quote|
|
Jul 17 2006, 07:34 AM
Return to original view | Post
#2
|
|
VIP
11,594 posts Joined: Jan 2003 From: Area 51
|
Based on the description of boon77 it sounds more like swapping
Since normal excel formula can't do cell moving/shifting/swapping for you, I'm afraid you'll have to use Macro script |
| Change to: |  0.0844sec
 0.16
 6 queries
 GZIP Disabled
Time is now: 22nd December 2025 - 01:47 PM |
All Rights Reserved © 2002- 2025 Vijandren Ramadass (~unite against racism~)
Powered by Invision Power Board © 2025 IPS, Inc.