Add a new blank column before A in both the workbooks and use below formula
in cell a2 and fill it down
IF(B2<>"",B2&C2,LEFT(A1,FIND(C1,A1))&C2)
then use simple vlookup to get the status
Regards
Ashish
On Sat, Oct 20, 2012 at 6:14 PM, Manish Bankoti
wrote:
> Hi,
>
> Please find attached
Here is your code.
Regards
Vasant
On Tue, Jul 27, 2010 at 6:31 PM, NOORAIN ANSARI wrote:
> Dear Experts..
>
> We want to transfer *Total Asset* column(F) in another sheet(Database) on
> daily basis in current date column through *Transfer in Database* Button.
> Please see attached file..
>
> --
Dear Experts..
We want to transfer *Total Asset* column(F) in another sheet(Database) on
daily basis in current date column through *Transfer in Database* Button.
Please see attached file..
--
With thanks & regards,
Noorain Ansari
--
