copy cell from one sheet to another with double click

[dodde]

Hello

If i double click in sheet Tilbud EXC2 range BD26:BD999 , the cell from BD26:BJ26 will insert to sheet Tilbud B20 and so on,

[dodde]

Hello

i have this code and try to midify but failed

Please Login or Register  to view this content.

[Sintek]

Upload a sample file with a few expected results...I am sure someone will offer a solution...

[dodde]

Hello

Thanks for answer, i use column AX to doubleclick and i can choose what line i want to copy

look at sheet Tilbud stål how it will look, and Tilbud EXC2 is the source

[Sintek]

Still not sure I understand...If this is not what you are wanting then you need to explain in detail step by step...
i.e. I double click AX45 and then BD45:BJ45 must be copied to ????

Please Login or Register  to view this content.

[dodde]

Hello

Tanks you for answer

If i double click at sheets Tilbud EXC2 AX45 and then BD45:BJ45 will be copied or .Insert in sheets Tilbud stål 2 rows below last line count in column B

i can skip AX46:AX48 and double click AX49 and it will be :inserted 2 rows below last row in column B

all borders and nuberformat will also be copied the way they are

Hope you understand

[dodde]

Hello

i have done some testing now and i seems like we are very close

[dodde]

Hello

Now it seems to work ok, I will try some more on work tomorrow

Please Login or Register  to view this content.

[dodde]

Hello

Now i have tested and it work 100 % like i want

Please Login or Register  to view this content.

[Sintek]

Glad you got it sorted...tx for rep +