Stationery Record and Monitoring for charge

[yukioh]

Hi, All

how can i get all data sheet (a,b,c) to summl sheet as attached file

please help me...

[rylo]

Hi

Summl!B4: =VLOOKUP(A4,dbase!A:B,2,FALSE)

Copy down as required

rylo

[yukioh]

Thank you rylo
Are there any macro that consolidate data summary item from sheer a,b,c to summl sheet

please help me/....

[yukioh]

Some body plase help
I Try to find other way, but no
please any body help me

[yukioh]

Hi All,
I need to copy all data Item Summary from Sheet A,B and C to Summl Sheet
i have do this by manually and find some data that duplicated then delete it out, it make me crazy
so, it is possible that just one click bottom then do everything to sheet summl ?

[rylo]

Hi

Can do this with formulas

Summl!B4: =VLOOKUP(A4,dbase!A:B,2,FALSE)
L4: =IF(ISNA(VLOOKUP($A4,A!$A:$C,3,FALSE)),"",VLOOKUP($A4,A!$A:$C,3,FALSE))
M4: =IF(ISNA(VLOOKUP($A4,B!$A:$C,3,FALSE)),"",VLOOKUP($A4,B!$A:$C,3,FALSE))
N4: =IF(ISNA(VLOOKUP($A4,'C'!$A:$C,3,FALSE)),"",VLOOKUP($A4,'C'!$A:$C,3,FALSE))

Copy down as required.

rylo

[yukioh]

please help me with macro...

[yukioh]

how should i do