Hi please find attached with solution.. I am not sure about the amount to
subtract, please advise again. if you want.
--- On Fri, 3/8/13, Jaz wrote:
From: Jaz
Subject: $$Excel-Macros$$ calculating between two cells in two different sheets.
To: excel-macros@googlegroups.com
Date: Friday, March
Dear Jaz
Please find attached file.
Is it om Please let me know.
Regards
Shrinivas
On Fri, Mar 8, 2013 at 2:30 AM, Jaz wrote:
> Hello all,
> I am wondering if I can be helped in this. I have two sheets 'Main' &
> 'Consumed' B col. of both sheets have Lot ID.
> A macro should be written to see
Hello all,
I am wondering if I can be helped in this. I have two sheets 'Main' &
'Consumed' B col. of both sheets have Lot ID.
A macro should be written to see in Lot qty Cell D2 of sheet consumed,
check its lot ID in B2. Then go to Main sheet and trace the qty of that
lot in that sheet and s
