Hi, ive been a lurker on this site for a while and ive gotten a lot of help from it so thankss for that..
Im new to Macro and VBA somehow ive managed to avoid it all these years (Mostly). but i think i may need to delve in to it to get this done.
maybe someone can help ill try to explain the best i can what im trying to achieve.
i have a hidden worksheet with a lots of data on it.
i have a visible worksheet which is the same layout but with out the data on it
i would like if its possible to learn how to do the following
when i type a code into the first cell on the visible sheet it looks up the code on the hidden sheet and copys the data across a selection of cells in one row and pastes them into the visible sheet.
then i want to be able to type more codes and more cells get copied ive pasted a couple of screen shots to show what i mean
visible sheet (Type \s6a in cell A5 and it copys data from hidden sheet B6:BH)
[Blocked Image: https://i.ibb.co/gvD5Dgs/visible-sheet.png]
thanks for any help that you can provide..