Listbox_click action to paste value to sheet

[khhoa]

Hello, I am a beginner at VBA and need your help with this code I been trying to modified.

I need the values on Data sheet B, C, D, E, F, G to be paste in the correct area on Output sheet.

Please Login or Register  to view this content.

I only want the selection to be paste in specific area

Value on B Data Sheet = B8
Value on C Data Sheet = B9
Value on D Data Sheet = B10
Value on E " " Value F Value G Data Sheet = B11
For Mailing Format.

I also need to remove the additional +1 line so when end user select a new click it would just replace the follow selection instead of adding +1



FULL CODE FOR REFERENCES

Please Login or Register  to view this content.

[khhoa]

Was about to solve the problem with:

Sheets("Output").Range("B9").Value = Sheets("Data").Range("D" & CR).Value