Need cell value copy to defferent -2 work sheets within a Excel [Solved/Closed]

Ask a question naresh - Last answered on Feb 25, 2016 at 05:45 PM by BrianGreen
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.

plus moins
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 ...

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

Naresh- Feb 25, 2016 at 02:29 PM
,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 937Posts Saturday January 17, 2015Registration date ModeratorStatus October 11, 2017 Last seen - 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.

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!