Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Locking a couple rows so when you do a delete shift row they dont
example:
cavalier (prints at top of page 1 b3406 93 buick 2 b3407 82 dodge 3 b3487 99 chevy 4 b4132 87 pontiac 5 b3206 75 chevy aveo (prints top of secon page) 1 b5555 2003 chevy 2 b8654 04 dodge 3 b8989 05 lexus i want to delete b3206 75 chevy and have everything below it shift up and stay inline with the numbers. example delete b3206 75 chevy, now b5555 2003 chevy would be number 5 on page one and b8654 04 dodge would be number 1 on page 2 and b8989 05 lexus would be number 2 on page 2, and so on. any help would be appreciated. I beleive i just have the early excell progam |
#2
|
|||
|
|||
-----Original Message----- example: cavalier (prints at top of page 1 b3406 93 buick 2 b3407 82 dodge 3 b3487 99 chevy 4 b4132 87 pontiac 5 b3206 75 chevy aveo (prints top of secon page) 1 b5555 2003 chevy 2 b8654 04 dodge 3 b8989 05 lexus i want to delete b3206 75 chevy and have everything below it shift up and stay inline with the numbers. example delete b3206 75 chevy, now b5555 2003 chevy would be number 5 on page one and b8654 04 dodge would be number 1 on page 2 and b8989 05 lexus would be number 2 on page 2, and so on. any help would be appreciated. I beleive i just have the early excell progam .Are the pages full of data, if so this would happen automatically. If not, the top of page 2 would move to the bottom of page 1. I think a macro to run through your data after every deletion is called for. Contact me if you need a copy of a suitable macro. |
#3
|
|||
|
|||
Ty for you help. I emailed you what i have. If you could do anything with
it i would appreciate it. Thanks again, Jeff " wrote: -----Original Message----- example: cavalier (prints at top of page 1 b3406 93 buick 2 b3407 82 dodge 3 b3487 99 chevy 4 b4132 87 pontiac 5 b3206 75 chevy aveo (prints top of secon page) 1 b5555 2003 chevy 2 b8654 04 dodge 3 b8989 05 lexus i want to delete b3206 75 chevy and have everything below it shift up and stay inline with the numbers. example delete b3206 75 chevy, now b5555 2003 chevy would be number 5 on page one and b8654 04 dodge would be number 1 on page 2 and b8989 05 lexus would be number 2 on page 2, and so on. any help would be appreciated. I beleive i just have the early excell progam .Are the pages full of data, if so this would happen automatically. If not, the top of page 2 would move to the bottom of page 1. I think a macro to run through your data after every deletion is called for. Contact me if you need a copy of a suitable macro. |
#4
|
|||
|
|||
YOUR THE MAN!!!!!!!!!! works perfect!!! Thanks Again.
"palukagoat" wrote: Ty for you help. I emailed you what i have. If you could do anything with it i would appreciate it. Thanks again, Jeff " wrote: -----Original Message----- example: cavalier (prints at top of page 1 b3406 93 buick 2 b3407 82 dodge 3 b3487 99 chevy 4 b4132 87 pontiac 5 b3206 75 chevy aveo (prints top of secon page) 1 b5555 2003 chevy 2 b8654 04 dodge 3 b8989 05 lexus i want to delete b3206 75 chevy and have everything below it shift up and stay inline with the numbers. example delete b3206 75 chevy, now b5555 2003 chevy would be number 5 on page one and b8654 04 dodge would be number 1 on page 2 and b8989 05 lexus would be number 2 on page 2, and so on. any help would be appreciated. I beleive i just have the early excell progam .Are the pages full of data, if so this would happen automatically. If not, the top of page 2 would move to the bottom of page 1. I think a macro to run through your data after every deletion is called for. Contact me if you need a copy of a suitable macro. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete specified critria rows | Excel Discussion (Misc queries) | |||
how do I delete all rows that match a condition? | Excel Worksheet Functions | |||
delete repeating rows | Excel Worksheet Functions | |||
delete empty rows between rows with text | Excel Discussion (Misc queries) | |||
How do I delete blank rows at the bottom of a spreadsheet to get . | Excel Discussion (Misc queries) |