kreso
05-17-2016, 04:37 AM
Hi to everybody.
I am using Excel 2013, and I have table with two sheets.
In first one called "data" are my data information, and the second one is the one that is troubling me.
In B column, i have "drop down list" that takes list from "data" sheet.
In C and D columns, i have VLOOKUP function that also takes values from "data" sheet, and is in relation with column B.
I copy C i D columns to E and F, and then hide C and D, and after that i made some VBA code that copies values from C & D to E and F (because I must have values only, not function or formula).
The code goes like this:
Sub copy_paste_values()
'
' copy_paste_values Makronaredba
'
'
Columns("C:D").Select
Selection.Copy
Range("E1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("A1").Select
End Sub
What i want to do is that when I change something in column B, that it automatically change values in E and F columns.
If it can be done without even adding columns E and F, it would be even better.
I hope You understand me, and thanks in advance.
I am using Excel 2013, and I have table with two sheets.
In first one called "data" are my data information, and the second one is the one that is troubling me.
In B column, i have "drop down list" that takes list from "data" sheet.
In C and D columns, i have VLOOKUP function that also takes values from "data" sheet, and is in relation with column B.
I copy C i D columns to E and F, and then hide C and D, and after that i made some VBA code that copies values from C & D to E and F (because I must have values only, not function or formula).
The code goes like this:
Sub copy_paste_values()
'
' copy_paste_values Makronaredba
'
'
Columns("C:D").Select
Selection.Copy
Range("E1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("A1").Select
End Sub
What i want to do is that when I change something in column B, that it automatically change values in E and F columns.
If it can be done without even adding columns E and F, it would be even better.
I hope You understand me, and thanks in advance.