One date with different sizes on one line

[Haleem]

I have a code http://sdrv.ms/19vCK2t . when I am entry data from cell c2:d5 in stock sheet start line # or row # 11 . its fine whenever I enter any size with date its appear in new line but I need if one date has one or more sizes . it should appear on one date row instead same date three four lines. Please help me to solve this issue

 

[Haleem]

I tried it , thanks again , can u put it in module like other macro . I tied it to copy in module but its given errorerror. I want to run from button

 

[mumps]

I wrote the macro as a Worksheet_Change event. This means that you don't have to run the macro from a button because it will run automatically when you enter the Weight in cell C5 and then exit the cell. It is much more efficient this way. However, if you still want to run it manually from a button it will have to be modified. Please let me know if that is what you prefer and I will modify the macro.

 

[Haleem]

Please do it with button and put message after. Entering each size it will ask first thanks and happ y new year

 

[mumps]

What message do you want to put in? What do you mean when you say

Entering each size it will ask first

 

[Haleem]

I mean when you select size from d3 , then type in c4 and c5. Here it will display an message " do you need another size to enter?" With yes and no option till i we want to enter. If I use option no it will clear all c2 to c5 clear and exit

 

[mumps]

Haleem, try the attached version. Click here. It still works without a button. Remember to enter C5 last.

 

[Haleem]

Dear thanks very much . Its running fine. But again please do it in button shape

 

[mumps]

Hi Halleem. Click here to download the file. Enter you data and click the button.

 

[Haleem]

Thanks a lot . I need to ask , can I ask you privately the problems