M
mellowe
Vlookup:
I am trying to lookup a value ( SCOTLAND ) on a spreadsheet called (
Data ) in order to populate ceratin cells on my other spreadsheet (
Spreadone ).
If the value (SCOTLAND) is located in (Data) I want it to copy the
values of specific cells (not all of them ) from the same row into (
Spreadone ).
So :
CHECK COLUMN N (CLASS) IN SPREADSHEET (DATA) FOR STRING (SCOTLAND)
IF THE STRING = SCOTLAND THEN
IN SPREADSHEET (Spreadone) POPULATE
CELL A7:A25 = ACCOUNT NO (from Data)
CELL B7:B25 = CLIENT (from Data)
CELL C7:C25 = CUSIP (from Data)
CELL D725 = QTY (from Data)
CELL E7:E25 = AMOUNT (from Data)
CELL F7:F25 = CCY (from Data)
CELL G7:G25 = USDEQUIV (from Data)
CELL H7:H25 = AGE (from Data)
CELL I7:I25 = LAST CHANGE (from Data)
A B C D E F
G H I
ACCOUNT CLIENT CUSIP QTY AMOUNT CCY USDEQUIV AGE Last
change
39100284 EXCEL 999995 13.00 43.00 GBP 9.00
21 3
29330009 EXCEL 12234 10 35.00 GBP 22.00
12 10
Please help as i am trying to write some VB code to do this and am
failing miserably... Thanks
I am trying to lookup a value ( SCOTLAND ) on a spreadsheet called (
Data ) in order to populate ceratin cells on my other spreadsheet (
Spreadone ).
If the value (SCOTLAND) is located in (Data) I want it to copy the
values of specific cells (not all of them ) from the same row into (
Spreadone ).
So :
CHECK COLUMN N (CLASS) IN SPREADSHEET (DATA) FOR STRING (SCOTLAND)
IF THE STRING = SCOTLAND THEN
IN SPREADSHEET (Spreadone) POPULATE
CELL A7:A25 = ACCOUNT NO (from Data)
CELL B7:B25 = CLIENT (from Data)
CELL C7:C25 = CUSIP (from Data)
CELL D725 = QTY (from Data)
CELL E7:E25 = AMOUNT (from Data)
CELL F7:F25 = CCY (from Data)
CELL G7:G25 = USDEQUIV (from Data)
CELL H7:H25 = AGE (from Data)
CELL I7:I25 = LAST CHANGE (from Data)
A B C D E F
G H I
ACCOUNT CLIENT CUSIP QTY AMOUNT CCY USDEQUIV AGE Last
change
39100284 EXCEL 999995 13.00 43.00 GBP 9.00
21 3
29330009 EXCEL 12234 10 35.00 GBP 22.00
12 10
Please help as i am trying to write some VB code to do this and am
failing miserably... Thanks