How to dynamically fill inn data i first available row in list

[tnuis]

Hello,

Please see my attachement. I want to be able to choose items randomly from the comboboxes that will trigger a copy/paste range into the final white area BUT I want it to paste into the FIRST available ROW in the white Field.

I know how to define and copy/paste a range to a specific ROW only using one ComboBox for each ROW, but thatīs the hard way With a lot of coding. Iīm sure there is a smart function or formula of some kind that can trigger an intelligence for the paste/fill in event to just find the first available EMPTY ROW to paste in within a spesific area (white area). And Iīm open for any ideas, but was thinking of using IF ElseIf statements for Programming the copy/paste events.......

[mehmetcik]

Try this line:-

NextEmptyRow = Selection.SpecialCells(xlCellTypeLastCell).Row + 1

[tnuis]

Hello mehmetcik

I cannot get this to work. Could you please look at this New attachement: Fill in list challange.xlsm

[mehmetcik]

ahh

You don't want the first empty row.

You want the first empty row in a column

This will select the first empty cell below F7.

Please Login or Register  to view this content.

[Sbarro79]

Hi tnuis

Can you try attached file to see, if it works for you? Please bear in mind it's created on your first attachment, so it uses form controls, not ActiveX controls.

[tnuis]

Ok, I believe this will be to complicated to convert into my actual configurator so here the real thing is (without prices offcourse). Sorry for this guys

Configurator.xlsm

So again, what I want is whenever I choose a machine modell from ComboBox1 or machine option from ComboBox 2 I want it to trigger that it automatically fills in the corresponding line from the tables (way to the right in sheet1) into the FIRST empty line C19:L38 (from top and then Down).

mehmetcik With his second solution is the closest. That actually Works when Programming a code in VBA, brilliant , but I was actually hoping to not have to Write that VBA code for all the items that can be chosen in the two ComboBoxes. That will take me days......

I feel a bit stuck here. Also thought of using VLOOKUP but then again I cannot combine that With the "fill into first available line" event that I want so bad.

Who can give me the definitiv solution here? I would appreciate if you put the fix directly into the configurator and then uploaded it again