macro req for excel calcultion from two sheets

[ushaanu]

i have one excel file in this file two sheets 1-revenue sheet and 2nd Cost .in re 1st sheet Sr no and amount mention but some sr no 3 to 4 amount filed and the same case in sheet 2 (cost sheet)
now i neeed 3 sheet Gm where i need Gross margin Sr No wise for ref pls find the attached file
thanks
Anu

 

[Smallman]

Ushaanu

File attached should be the answer you require.

Take care

Smallman

 

[ushaanu]

hi Small man ,

thanks it`s woking , but i need one more thing in Gm Sheet sr No automaclly copy acording to revenue file .

regards
Anu

 

[sgmpatnaik]

@Anu

you can use the below formula in GM Tab for getting the list of Sr. No. from Revenue Tab

A2: =IFERROR(INDEX(Sr_No,MATCH(0,COUNTIF(A$1:$A1,Sr_No)+IF(COUNTIF(Sr_No,Sr_No)>1,0,1),0)),"")

enter with array Formula as Ctrl+Shift+Enter

Sr_No is named range

hope it's solve other wise please inform

Thanks

SP