Report

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

Ask a question naresh - Latest answer 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 879Posts Saturday January 17, 2015Registration date September 27, 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

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!