Nested If statement or lookup?
 

I want to move information from worksheet 1 to worksheet 2. on worksheet 2
information from worksheet 1 is listed in one row and many columns. on
worksheet 1 information is listed in rows 1-320 and columns A-G. column A and
G are lists of names and column F is a classification, columns B-E have
numerical values or are empty. to avoid running out of columns on worksheet
2, I only want to move information from worksheet 1 to worksheet 2 when there
are numerical values in columns B-F on worksheet 1. I'll give an example
below, but I don't know if the formatting will mess up the columns.

worksheet 1

A B C D E F
Name 1 44 40-48 9% Very Low WJIII
Name 2 88 80-96 25% Low OWLS

worksheet 2
A B C D E F G
H I
Name 1 44 40-48 9% Very Low WJIII Name 2 88 80-96

J K L
25% Low OWLS

thanks, Lee

Nested If statement or lookup?
 

Just a thought. Why? Your source data in Sheet1 is already in a standard
columnwise structure which is v.much better than what you intend to do in
Sheet2. Much better as in, its easier/ready to process and analyse via
autofilter, pivot tables etc.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"Lee" wrote:
I want to move information from worksheet 1 to worksheet 2. on worksheet 2
information from worksheet 1 is listed in one row and many columns. on
worksheet 1 information is listed in rows 1-320 and columns A-G. column A and
G are lists of names and column F is a classification, columns B-E have
numerical values or are empty. to avoid running out of columns on worksheet
2, I only want to move information from worksheet 1 to worksheet 2 when there
are numerical values in columns B-F on worksheet 1. I'll give an example
below, but I don't know if the formatting will mess up the columns.

worksheet 1

A B C D E F
Name 1 44 40-48 9% Very Low WJIII
Name 2 88 80-96 25% Low OWLS

worksheet 2
A B C D E F G
H I
Name 1 44 40-48 9% Very Low WJIII Name 2 88 80-96

J K L
25% Low OWLS

thanks, Lee