Andrew5150
New Member
- Joined
- Oct 18, 2017
- Messages
- 4
Sorry if this has been asked before
I've a worksheet (Sheet 2)which contains the following information, but some 900 lines long. This Worksheet can change, which is why I looking for a formulated fix.
On the main worksheet there are far more columns, which I would like to Just input the code from the worksheet 'Sheet 2' above and
in the Code column and have all the other respective columns auto populate. The issue is that the Column configuration is not the same.
I've a worksheet (Sheet 2)which contains the following information, but some 900 lines long. This Worksheet can change, which is why I looking for a formulated fix.
|
On the main worksheet there are far more columns, which I would like to Just input the code from the worksheet 'Sheet 2' above and
in the Code column and have all the other respective columns auto populate. The issue is that the Column configuration is not the same.
Date | Code | Company | Project Name | Manager | Location | POC | Budget | Genre | Alt POC |
DEF456 | |||||||||
GEF789 | |||||||||
ABC123 |