VBA to autopopulate values

[saurabhlotankar]

Hi everyone,

I am looking for a vba function that will auto populate values based on another cell.

I have attached an excel workbook here. there are some values in column A,B and C column. What I am looking out here is, if I change anything in column A,B or C then It should reflect in column F G and H. I can simply give "=" cell reference but I don't want to use any formula in the file.

Hence I am looking for a VBA function which will realtime change vales in column F G and H based on changes done in A B or C.

Why looking for VBA function specifically is because, values in A B and C will keep on changing and I don't have run a macro everytime. So if if anything changes in A B C it should immediately hv impact in column F G H

At the moment I have given simple "=" reference but I don't want that,

If anyone can help me here then great.

Thanks.

[SjonR]

Try this:

Please Login or Register  to view this content.

or:

Please Login or Register  to view this content.

or:

Please Login or Register  to view this content.

[saurabhlotankar]

Hi SjonR,

Unfortunately it's not working out. I pasted your code in module and changed some values in column A and B but that didn't have any impact in column F and G.

Basically I have removed = reference in column F G and H, that was just to show what exactly I am looking for.

Ideally column F G H will not have anything to start with, As soon as I put any VBA function in backend it should populate vales in F G H


That's what I am looking for.

[SjonR]

In which module did you paste it?

[saurabhlotankar]

Hey SjonR,

Tht's worked perfectly now. I was putting it into wrong module maybe.

Now the next challenge, what if my values in column A B C and deriving from some other cell references.

Basically suppose my raw data is on column L M N, and values in A B C are deriving from column L M N then it is not working out.

If I change anything in column L M N then is is showing effect in column A B C but not in E F G.

You will understand after looking at the attached worksheet.

Please find attached.

[SjonR]

try

Please Login or Register  to view this content.

[saurabhlotankar]

This working perfectly in this workbook. But when I try to do the same thing in another fresh workbook its not working at all.

Just want to know do I need to check any setting in excel, because of which its not working.

Thanks.