General discussion


Excel Dynamic Ranges and Data Validation

By paul.hazard ·
I have a project I'm working on for another job I have where the only application to do this project is Excel 2003.

I need to have a list of part numbers, corresponding descriptions and possibly a home location for the part. These would be on one worksheet (for sake of this discussion, called DATA).

On other worksheets, I need to call items from the DATA worksheet to build a list of secondary locations for each of the parts. These secondary location worksheets would need the ability to be sorted by part number or secondary location.

The problem I'm running into is having to add new items to the secondary lists that aren't part of the DATA worksheet. These new items would also be need to be added to the DATA worksheet for future reference.

DATA worksheet might appear as follows:
SKU, Description, Home
123342, screw #8-32, 25-032
234987, tape 1x25, 25-014
698329, 2in brush, 24-068
732452, tape 1x30, 25-014
248745, sensor-wht, 27-104
349075, cleaner, 28-092
834509, insulation, 22-001

As an example, parts can be on strips or in stacks. The default would be strips so I would only need to mark if something is in a stack.

Secondary worksheets might appear as follows:
SKU, Description, Stack, Location
123342, screw #8-32, , 23-027
732452, tape 1x30, x, 21-041
349075, cleaner, , 25-039

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums