how do i enter data in multiple sheets simultaneously
..
|
how do i enter data in multiple sheets simultaneously
Hi Usman, Normally you would do this by referencing the subsequent sheet cell to the one where you have entered the data, so if in sheet1 cell A1 you input a value, then in sheet2 A1 you would enter =sheet1!A1 HTH Ed -- EdMac ------------------------------------------------------------------------ EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736 View this thread: http://www.excelforum.com/showthread...hreadid=522605 |
how do i enter data in multiple sheets simultaneously
Hold down the Ctrl key and select the sheets of interest.......then enter
data in cell you want .......it will go in same cell on all selected sheets.......... Vaya con Dios, Chuck, CABGx3 "Usman Satti" wrote: . |
All times are GMT +1. The time now is 07:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com