How can i update my data automatically from my master sheet to other sheet
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 ;;;;
March 20th, 2015 8:34am
VLOOKUP-formula will help you.
Free Windows Admin Tool Kit Click here and download it now
March 20th, 2015 10:59am
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:
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 ZhaoTechNet Community Support
March 23rd, 2015 2:43am