Hi All,
Can anyone let me know how to duplicate the values in different worksheets.
Example: I have 5 Work Sheets. I will enter data in Sheet1 that data should automatically reflect in all other sheets. I dont want to Copy or Move the worksheet.
Regards
Pavan Kumar
Did you tried in A1 of your second(as an example) sheet to put this?
=Sheet1!A1
Copy down and across.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thanks for the reply,
I have tried this. I am able to duplicate values. Thank you so much.
Is it possible that we can duplicate the colour of the cell and the tables also.
Regards
Pavan Kumar
The color of the cell only using copy-paste OR if the color is created by a Conditional Formmating rule, use the same rule, to the other sheet too.
Can you suggest how to use conditional formatting rule to apply colors to one or more cells.
Regards
Pavan Kumar
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks