While working on sheet i stuck at one place. Can any help me out. Its very urgent.
I have two sheets (Sheet1 and Sheet2) in Sheet1 i copy paste a table from outlook mail.
In second sheet i have a same table with more formatting now what i want is:
A data inside a table in sheet1 should reflect in second sheet on the basis of date, Stream (Case Initiation (EAD-AP/STEM), Forms (EAD-AP/STEM), Names (Vijay, Jaffar, Aniket) criteria.
For Eg: if i input 1 in Case Initiation (EAD-AP/STEM) under Vijay (Production) column Sheet1 a same thing should reflect in sheet2
I hope you got the thing what i want