LinkBack URL
About LinkBacks
A table is dynamic by design so don't use its address like $A$1:$A$20
See file attached.
EDIT: try entering a fifth city at the bottom of the table and watch what's happening with both table and dropdowns on the other worksheet.
A table is dynamic by design so don't use its address like $A$1:$A$20
See file attached.
EDIT: try entering a fifth city at the bottom of the table and watch what's happening with both table and dropdowns on the other worksheet.
Last edited by GWteB; 12-16-2021 at 03:16 PM.
Thank You, that looks like what i need. In the revised version I have uploaded.Originally Posted by GWteB
Can I ask a couple of questions on this.
Do I need to update the table with the sites, or is it possible to type in the box and have the site table updated, it is fine if i need to update the site table first, i am just interested to know.
Also I have added a site number, i get this by using xlookup, is that the best way?
Last edited by gjjh25; 12-16-2021 at 04:08 PM.
Glad to help.
I'm not sure what you mean by this. Just to be sure, the table named Table1 on the worksheet named Sites is the source of and contains the elements for the data validation drop downs that you use in column B of the worksheet named Order.
It looks like there's a relationship between the site name and the site number. In that case I would keep the XLOOKUP.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks