Report

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

Ask a question naresh - Last answered on Feb 25, 2016 05:45PM
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.
See more 
Helpful
+0
moins plus
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


Naresh- Feb 25, 2016 02:29PM
,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.
Reply
BrianGreen 883Posts Saturday January 17, 2015Registration date ModeratorStatus December 8, 2016 Last seen - Feb 25, 2016 05:45PM
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.
Reply
Add comment

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!