VBA insert data to first empty cell of one column and last used row of another column

[shafiq2]

Hi,

I am looking for a VBA code to insert data which selected in userform to excel from first empty row in column D to lastused row of column A.

for example if I select a name in combobox

the selected name should be inserted in excel in the next empty cell of column D till last used row of column A.

I know how to insert data from userform but i can not figure out how to select the first empty row of column D till last used row of column A.

Best Regards,
Shafiq

 

[Somendra Misra]

Hi Shafiq,

Can you upload a sample file with a userform in it.

Regards,

 

[shafiq2]

Hi Somendra,

Please find the sample file with userform.

Best Regards,
Shafiq

 

[Somendra Misra]

@shafiq2

See the file, I had done for drop down 1. The same can be repeated for the next. But thing is not clear what to do if last rows in D & A are same?

Regards,

 

[shafiq2]

Thank you Somendra it works perfectly, but can you please change the code to paste the data in any empty row in range D. This is because when I run the macro the empty rows can be between used rows.

The lastrow in column A and D is always the same.

Best Regards,
Shafiq

 

[Somendra Misra]

@shafiq2

Do you mean only in D4 & D5 as shown below?



Regards,

 

[shafiq2]

Yes please.

Thanks.

 

[Somendra Misra]

Not sure, but see the file.

Regards,

 

[shafiq2]

Hi Somendra,

The code insert data out of the selected range.

Any other thought?

Regards,

 

[Somendra Misra]

See this file.

Regards,

 

[shafiq2]

It work perfectly. Thank you for the help.

 

[Somendra Misra]

Thanks for the feedback & Welcome back!!!

Regards,