MS EXCEL, Cell shifthing
|
|
 Jul 13 2006, 04:40 PM, updated 20y ago
Show posts by this member only | Post
#1
|
 
Junior Member
95 posts Joined: Jan 2003 From: Somewhere i belong.... 
|
Dear experts,
I'm not very familiar wif excel macro. I face a problem, and i dunno whether excel macro can solve my problem or not, if can kindly advise me... thanks in advances. I need to move a set of data from one column to another column base on the row 1 description. e.g: For column A data is PO number and have to move to column B, and column B is Date and have to move to column A. Is there any marco function can do this for me??? pls advise... TQTQTQ  |
|
|
|
|
|
Jul 13 2006, 05:35 PM
Show posts by this member only | Post
#2
|
 
VIP
11,594 posts Joined: Jan 2003 From: Area 51 
|
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 |
|
|
Jul 13 2006, 05:48 PM
Show posts by this member only | Post
#3
|
Senior Member
739 posts Joined: Mar 2006 From: Moon Palace  
|
 Cut and paste can be done. |
|
|
Jul 13 2006, 08:34 PM
Show posts by this member only | Post
#4
|
Senior Member
2,644 posts Joined: Apr 2006 From: Akatsuki 
|
Just cut Cell A and paste after the Cell B.
|
|
|
Jul 13 2006, 09:14 PM
Show posts by this member only | Post
#5
|
 
Moderator
10,308 posts Joined: Jan 2003 From: Kuala Lumpur
|
QUOTE(boon77 @ Jul 13 2006, 04:40 PM) Dear experts, 1. move all data from column a to column c (temporary).I'm not very familiar wif excel macro. I face a problem, and i dunno whether excel macro can solve my problem or not, if can kindly advise me... thanks in advances. I need to move a set of data from one column to another column base on the row 1 description. e.g: For column A data is PO number and have to move to column B, and column B is Date and have to move to column A. Is there any marco function can do this for me??? pls advise... TQTQTQ  2. move all data from column b to column a. 3. move the data from c to b. or is it the arrangement of the data is not in an organized matter? |
|
|
Jul 13 2006, 10:03 PM
Show posts by this member only | Post
#6
|
Senior Member
946 posts Joined: Apr 2006 From: Kuala Lumpur
|
QUOTE Is there any marco function can do this for me??? If you can do it manually, then go to Tools > Macro > Record a New Macro & record your macro. To view your macro, hit ALT F8 > Edit.Good Luck. |
|
|
|
|
|
Jul 14 2006, 07:21 PM
Show posts by this member only | Post
#7
|
Junior Member
32 posts Joined: Dec 2004
|
yeah, don't even need a macro. like HMMaster said, use another cell to move first and then after that move it to that cell. do u have any difficulties on that?
|
|
|
Jul 14 2006, 08:54 PM
Show posts by this member only | Post
#8
|
|
Senior Member
2,644 posts Joined: Apr 2006 From: Akatsuki
|
Not so Hard la..
|
|
|
Jul 17 2006, 07:34 AM
Show posts by this member only | Post
#9
|
|
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.0161sec
 0.75
 5 queries
 GZIP Disabled
Time is now: 21st December 2025 - 03:01 PM |
Quote