| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
duplicating cells in diffrent sheets
the senareo agian : i wish to enter data in sheet 1 cell b6 and also display the same information in sheet 2 a10 or sheet 1 cell a1+b1+c1 anwser to appear in d1 and also a10 on sheet 2 -- kevatt ------------------------------------------------------------------------ kevatt's Profile: http://www.excelforum.com/member.php...o&userid=30245 View this thread: http://www.excelforum.com/showthread...hreadid=501218 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
duplicating cells in diffrent sheets
Put this in Sheet2 cell A10:
=if(sheet1!b6="","",sheet1!b6) kevatt wrote: the senareo agian : i wish to enter data in sheet 1 cell b6 and also display the same information in sheet 2 a10 or sheet 1 cell a1+b1+c1 anwser to appear in d1 and also a10 on sheet 2 -- kevatt ------------------------------------------------------------------------ kevatt's Profile: http://www.excelforum.com/member.php...o&userid=30245 View this thread: http://www.excelforum.com/showthread...hreadid=501218 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Konsolidating tabels on diffrent sheets in one sheets | Excel Worksheet Functions | |||
| Stop from duplicating entries on multiptle sheets | Excel Discussion (Misc queries) | |||
| Sheets duplicating | Excel Worksheet Functions | |||
| HOW CAN I PASTE THE DATE AUTOMATICLY THROUGH DIFFRENT SHEETS | Excel Discussion (Misc queries) | |||
| Duplicating rows across sheets | Excel Programming | |||
![kevatt[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
