Plze Help to write a Macro

[Hyberlevan]

Hi all,

Plz help me to make changable cells in Excel.
For example I have 2 sheets. On the first sheet I have code with data beside it. this code is changebale and also the data.
On the second sheet I have a table full with different codes with no data for the begining. I want something which will find the code on the second sheet from the first one (like vlookup) and paste the data beside it. but when I change the code on the first sheet it should find the second code on the second sheet and also not to loose the data pasted when it found the first one.

So I want something which will update the info on second sheet every time I select different codes and edit it on first one and it should also keep the data which is no longer displayed on the first sheet.

I know I explained it hard but I think it is easy to make when you know VBA well....

so to be more clear please see attached image and evereything is explained there.

http://img12.imageshack.us/i/123ms.jpg/#



Waiting for your posts...

 

[hiker95]

Hyberlevan,

Welcome to the MrExcel forum.


You are posting a picture. This means that if this was a problem where one needed to use your data, anyone trying to help you would have to enter the data manually. That makes no sense and I doubt that you would get any answer.


What version of Excel are you using?

You will generally get much more help (and faster) in this forum if you can post your small samples directly in the forum.

To attach screenshots, see below in my Signature block: Post a screen shot with one of these:

If you are not able to give us screenshots, see below in my Signature block: You can upload your workbook to Box Net

 

[Hyberlevan]

Thanks a lot
I figured it out myself.

with a litlebit different way but it works perfectly