Hi guys.

I kind of stuck here.
What I need to do is: user hits the button on the sheet1 and in the input box selects the row (let's say row no. 6).
then, macro selects specific colums from that row in sheet2.
So, in our example case: cells F6, H6 and AL6 are selected in the sheet2.
then macro copies contents (even empty cell) from sheet2 to sheet 1 - first empty row, cells b, c and d
rows calculated on column b.

the code (non-working now) looks like this:


Please Login or Register  to view this content.
I think I marked the wrong section which is bolded
I just stuck and do not know what function to use :/

please help me how to do this :/