kumar lama
Board Regular
- Joined
- May 20, 2014
- Messages
- 85
Hello,
My master workbook(master data sheet) Column A has S.No. But this S.No Has break In middle, like A3= "AAAA" then from A4 Start S.No
like A4 = 1, A5=2 ,A6=3, A7=4, A8=5 ,A9=6 ......And again A10= "BBBB" and start S. No. Like A11=1,A12=2,A13=3,A14=4, A15=5........
Basicly AAAA & BBBB is a group, when person join for AAAA group i have to insert Row in last of AAAA. same in BBBB & CCCC also
i have another workbook =Group and every sheet by group AAAA, BBBB, & CCCC and i want update data from master to every sheet. I got S.No. from master sheet but i am unable to get other data, Match is getting Error
I use this formula to get S.No From Master Data
I got S. No like this
=IFERROR(IF(OFFSET('Master Data'!$A$3,1+C2,0)>0,OFFSET('Master Data'!$A$3,1+C2,0),""),"")
=IFERROR(IF(OFFSET('Master Data'!$A$65,1+C1,0)>0,OFFSET('Master Data'!$A$65,1+C1,0),""),"")
$A$3= AAAA
$A$65=BBBB
But i can't get another Date like column B Has ID NO. which i cant use index match for all over worksheet
is there someway to do it?
thank you in advance,
My master workbook(master data sheet) Column A has S.No. But this S.No Has break In middle, like A3= "AAAA" then from A4 Start S.No
like A4 = 1, A5=2 ,A6=3, A7=4, A8=5 ,A9=6 ......And again A10= "BBBB" and start S. No. Like A11=1,A12=2,A13=3,A14=4, A15=5........
Basicly AAAA & BBBB is a group, when person join for AAAA group i have to insert Row in last of AAAA. same in BBBB & CCCC also
i have another workbook =Group and every sheet by group AAAA, BBBB, & CCCC and i want update data from master to every sheet. I got S.No. from master sheet but i am unable to get other data, Match is getting Error
I use this formula to get S.No From Master Data
I got S. No like this
=IFERROR(IF(OFFSET('Master Data'!$A$3,1+C2,0)>0,OFFSET('Master Data'!$A$3,1+C2,0),""),"")
=IFERROR(IF(OFFSET('Master Data'!$A$65,1+C1,0)>0,OFFSET('Master Data'!$A$65,1+C1,0),""),"")
$A$3= AAAA
$A$65=BBBB
But i can't get another Date like column B Has ID NO. which i cant use index match for all over worksheet
is there someway to do it?
thank you in advance,