Column K can contain the string 'Item Cost'. When Column K contains 'Item Cost' I would like to offset to Column U and copy the value from that cell within the same ROW as the string 'Item Cost'.
Pada posting terdahulu kita sudah membahas tentang cara membuat Tombol Simpan VBA Excel menggunakan UserForm VBA Excel. Pada kesempatan ini lanjutannya, jadi masih pake aplikasi yang terdahulu kita rancang, saya akan mencoba menguraikan cara membuat ListBox yang dapat menampilkan data yang telah disimpan. Ikuti langkah-langkah yang saya sajikan ini selangkah demi selangkah.
I can get the code to read and find the value in Column K, but am having a problem with the coping portion of the code for Column U.
Eric King
Eric KingEric King
1 Answer
Seems like you will want to make your destination range dynamic (
Range('D10')
). The code as is will continousely re-write over your value in D10
. Do you maybe want the value to be in Col D on the same row as the target range? If so, swap for
urdearboyurdearboy