Hi all,
So I have an Excel Worksheet with a data validation drop down. I am trying to have data pasted based on said drop down. The data validation drop down is constantly changing.
Based on the table provided, I need Sheet 2 to populate based on a data validation drop down provided in cell A1 and A2. The thing is, the Data Validation drop down on sheet 2 is changing numbers. So one time it might be 1 and the next time it is used, it might be 500. The numbers in this case are 1 and 45.
Sheet 1
<tbody>
</tbody>
Sheet 2
<tbody>
</tbody>
So If 45 Is chosen on Sheet 2, A1, then The B-D columns from sheet 1 will be pasted into sheet 2's columns. Same goes for 1.
All help is greatly appreciated. I can try to explain more, if it is needed. Thanks in advance.
So I have an Excel Worksheet with a data validation drop down. I am trying to have data pasted based on said drop down. The data validation drop down is constantly changing.
Based on the table provided, I need Sheet 2 to populate based on a data validation drop down provided in cell A1 and A2. The thing is, the Data Validation drop down on sheet 2 is changing numbers. So one time it might be 1 and the next time it is used, it might be 500. The numbers in this case are 1 and 45.
Sheet 1
A | B | C | D | |
1 | Number | Animal | Food | Drink |
2 | 1 | Cat | Dry | Milk |
3 | 45 | Dog | Wet | Water |
<tbody>
</tbody>
Sheet 2
A | B | C | D | |
1 | "Drop Down Here" | Auto Pop | Auto Pop | Auto Pop |
2 | "Drop Down Here" | Auto Pop | Auto Pop | Auto Pop |
<tbody>
</tbody>
So If 45 Is chosen on Sheet 2, A1, then The B-D columns from sheet 1 will be pasted into sheet 2's columns. Same goes for 1.
All help is greatly appreciated. I can try to explain more, if it is needed. Thanks in advance.