Excel automatic sheet - Import

Hi, this is my first post on this forum.

My question;

Im working on a excel sheet and i basically just want some cells to auto fill in some x'es in specific columns of the row, based on a two letter code i fill into the first column.

My plan is to have two sheets in my workbook. One worksheet where i put my two letter codes in the first row, and one template sheet where all the info for the different two letter codes are filled in, and imported into the worksheet.

funktabell.PNG


here is a picture of the template sheet. The two letter code is located in row C.
In my worksheet, when i type for example, RT, in column C, i want the RT row with all the info from the template sheet imported into this row in the worksheet.

How can i do this ? If anyone could help me get going i'd appreciate it.

Thanks.

Hello & welcome to the forum. I can give you a more accurate code if I could see a copy of your actual workbook. But without seeing it you could try this and see if it helps you. This code would need to go into your worksheet vba module. The code assumes your worksheet is called "Sheet1" and your template sheet is called "Sheet2". if I can be of further help just ask.

Please Login or Register  to view this content.

Do you have a mail or something i can send the workbook to? i couldnt upload it here.

appreciate all the help, im new to excel, but have done a lot of C# programming.

You can upload it to mediafire or anywhere u like and just post a dl link here