I am updating billing details in excel 2007, where i have a sheet"Bill Details 2014-2015" in this sheet i have all bill details i.e. party name, Bill no., date, amount. and other sheets i am maintaning party wise details like bill no., date, amount. i want to know that how can i do that i enter detail in my "Bill Details " Sheet and this details autometically update in pary wise sheets. for example i issued bill no. 1 for my party A and bill no. 2 for Party B, when i update details in bill details it automatically update in sheet for A & B. Please advise ;;;; 

VLOOKUP-formula will help you.

Hi Thr123,

According to your description, I agree with Bjoern25. We may use Vlookup formula to automatically update data with two sheets.
For more detail information, please refer to the following link:

https://support.office.com/en-us/article/VLOOKUP-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1?ui=zh-CN&rs=en-US&ad=US

If you have further question, I recommend you share us a sample, we attempt to do it.

Please note: Hide the privacy info.

Regards,

George Zhao
TechNet Community Support