-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Posting a command should come in both sheet
- Thread starter aravind
- Start date
Tazguy37
MrExcel MVP
- Joined
- May 28, 2004
- Messages
- 4,237
Welcome to MrExcel Board!
You can try:
Go to Sheet1
Select all cells (using the square button just above the "1" for Row 1, and just to the left of the "A" for Column A)
Go to Edit, Copy from the menus
Go to Sheet2
Select Edit, Paste Special, All
Click OK.
That's one way.
Also, you could create formulas in Sheet2 that look like this:
=Sheet1!A1
Which would copy the value in A1 on Sheet1 (but not any formatting) to Sheet2, and change when the value in Sheet1 changes.
Hope that helps!
You can try:
Go to Sheet1
Select all cells (using the square button just above the "1" for Row 1, and just to the left of the "A" for Column A)
Go to Edit, Copy from the menus
Go to Sheet2
Select Edit, Paste Special, All
Click OK.
That's one way.
Also, you could create formulas in Sheet2 that look like this:
=Sheet1!A1
Which would copy the value in A1 on Sheet1 (but not any formatting) to Sheet2, and change when the value in Sheet1 changes.
Hope that helps!
Upvote
0
