I want to establish a link from my worksheets. Using the conventional link method I was able to link the values from my first worksheet to the second worksheet. My problem is when I delete a particular row. The reference of the second worksheet will have an error #REF! since I deleted those cells. Is there any way that I can link my two worksheets without any error that even if I deleted a particular cell/row the reference is still intact?
What is the purpose behind linking the 2 sheets? Are you trying to copy specific data from one sheet to the other?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Yes, I am.Originally Posted by arlu1201
It will be good if you explain with the help of an excel sample file. I am just guessing that a macro will work good for you to copy the data from sheet 1 to sheet2.
To Attach a File:
1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.
Please see attached file.
You can try this code -You can assign it to a button. Each time you make changes to your Sheet1, then once you click on the button or shortcut key combination, the data will be copied to Sheet2. You make a change again, click the button or press the shortcut keys and the data will be cleared from sheet2 and re-input with the changes from Sheet1.
Please Login or Register to view this content.
You can try this code -You can assign it to a button. Each time you make changes to your Sheet1, then once you click on the button or shortcut key combination, the data will be copied to Sheet2. You make a change again, click the button or press the shortcut keys and the data will be cleared from sheet2 and re-input with the changes from Sheet1.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks