Formulas
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. -- not old enough! only 57 |
All times are GMT +1. The time now is 09:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com