• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Macro question or VB

john8714

New Member
If it is easier to do it in VB I will do it in VB but I am working on a macro.

I want to remove the first row, move the now second row to the third column and move to the next entry in the first row so I can continue w/ the same process. I am enclosing an example. It is possible to solve in VB or a macro?

Rows("2:2").Select
Selection.Delete Shift:=xlUp
Range("A3:B3").Select
Selection.Cut
Rows("3:3").Select
Selection.Delete Shift:=xlUp
Rows("3:3").Select


------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Post Moved by Moderator.


.
 

Attachments

  • example_macro.xlsx
    8.2 KB · Views: 2
Last edited by a moderator:
john8714 ... hmm?
remove 1st row - okay
move 2nd row to 3rd column ... do You really mean that?
hmm?
or
[A2] move to [A1]
[A3] move to [B1]
[C5] move to [A2]
[C6] move to [B2]
and so on?
 
updated information. sorry I always forget that it is much easied w/ picture and file. Options/alternatives are an advantage. Just to clarify, the list hold many additional entries. How to get it to understand that it is an iteration? If one produces the VB code, will Excel "get it" if one goes back and wants a macro on that? How do one bridge over from VB code to macro?
 

Attachments

  • example_macro.xlsx
    8.8 KB · Views: 2
  • screenshot example.JPG
    screenshot example.JPG
    31.8 KB · Views: 9
Last edited:
john8714 --- I have a better idea. --- Yes!
You could record Your own macro and then You would see what would You need.
My 'Press [ Do It ]' do just as You wrote.
 
john8714 --- I have a better idea. --- Yes!
You could record Your own macro and then You would see what would You need.
My 'Press [ Do It ]' do just as You wrote.

I find it amusing when you are arrogant. Do anyone find your solutions useful. Compare yourself w/ the others in this forum.
 
john8714
Of course there are always better ideas.
But if You cannot explain
Show me, how I can move B2 to A3 w/ a macro and re-iterate it.
how Your idea 'works'
then it would be challenge to help You.
What missed from my solution?

You also asked: Do anyone find your solutions useful.
So far page shows only 883 likes from 2893 messages, so maybe someone has.
 
I find it amusing when you are arrogant. Do anyone find your solutions useful. Compare yourself w/ the others in this forum.
john8714 he his the « Arrogant ». He dint know the respect of people who helping to them.. what he thinks if he found solution himself what he needs and not proper reply to Mr.vletm. why to post his question to solve here in chandoo.org.and not respecting to forum rules. :(
 
john8714 posted the following
It is possible to solve in VB or a macro?

As far as code goes they are both the same, the main difference being that a macro can only do as you record so full VBA would allow more scope.
 
Back
Top