I have two workbooks connected but I switch the way the first is sorted it moves around all of my rows so that the data no longer matches up. How do I prevent this from occurring?
I have two workbooks connected but I switch the way the first is sorted it moves around all of my rows so that the data no longer matches up. How do I prevent this from occurring?
Could you attach your sheets so we can have a look at your problem?
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
The files are too large. I will insert images that will hopefully help. sheet1.PNG sheet2.PNG
The first sheet is the one the data is coming from. When I sort the any of the date scheduled it changes the two other tabs on the sheet2 attachment.
Images are of little help with this kind of problem. We dont need your whole file anyway, just a small sample that shows what you have, and what is happening
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks