Excel help

[otispunkmeyer]

theres a couple of things i want to do in excel but not sure how

i have data relating to steel plate width, length, gauge, number of rolls used and strategy used

how would i go about doing this

i need a formula to check 2 columns (width and length) and look for, say width of 1000 and length of 12000. when it finds those 2 conditions i want it to then move the entire row to a new location

ie current row goes from A1 to O1 and when it finds 1000 and 12000 it moves the row A1-O1 to say A20 - O20 (though the actual worksheet is a couple of thousand rows)

 

[otispunkmeyer]

bump

 

[Alex]

i'd do that using VBA...
if you know any visual basic programming then it'll be really easy

try this site:
http://www.mrexcel.com/

its free to sign up and people are VERY responsive and helpful in the forums, really helped me out when i needed it last year! 🙂

good luck!

 

[Kelnoen]

Do you want it to run once or to be in constant effect?
Does it have to completely remove the row or just copy it?
It is possible through Excel formulas but not if u want only run once.

 

[otispunkmeyer]

Originally posted by: Kelnoen
Do you want it to run once or to be in constant effect?
Does it have to completely remove the row or just copy it?
It is possible through Excel formulas but not if u want only run once.

how do you mean run once?

ill probably need to do it for other sizes too.... so i guess maybe just re-arranging the data in ascending or descending order will do