Writing Macros to find a specific cell and paste the value from a control cell into it

Posted by G-Edinburgh on Super User See other posts from Super User or by G-Edinburgh
Published on 2014-08-21T09:22:48Z Indexed on 2014/08/21 10:23 UTC
Read the original article Hit count: 221

I am having some issues writing a Macro to do the following. I have a very long list of rooms with two columns one containing the room number i.e. B-CL102 and the other containing a varying integer.I am looking to create a new column that will contain another different integer for each of the rooms.

Is there any way to write a Macro so that I can use two control cells at the top of the sheet, type the room number into one and the integer matching that room into another, then run the Macro and it will automatically populate the correct cell. Then I can change the two values in the control cells and run the Macro again and so on.

Thanks for your help, I have a very minimal amount of experience with Macros essentially just the basics.

Thanks

G

© Super User or respective owner

Related posts about microsoft-excel-2007

Related posts about macros