I've attached a mockup of one of the spreadsheets. The other one would be too complicated to reproduce as a dummy file - it has 50 tabs for the states, and it contains names and licensing information I would have to replace.
The state tab on the second worksheet must display broker information (the brown section), along with whatever appears in the state column of the first worksheet. If the cell in the State column is blank for that broker, nothing transfers to the state tab in the other worksheet.
The format for the second spreadsheet can just rely on the input from the first spreadsheet - it doesn't matter how it displays. The column for Alabama (AL) must transfer licensing data to the other spreadsheet's AL tab, and so on.
It also doesn't matter which worksheet requires user input - if it's easier to input into the tabbed worksheet and have the state columns in the other worksheet capture the data from its applicable tab, that's fine too (and I'm playing around with it). Whatever works - the only stipulation is that the user must input into one worksheet, not two.
Thank you!!
|