Excel: Find a specific cell and paste the value from a control cell into it
- by G-Edinburgh
I have two columns one containing the room number, e.g. B-CL102, the other containing a varying integer.
I want to enter a different, manually determined, integer in a third column.
Whether by macro or native Excel, is there a way to use two control cells at the top of the sheet, type the room number into one and the different integer matching…