a | b | c | d | e | f | g | h | i | |||||||||||||||
1 | Number | ||||||||||||||||||||||
2 | Item | ||||||||||||||||||||||
3 | Stock | ||||||||||||||||||||||
4 | Condition | ||||||||||||||||||||||
5 |
<tbody>
</tbody>
a | b | c | d | |
1 | Number | Item | Stock | Condition |
2 | 123456 | Paper Case | 100 | New |
3 | 234123 | Chair | 4 | Used |
<tbody>
</tbody>
Hi my friends it's possible to help me on that issue?
I want to put a code on my button that appears on the Sheet Entrance that when i click appears a msgbox aske me for a number. Then i put the number and click ok, then the code searches on the sheet global for that code and if that number exists copy the interior of the correspondent cell on the column a, b, c and d to the Sheet entrance on the correspondent cells C1, C2, C3, C3. If the number doens't exists appear that info.
Example i click the button on the sheet Entrance and a msgbox appear ask me a number i insert the 234123 and click ok.
The code goes search for that number on A:A and finds on the A3 cell, so it copys the a3 value from Sheet Global to C1 Sheet Entrance, the b3 value from Sheet Global to the c2 Sheet Entrance, the c3 value from Sheet Global to the d3 Sheet Entrance, the d3 value from Sheet Global to the c4Sheet Entrance.
It's possible to give me any ideas to the code?
Regards