Forum Discussion
need help populate by drop down list
I need help to populate another sheet using a drop down list and getting data from another sheet. for example: -on sheet 1 column A is called "group 1", column B is "group 2" and column C is "group...
The formula should be below "Group 2" in Sheet1?
here's the exact placement:
-Sheet1
-Group 2 is on H1
-the names are on H4:H617
-Sheet2
-Names is on H7
-the names should show from H8:H620 right?
here's the exact placement:
-Sheet1
-Group 2 is on H1
-the names are on H4:H617
-Sheet2
-Names is on H7
-the names should show from H8:H620 right?
Here are two older examples that I found in my archive.
One is with formulas the other also includes VBA code.
Check it out, maybe it's in the right direction. If not, please just report back.
to understand better here is the file I have been working on.
https://drive.google.com/file/d/14ac7QflVaA9PWrsb6VX5ILG_qk-uhfG2/view?usp=sharing
- Please describe step by step (cell by cell) exactly what you want to do in this file.
- data in 1st sheet shows in 2nd sheet.
example I choose "ADH" in the drop down menu in 2nd sheet all data in "Column" which has "ADH" in 1st sheet shows in 2nd page aligned to the proper item description. I can do it but i have to do single sheet for every single one office. I want to do it from a consolidated sheet like the 1st sheet.