M Mohandas Member May 19, 2016 #1 I need populate the data from lactogen1,lactogen2 to praveen sheet Attachments Book1.xlsb 152.8 KB · Views: 4
Ashhu Active Member May 19, 2016 #2 Which Details you need to Praveens sheet, Can you put values manually in praveen sheet for the sake of example.
Which Details you need to Praveens sheet, Can you put values manually in praveen sheet for the sake of example.
M Mohandas Member May 19, 2016 #3 Mohandas said: I need populate the data from lactogen1,lactogen2 to praveen sheet Click to expand... Attachments Book1.xlsb 153.3 KB · Views: 2
Ashhu Active Member May 19, 2016 #4 Dear Mohan Below is the formula you can put in Praveen sheet. Need few changes to your "Praveen" sheet. first Add name in Cell B1 and Change Date format C3 till N3 and also in Lacto... sheets. See attached. =INDEX(INDIRECT("'"&$B5&"'"&"!B6:AJ33"),MATCH($B$1,INDIRECT("'"&$B5&"'"&"!B6:b33"),0),MATCH(C$3,INDIRECT("'"&$B5&"'"&"!B6:AJ6"),0)) Click to expand... Attachments Book1 (1).xlsb 153.7 KB · Views: 5
Dear Mohan Below is the formula you can put in Praveen sheet. Need few changes to your "Praveen" sheet. first Add name in Cell B1 and Change Date format C3 till N3 and also in Lacto... sheets. See attached. =INDEX(INDIRECT("'"&$B5&"'"&"!B6:AJ33"),MATCH($B$1,INDIRECT("'"&$B5&"'"&"!B6:b33"),0),MATCH(C$3,INDIRECT("'"&$B5&"'"&"!B6:AJ6"),0)) Click to expand...
