Previous Topic Next Topic

Need cell value copy to defferent -2 work sheets within a Excel

Solved/Closed
naresh - 25 Feb 2016 à 12:58
BrianGreen Posts 1005 Registration date Saturday 17 January 2015 Status Contributor Last seen 30 September 2021 - 25 Feb 2016 à 17:45
Hello,
hi all

i need to maintain a MIS on daily basis. in this, i need to enter same values multiple times on individual worksheet within a excel sheet.
is there any possible way, so that that thew cell value copy automatically at the next worksheet.

Related:

1 response

Réponse 1 / 1
BrianGreen Posts 1005 Registration date Saturday 17 January 2015 Status Contributor Last seen 30 September 2021 149
25 Feb 2016 à 13:16
Hi Naresh,

Couldyou put this code into the cells you need the data? 

=[sheetname]![cell where the original is]


so if you has a sheet called MyData and you wanted to copy the data in cell A5 it would be ... 
=MyData!A5


If your sheet was called My Data (with a space in it) the code would be ... 
='My Data'!A5


I really appreciate thank you messages as a payment for solving issues   :o)
Naresh
25 Feb 2016 à 14:29
,thanks brian, i want this ..tahnks again...

Can we make it that way that when i put value in cell autometically it copy to another worksheets specified cell without any button action.
BrianGreen Posts 1005 Registration date Saturday 17 January 2015 Status Contributor Last seen 30 September 2021 149
25 Feb 2016 à 17:45
It should do that with the code suppied above. There were no buttons added to the spreadsheet. you just have to finish entering the data and move to a different cell.

Similar discussions

Little Alchemy
anonymoussssssssssssssss -
HelpiOS -

1 response