Hi I dont usually use big formulas so am a bit lost trying to find a solution to this request. I dont even know if it is doable. Any pointers to help much appreciated.
If Sheet1!G2:G says "save" Then lookup the Value that row in column A , then look up Sheet2! B2:B for the same value select...
Hi, How are you getting your data onto the contact sheet. If you were using a "user form" you could update both sheets at once with vba. Otherwise you could use formulas on the second sheet. Will the data always be in the same format?