Sheet1
A & |B|
Sheet2
A & |B| & C
sheet3
A & B & C
copy sheet 2 data as it is in sheet3 if column "B" matches in sheet1 & Sheet2
Note here i will enter duplicate values it column "B" in sheet1 & Sheet2
so it should not copy again n again in sheet3 it should copy only once.
Project flow:-
1] Enter the Items like Egg,Eggs, Steak,Lamb Steak,Tenderlion,Porterhouse, Steak & Eggs
in column B2 hit Tab it will give Egg Mod in column "J"
2] As soon as its shows Egg Mod in column "J"
3] Sheet2 show show data from A2 to C7
------------------------------------------------
1] Same goes with steak mode
Enter the Items like Steak,Lamb Steak,Tenderlion,Porterhouse, Steak & Eggs
in column B2 hit Tab it will give Steak Mod in column "J"
2] As soon as its shows Steak Mod in column "J"
3] Sheet2 show show data from A8 to C13
----------------------------------------------
Now catch column in sheet2 are not fixed so if there is another information
it should paste below that columns
----------------------------------------------
Also run my project (Macro) and let me know where i am wrong and where can i improve
Bookmarks