Data validation from multiple sheets

[feroz_bilal]

IN SHEET 1- DAILY SALES RECORD
IN SHEET 2- ALL TSHIRT SKU'S
IN SHEET 3- ALL JEANS SKU'S

SHEET 1-

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]DATE[/TD]
[TD]SKU[/TD]
[TD]COLOR[/TD]
[TD]QTY[/TD]
[TD]PRICE[/TD]
[TD]PROFIT[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


SHEET 2 AND 3-
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]SKU[/TD]
[TD]COLOR[/TD]
[TD]PRICE[/TD]
[TD]SELLING PRICE[/TD]
[TD]COMMISSION[/TD]
[TD]SHIPPING[/TD]
[TD]VAT @ 5%[/TD]
[TD]PROFIT[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Now WHAT I WANT IS:
1. WHEN I PUT JUST THE SKU IN SHEET 1- COLOR,TODAYS DATE, QTY=1(IF NOT ENTERED MANUALLY), PRICE AND PROFIT SHOULD COME AUTOMATICALLY


2. FETCHING OF THE SKU'S WILL BE FROM SHEET 2 AND SHEET 3(BOTH)
[REMEMBER SKUS,COMMISSION,SHIPPING,PRICE,COLOR,SELLING PRICE WILL BE DIFFERENT ON BOTH THE SHEETS]

NOTE:- IN SHEET 2 AND 3 I WILL ENTER THE DATA MANUALLY, I JUST WANT THE SHEET 1 TO BE FILLED AUTOMATICALLY WHEN WHEN SKU IS ENTERED​

 

[XLRATOR]

Hello,
This is a common task in MS Excel, but you can't use two different data sources to retrieve your prices, this will cause data inconsistency.
Regards.

 

[feroz_bilal]

Hello,
This is a common task in MS Excel, but you can't use two different data sources to retrieve your prices, this will cause data inconsistency.
Regards.

Ok, then can u please tell me how can i use data only from sheet 2

 

[XLRATOR]

Here is one of dozens ways you can do it:
https://dl.dropboxusercontent.com/u/100370669/Sales Demo.xlsm

It is just a quick demo.
Regards.

 

[feroz_bilal]

Here is one of dozens ways you can do it:
https://dl.dropboxusercontent.com/u/100370669/Sales Demo.xlsm

It is just a quick demo.
Regards.

Sir this really worked for me...
Thank you very much....Please tell me how did you do this, so that i can convert my sheet into same format...PLZ SIR.

Regards

 

[XLRATOR]

It's a VBA Project (VBA Stands for Visual basic for Applications) and the application here is MS EXCEL.
In the workbook, there is a bunch of macros,and a Userform.
I believe you need to learn the basics of VBA for Excel to do so, it's a very easy language to learn, there is thousands of tutos in the internet, and the good thing of learning programming VBA is that it opens doors to programming third party software too and go further then.

here is a good link to get started: Excel VBA Tutorial - Easy Excel Macros

Regards.
Karim