macro command

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all i had a problem of shifting selected rows one cell to the right, the
data looks like this:-

328 Sales $ 0 0 0 0 0 0
Qnty 0 0 0 0 0 0 0
509 Sales $ 0 0 0 0 0 0
Qnty 0 0 0 0 0 0 0
ALEX Sales $ 0 0 0 0 0 0
Qnty 0 0 0 0 0 0 0
ALJ Sales $ 0 0 0 0 0 0
Qnty 0 0 0 0 0 0 0
ANCH Sales $ 0 0 0 0 0 0
Qnty 0 0 0 0 0 0 0
ANG Sales $ 0 0 0 0 0 0
Qnty 0 0 0 0 0 0 0
ANSON Sales $ 0 0 0 0 0 0
Qnty 0 0 0 0 0 0 0
BEDOK Sales $ 0 0 0 0 0
Qnty 0 0 0 0 0 0 0
As what you have see the qnty column is not same as the sales column and i
had hundred thousand of rows to cut and paste.

Range("A746:H746").Select
Selection.Cut
Range("B746").Select
ActiveSheet.Paste
Range("A748:H748").Select
Selection.Cut

Range("B748").Select
ActiveSheet.Paste
Range("C749").Select
Is macro command able to solve the problem? like shifting selected multiple
rows one cells to the rigth.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a macro commad to shift selected rows to the right next c 1
Command button to move completed action item 4
Yet another copy/paste macro question 6
Trying to insert a column using variable in a Macro 1
DoUntil VB command 1
Problem with Macro 7
assigning macro 17
JLatham MVP (Macro) 3

Back
Top