Cut certain cells paste to side and shift cells up

I have file1 needs to be formatted to file2 every day. Basically, all the rows contain "1.1 - Item(s)..." in column D need to be moved to the right part of the sheet and shift up the empty cells up after that. When I record macro and use "Shift+Ctrl" to select cells, it only records the row number it should go to on this sheet while the number of these rows will changes everyday.
How can I make changes on the VBA code to accomplish this task?
temp1.xls
temp2.xls
mmcompactAsked:
Who is Participating?
 
thydzikConnect With a Mentor Commented:
see the attached. select the temp1.xls and it will populate the 2 columns

 compile-to-2-columns.xls
0
 
LelikInsideCommented:
A little hint: Rows(Activecell.row).select
0
 
mmcompactAuthor Commented:
could you be more specific? thanks
0
 
mmcompactAuthor Commented:
thydzik:

When I check it again, it didn't worked quite as I wanted. First I don't want the script to run when I open it. Secondly, after I put the second column back to the first column and try to run "runme" manually, it didn't cut and paste the rows back
compile-to-2-columns-revised.xls
0
 
thydzikCommented:
mmcompact,

You did not specify how you wanted the script to run.

Secondly, you did not specify it needed to run in reverse writing from 2 columns to 1.

Please create a new question specifying these new requests.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.