ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Formulas (https://www.excelbanter.com/excel-worksheet-functions/177760-formulas.html)

Doug[_4_]

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