Excel is it possible?

[copedipper]

If I have sheet1 column e cell 1 with a value of a,b,c or d to then based on a,b,c,d copy columns a-e to another spreadsheet in workbook. ie. if sheet1 E1 is equal to a than copy A1 B1 C1 D1 E1 to sheet2 A1 B1 C1 D1 E1. If B than copy same to sheet2? And if so how?

 

[Dreamboat]

On sheet two, in each cell:

A1 =IF(Sheet1!e1="a",Sheet1!a1,"&quot
B1 =IF(Sheet1!e1="a",Sheet1!b1,"&quot

and so on.

You can't get it to *copy*, but you can get it to pick up the values.

http://www.TheWordExpert.com

 

[Hasit]

Dreamboat's suggestion would work. Just one question though: what would you like it to do if the entry in E1 was "B"? You say do the same, in which case, it would not matter whether the entry was A, B, C or anything else....or am I missing something?

 

[copedipper]

Sorry I ment I E1=B than copy to sheet3 if c sheet4 if d sheet5

 

[Hasit]

OK, in that case, Dreamboat's suggestion would work. All you would need to do in each of the sheets (sheet2, sheet3 etc), is to test for the character you are looking for and then copy the contents of the cells you want if they match.