| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Very Urgent VBA Procedure
I have 2 files:
1 - I have to look up the value of row C3 - to populate row D3 in file Workbook(Billable Jobs)Sheet(Header-Partners)- in file VBAP row D3 if and only if C3 in file VBAP is: SP 2 I have to look up the value of C3 - to populate row J3 in file Workbook(Billable Jobs)Sheet(Header-Partners)- in file VBAP row D3 if and only if C3 in file VBAP is: PY File Workbook(Billable Jobs)Sheet(Header-Partners) C D J 10000000 10000001 File VBPA A B C D 10000000 0 SP 10000073 10000000 0 BP 10000073 10000000 0 PY 30000031 10000000 0 SH 10000073 10000000 0 ZA 10000000 0 ZD 10000000 0 ZP 10000000 0 ZU 30000031 10000000 0 ZV 30000031 10000000 0 ZW 10000073 10000000 0 ZX 20000002 10000000 0 ZY 20000001 10000000 0 ZZ 20000000 10000000 10 ZC 10000000 20 ZC 10000001 0 SP 10000073 10000001 0 BP 10000073 10000001 0 PY 30000031 10000001 0 SH 10000073 10000001 0 ZA 10000001 0 ZD 10000001 0 ZP 10000001 0 ZU 30000031 10000001 0 ZV 30000031 10000001 0 ZW 10000073 10000001 0 ZX 20000002 10000001 0 ZY 20000001 10000001 0 ZZ 20000000 10000001 10 ZC 10000001 20 ZC Regards, Jeff |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shared Workbook Problem, Urgent | Excel Discussion (Misc queries) | |||
| execute stored procedure from excel | Excel Worksheet Functions | |||
| Urgent Urgent Urgent!!! | Excel Discussion (Misc queries) | |||
| Fonts get size 1 and can't be changed after a procedure - even by excel GUI!! | Charts and Charting in Excel | |||
| How can I reference a procedure in an Add In? | Excel Discussion (Misc queries) | |||
Linear Mode
