| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba to update columns
hello,
in page1 I have this list: LVSNR AL14898725 AL14903075 AL14904364 AL14904710 in page2 this chart: LVSNR AKNUS AKDTA AKTIM AL14898725 852685970 1090129 6 AL14898725 852685970 1090129 220616 AL14898725 852685970 1090130 222827 AL14898725 852685970 1090131 52832 AL14903075 854309220 1090131 1103 AL14904364 854843700 1090130 213509 AL14904364 854843700 1090130 52832 AL14904710 855050800 1090130 23823 i'm lookinf for a formula or function to update the columns next to the list in page1, looking the correspondent at the chart and taking the 4th column value. the data are not univocal in the chart, so CERCA.VERT(excel italian version) is not a right way and neighter automatic filter is right way to solve the question, becous I have about 40.000 of records. I wish the result was this: LVSNR AKTIM1 AKTIM2 AKTIM3 AKTIM4 AL14898725 6 220616 222827 52832 AL14903075 1103 AL14904364 213509 52832 AL14904710 23823 Please help me... a VBA script or a function, thanks a lot to everyone wanna help me. -- BBB |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update total based on two columns | Excel Discussion (Misc queries) | |||
| update columns | Excel Worksheet Functions | |||
| Need a formula to update data in 2 columns | Excel Worksheet Functions | |||
| can I use an update macro on multiple columns | Excel Programming | |||
| Update Only Specific Columns | Excel Programming | |||
Threaded Mode
