Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to delete lines based on a value - Repost | Excel Discussion (Misc queries) | |||
How to create a view option (or hide/unhide preselected cells) (Repost from Misc) | Excel Programming | |||
repost: Need Help With Steaming Data Macro | Excel Programming | |||
RePost - Calling a Macro from a key | Excel Programming | |||
Macro to Delete - repost | Excel Programming |