Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VALUES CORRESPONDING FROM SHEET1 / SHEET2
I need a VB script for the next example. (no formula)
In column A1/A4 of Sheet1 i have values, say 1,2,3,4. In column B1/B4 of sheet1 i have values, say A,B,C,D. In column A1/A4 of sheet2 i have the same values as in column A of sheet1 In column B1/B4 of sheet2 i have the values, say AA,BB,CC,DD When i change for example the value "1" in column A of sheet1, i need automaticely the coresponding value from the cel from Column B on sheet2, in column B on sheet1. Thamk you so much |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VALUES CORRESPONDING FROM SHEET1 / SHEET2
Hi
why is a formula no alternative for you (e.g. VLOOKUP)? Otherwise you have to use an event procedure (the worksheet_change event) -----Original Message----- I need a VB script for the next example. (no formula) In column A1/A4 of Sheet1 i have values, say 1,2,3,4. In column B1/B4 of sheet1 i have values, say A,B,C,D. In column A1/A4 of sheet2 i have the same values as in column A of sheet1 In column B1/B4 of sheet2 i have the values, say AA,BB,CC,DD When i change for example the value "1" in column A of sheet1, i need automaticely the coresponding value from the cel from Column B on sheet2, in column B on sheet1. Thamk you so much . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VALUES CORRESPONDING FROM SHEET1 / SHEET2
With Vlookup it has to be a sorted alphabaticly list.
plus the fact that they want it in VB, and no formulas waht so ever on teh sheet -----Original Message----- Hi why is a formula no alternative for you (e.g. VLOOKUP)? Otherwise you have to use an event procedure (the worksheet_change event) -----Original Message----- I need a VB script for the next example. (no formula) In column A1/A4 of Sheet1 i have values, say 1,2,3,4. In column B1/B4 of sheet1 i have values, say A,B,C,D. In column A1/A4 of sheet2 i have the same values as in column A of sheet1 In column B1/B4 of sheet2 i have the values, say AA,BB,CC,DD When i change for example the value "1" in column A of sheet1, i need automaticely the coresponding value from the cel from Column B on sheet2, in column B on sheet1. Thamk you so much . . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VALUES CORRESPONDING FROM SHEET1 / SHEET2
Vlookup doesn't require that the information be sorted if you are looking
for an exact match. -- Regards, Tom Ogilvy wrote in message ... With Vlookup it has to be a sorted alphabaticly list. plus the fact that they want it in VB, and no formulas waht so ever on teh sheet -----Original Message----- Hi why is a formula no alternative for you (e.g. VLOOKUP)? Otherwise you have to use an event procedure (the worksheet_change event) -----Original Message----- I need a VB script for the next example. (no formula) In column A1/A4 of Sheet1 i have values, say 1,2,3,4. In column B1/B4 of sheet1 i have values, say A,B,C,D. In column A1/A4 of sheet2 i have the same values as in column A of sheet1 In column B1/B4 of sheet2 i have the values, say AA,BB,CC,DD When i change for example the value "1" in column A of sheet1, i need automaticely the coresponding value from the cel from Column B on sheet2, in column B on sheet1. Thamk you so much . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy data from sheet2 to sheet1 when sheet2 has variable # of rows | Excel Discussion (Misc queries) | |||
jump to cell in sheet2 when values in sheet1 is true | Excel Discussion (Misc queries) | |||
[=Sheet1!A1] - if i use Column A1 ('Sheet1') / A2 ('Sheet2') | Excel Worksheet Functions | |||
Copy values from Sheet1 to Sheet2 | Excel Discussion (Misc queries) | |||
Moving cell values from sheet2 to sheet1 using UserForms and ListBox | Excel Programming |