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

Solved/Closed
naresh - Feb 25, 2016 at 12:58 PM
BrianGreen Posts 1010 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 - Feb 25, 2016 at 05:45 PM
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.

1 reply

BrianGreen Posts 1010 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 148
Feb 25, 2016 at 01:16 PM
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)
0
,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.
0
BrianGreen Posts 1010 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 148
Feb 25, 2016 at 05:45 PM
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.
0