Forum

Any chance to set this formula ?

Sorry, file decrypt for your reference. In short I hope a formula can vlookup the net bal of the code ( in teh dabase worksheet] if Code matc...

The formula exrpessed in a VB code, if possible

Suuny's idea always make Excel user comfortable and easy .. Happy New Year, everyone in the forum keep striving on with enhanced Excel skills...

Thanks Sunny, will have a go what you suggested. In fact we try in XP enviroment before Company logo remains in the Excel attachment, so most lik...

Thanks Sunny! In fact we use this macro for a long time so far no problems ONLY in 2014 about three ago when we change OS[ operating system from X...

Can try to export the VBA script to a bas file then import the bas to the designated Excel file required the VBA

Sunny is a good helper always...

We can enjoy the power of Power Query..

Thanks Sunny the remind..

Allow me Sunny I modified the formula a bit. ie Put a conjunction( two condition ) in the If command to make it more precise.

Sunny, you are superb, armed with this creative idea ie setting the helper column, this really bring us home and can make us early to bed. We cherish ...

Really deep thanks Sunny you take the effort look into the case. Yes we are handling few hundreds Vendors and about hundred Customers in our Group pur...