Yes, horrible title I know - here is my question:
I currently have a spreadsheet set up where I have users use the simple = to map back to a field location on a separate tab.
What I would like when they either click in the cell where the data will be mapped to is for a pop up box to show up (similar to vlookup) where they can map to the location.
Once the user does this once, they should be able to drag the = location all the way down.
I currently have a spreadsheet set up where I have users use the simple = to map back to a field location on a separate tab.
What I would like when they either click in the cell where the data will be mapped to is for a pop up box to show up (similar to vlookup) where they can map to the location.
Once the user does this once, they should be able to drag the = location all the way down.