create a macro that looks for (repost)
 

1. it is not necessary to insert a row
2. contents move below
3. need formatting copied as well
thanks so much for your help

create a macro that looks for (repost)
 

It may help if you actually posted a question, rather a list of ...
requirements ?

NicHK

"andresg1975" ...
1. it is not necessary to insert a row
2. contents move below
3. need formatting copied as well
thanks so much for your help

create a macro that looks for (repost)
 

Are we supposed to search for your original post to find out what the
question is. At least in the view I have, it isn't associated with this one.
Or is this your question, in which case I have no ideas what you are asking
but for grins:

ActiveCell.Copy
Activesheet.Next.Range("A9").Insert Shift:=xlShiftDown



--
Regards,
Tom Ogilvy


"andresg1975" wrote:

1. it is not necessary to insert a row
2. contents move below
3. need formatting copied as well
thanks so much for your help

create a macro that looks for (repost)
 

this is the question thanks
can u help me on this:
let's say i have rows like these:
B C D E
3020 0 28TH 28TH ST

3020 0 ACME ACME AWNING

The macro should find 3020 in column B, take cells in colums B C D E in that
row and bring them one
row down, continue the same procedure over and over



"NickHK" wrote:

It may help if you actually posted a question, rather a list of ...
requirements ?

NicHK

"andresg1975" ...
1. it is not necessary to insert a row
2. contents move below
3. need formatting copied as well
thanks so much for your help

create a macro that looks for (repost)
 

Tom,
Amazing, you got it in one. I'm sure that's the correct code.
It works for me.

NickHK

"Tom Ogilvy" ...
Are we supposed to search for your original post to find out what the
question is. At least in the view I have, it isn't associated with this
one.
Or is this your question, in which case I have no ideas what you are
asking
but for grins:

ActiveCell.Copy
Activesheet.Next.Range("A9").Insert Shift:=xlShiftDown



--
Regards,
Tom Ogilvy


"andresg1975" wrote:

1. it is not necessary to insert a row
2. contents move below
3. need formatting copied as well
thanks so much for your help

create a macro that looks for (repost)
 

andresg, I answered your original post. I apologize if I added to the
confusion. James
andresg1975 wrote:
this is the question thanks
can u help me on this:
let's say i have rows like these:
B C D E
3020 0 28TH 28TH ST

3020 0 ACME ACME AWNING

The macro should find 3020 in column B, take cells in colums B C D E in that
row and bring them one
row down, continue the same procedure over and over



"NickHK" wrote:

It may help if you actually posted a question, rather a list of ...
requirements ?

NicHK

"andresg1975" ...
1. it is not necessary to insert a row
2. contents move below
3. need formatting copied as well
thanks so much for your help