ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do i enter data in multiple sheets simultaneously (https://www.excelbanter.com/excel-worksheet-functions/77484-how-do-i-enter-data-multiple-sheets-simultaneously.html)

Usman Satti

how do i enter data in multiple sheets simultaneously
 
..


EdMac

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


CLR

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