I think that is what I need. Would it be simpler to list the QTY on the log sheet on the top for each SKU# like I sort of had before and pull it over to the report sheet? I am just thinking out loud here.

Hi,

Just got back. But, can not stay on line for long.
For what you had before you still had to enter the data manually.
I'm looking at getting the sku from you email sheet. Also I'm going to add another userform so that you can select the sku, then select the date and select the rest depending what you need. When the selection is done you can modifiy the information if need be.
Also the for will allow you to add data to the log sheet. If this is ok I'll get started.
It will take some time as too I have to do this in my spare time.

Charles, I can't thank you enough and I think this is exactly what I am looking for. I am eager to see what will work. Thank you again.

HI,

I'm still working on your project. It's been hectic around here.

Thanks for the update. I fully understand, especially with the end of the year/month approaching. My job has been beyond demanding. Thanks again. -Lonnie

Hi,

I did not work on the "Report".
I adde a button for "Modify and New". I only have the "Modify" coded. I do not have the "Add" coded yet.
I thought I' let you see what I have so far.
When you open the file click the "Add?Modify" button.
For test select a "Sku" from the dropdown. the select the Store, date, BGSC, and Account.
You can then click the "View" button. If your selection is not matched it will produce a msg saying you need to verify. If all goes well the data for the selection will appear in the text boxes in the form.
You can make any change in the text box and the click the "Modify" button the will correct the information in you file. There is also a "Exit" button for you to click which will unload the form.

I'm off for now test and let me know.

Attached Files

2016 test_NAT Reship Log-2.xlsm (65.6 KB, 8 views)

This will work perfectly for adding/modifying the data. I am just curious how adding new SKU numbers, Store numbers and Dates will work. This is coming along perfectly and once again thank you for your work.

Hi,

I'll have Add sku tomorrow. Still Hectic here..

Hi,

I was able to get this in.
You will a "Option" button next to the add Button. Before you add sku's you need to select the Option button.
After you select it you can now add the sku's to the Log sheet. After you enter the info you can then select the "Add" button. This should add the New information to the next empty row.

Attached Files

2016 test_NAT Reship Log-2-1.xlsm (59.8 KB, 6 views)