D
Doug
ok I have info. on sheet 2 that I want to insert into sheet 1. Therefore
formula would look like this. I hate to use the IF word, but.. How do I
transpose the info. from cell D3 Sheet 2, into D3 sheet 1,and if D3 sheet 2
is selected then data in F3 and F4 sheet 2 is automatically transposed into
F4 and F5 on sheet 1
In other words if (cell D3 sheet 2) is selected the the data would be
entered onto (sheet 1 cell D3) and the coresponding data in F3 and F4 would
folow to sheet 1 F4 F5.
formula would look like this. I hate to use the IF word, but.. How do I
transpose the info. from cell D3 Sheet 2, into D3 sheet 1,and if D3 sheet 2
is selected then data in F3 and F4 sheet 2 is automatically transposed into
F4 and F5 on sheet 1
In other words if (cell D3 sheet 2) is selected the the data would be
entered onto (sheet 1 cell D3) and the coresponding data in F3 and F4 would
folow to sheet 1 F4 F5.