I have a problem. I am trying to create two sheets with data. Both sheets have the same structure and each one depends from a Drop down list. Both drop down list have the same data source.
The problem is that i want one list to change when i change the other. However I have no ideia how to accomplish this.
Some help would be appreciated. Thanks in advance!
That is not what I want to accomplish. That works when one list depends on the other. What I want is the same list, presented in two sheets. Basically, you can work on that list on two interfaces.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Here is the sample workbook to my doubt:Book1.xlsx
You don't give any indication of what you are expecting? Are you wanting whatever is chosen in list1 to be removed from list2 so that both lists are diminished by the choices made? Or, are you wanting something completely different?
I want List 1 to replicate List 2, and list 2 to replicate List 1. However, I want to be able to choose 1, 2 or 3 in any of the list, making the other list change aswell
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks