help with ranges

[Jerryb]

I need a to know a formula for a range that verify's another field has
certain varaible or # the goes to another field in the same record an
copies the next 4 cells down and then pastes the the copie
information in the next column but same record. transposes the dat
for the 4 cells, so all data on the same record

 

[Mark E. Philpot]

It's a bit hard to figure out. Could you send a sample
sheet of "Was" and "Now" to [email protected] and
I will write a macro or userform utility for you. You can
verify my ability at my userform site:
http://au.geocities.com/excelmarksway

with regards
Mark E. Philpot

 

[support]

I am from the MS Excel support department at http://www.enterpriseprojectconsulting.com and we would be happy to assist you in resolving your issue

Thank you

Enterprise Project Consultin