Useform which search the data of Primary sales and i can enter secondary sales data.

Userform which searches data like Region, Headquarter,Product name, Opening Qty, Purchases, Sales and closing stock
By searching a particular Stockiest name. If not found i can ADD data and opening,Purchase and sales.

And also how to use Tab in userform as my userform is not working with Tab key i need to track secondary sales against primary sales.

Kindly correct my codes. please check the attached sample file for ref.


Thanks,

I hope my query is clear if need more information do let me know

I'm going to reply to this question as your other posts on the same subject are difficult to understand, or lacking in information.

Let me see if I understand. You want to be able to enter NEW sales data, selecting elements from the Stockiest and Distributor sheets, and posting that information to the Main Sheet? And I'm still confused as to what the secondary sales columns have to do with this.

Walk through step by step what you're trying to accomplish and maybe we can help you.

By the way, posting a new thread ever two weeks with the same content is considered quite rude.

Also, begging for help as URGENT and ASAP will generally NOT entice anyone to help you. If you are in such dire need, hire a consultant.

Hello,

Thanks for your reply.

My query is i have Sales data with me which includes Region/HQ/Stockiest Name/Products/Opening/Purchase/Closing...

So by way user form i want to Search Stockiest Name with reference to the Product and and all above fields.

After populating the data i wanted to Enter the Opening/Purchase/Sales and Closing values against the Stockiest and product. If not stockiest found that i can enter fresh secondary data.

Do let me know if you need any more information on the same.

So take a look at this and see if I'm headed in the right direction.

Ok, try this version.

Ok try this one.