Lookup Help Complicated
 

Excel2003
How can I do this? It's a little complex.

First:
Copy values from sheet1.
("A1"-Date,"B2"-Name,"C5"-Temperature1,"D8"-Temperature2,"E11"-Temperature3,"F4"-Chamber)

Second:
Then, depending on 1 value (F4-Chamber. 6 possible values, a thru f),
Move to another sheet (2,3 or 4).
(ex: If F4-Chamber="a" or "b" Move to sheet 2, If F4-Chamber="c" or "d" Move
to sheet 3, If F4-Chamber="e" or "f" Move to sheet4)

Third:
Then, check the Date Column(A:A) in destination sheet to see if the Date
copied from sheet1 exists.

If Date DOES exist, Then, Paste the values copied from sheet1 into that row
dependant on F4-Chamber value.
(ex: If F4-Chamber="a", Paste
B2-Name,C5-Temperature1,D8-Temperature2,E11-Temperature3 TO Sheet2,
FoundDateRow, B,C,D,E.)
or
(If F4-Chamber="b", Paste
B2-Name,C5-Temperature1,D8-Temperature2,E11-Temperature3 TO Sheet2
FoundDateRow, F,G,H,I)

Similar if moved to sheet 3 (if F4-Chamber="c" or "d")
Similar if moved to sheet 4 (if F4-Chamber="e" or "f")

If Date DOESN'T exist, Paste values to Newrow.
(ex: If F4-Chamber="a", Paste
A1-Date,B2-Name,C5-Temperature1,D8-Temperature2,E11-Temperature3 TO Sheet2,
Newrow, A,B,C,D,E.)
or
(If F4-Chamber="b", paste
A1-Date,B2-Name,C5-Temperature1,D8-Temperature2,E11-Temperature3 to Sheet2,
Newrow, A,F,G,H,I)

Similar if moved to sheet 3 (if F4-Chamber="c" or "d")
Similar if moved to sheet 4 (if F4-Chamber="e" or "f")

Hope this makes sense

Lookup Help Complicated
 

Sorry, Another wrinkle.

After finding date, check to see if dependent paste range has data. if so
add new row and paste data.
Ex:
If Date DOES exist, Then,
If F4-Chamber="a" Check Sheet2, FoundDateRow, B,C,D,E. If Empty, Paste
B2,C5,D8,E11. If Not Empty, Paste A1,B2,C5,D8,E11 to Newrow.
Or
If F4-Chamber="b" Check Sheet2, FoundDateRow, F,G,H,I. If empty, Paste
B2,C5,D8,E11. If Not empty, Paste A1,B2,C5,D8,E11 to new row.


"Gizmo" wrote:

Excel2003
How can I do this? It's a little complex.

First:
Copy values from sheet1.
("A1"-Date,"B2"-Name,"C5"-Temperature1,"D8"-Temperature2,"E11"-Temperature3,"F4"-Chamber)

Second:
Then, depending on 1 value (F4-Chamber. 6 possible values, a thru f),
Move to another sheet (2,3 or 4).
(ex: If F4-Chamber="a" or "b" Move to sheet 2, If F4-Chamber="c" or "d" Move
to sheet 3, If F4-Chamber="e" or "f" Move to sheet4)

Third:
Then, check the Date Column(A:A) in destination sheet to see if the Date
copied from sheet1 exists.

If Date DOES exist, Then, Paste the values copied from sheet1 into that row
dependant on F4-Chamber value.
(ex: If F4-Chamber="a", Paste
B2-Name,C5-Temperature1,D8-Temperature2,E11-Temperature3 TO Sheet2,
FoundDateRow, B,C,D,E.)
or
(If F4-Chamber="b", Paste
B2-Name,C5-Temperature1,D8-Temperature2,E11-Temperature3 TO Sheet2
FoundDateRow, F,G,H,I)

Similar if moved to sheet 3 (if F4-Chamber="c" or "d")
Similar if moved to sheet 4 (if F4-Chamber="e" or "f")

If Date DOESN'T exist, Paste values to Newrow.
(ex: If F4-Chamber="a", Paste
A1-Date,B2-Name,C5-Temperature1,D8-Temperature2,E11-Temperature3 TO Sheet2,
Newrow, A,B,C,D,E.)
or
(If F4-Chamber="b", paste
A1-Date,B2-Name,C5-Temperature1,D8-Temperature2,E11-Temperature3 to Sheet2,
Newrow, A,F,G,H,I)

Similar if moved to sheet 3 (if F4-Chamber="c" or "d")
Similar if moved to sheet 4 (if F4-Chamber="e" or "f")

Hope this makes sense