I have some dropdowns that create a unique ID number for a row based on week, day and shift, e.g. 1, 2, 2. I want to use the variable value from this to select the row of data with the same ID (something similar to access, but access is not an option here).
Using concatenate to generate the ID
Example of the data stored on a separate sheet
The end goal is to select the row that has the ID that has been selected from the dropdowns (this is for loading the data on a daily report)
I've tried a few things, but can't seem to crack this one, any help with this code is much appreciated.
https://stackoverflow.com/questions/66084161/vba-to-select-row-number-based-on-cell-value February 07, 2021 at 11:02AM
没有评论:
发表评论