Create a master sheet.
Create master list of all names on this sheet.
Now use Vlookup with all sheets and add them.
e.g. In master sheet = Vlookup anmol with sheet A + vlookup anmol with sheet
B + vlookup anmol with sheet C.
On Mon, Mar 29, 2010 at 10:43 AM, L.K.Modi wrote:
> I have workb
I have workbook having many sheets.
In all sheets some common data are there .After that i want to know
the total in all sheets.
Example
in sheet A
Anmol 200Rs.
In sheet B
Anmol 300Rs.
In sheet C
Anmol400 Rs.
I want to know the total of all anmol in one place
Regards
LKModi
--
