Ok, in that case you will need to use VBA.
AND
you will need to provide much more detail if you want us to assist further !
In the Sheet name called M I need the data to be coped from the sheet named DCBMCOPY
From L6 to AF6 I need to copy data from Sheet DCBMCOPY based on the value of C6.
Presently I am using formula
L6==VLOOKUP($C6,DCBMCOPY!$A1:$V146,2,FALSE)
M6=VLOOKUP($C6,DCBMCOPY!$A1:$V146,3,FALSE)
.... & so on
AF6=VLOOKUP($C6,DCBMCOPY!$A1:$V146,22,FALSE)
& so on upto AF6 but with this I am not able to get the font color of the Vertically looked data.
I need the data to be copied from L6 to AF6 upto L25 to AF25 ( I have formula in L26 & L27)
Again from L28 to AF28 to L47 to AF47 ( I have formula in L48 & L49)
L50 to AF50 to L69 to AF69 ( I have formula in L70 & L71)
L72 to AF72 to L91 to AF91 ( I have formula in L92 & L93)
L94 to AF94 to L113 to AF113 ( I have formula in L114 & L115)
L116 to AF116 to L135 to AF135 ( I have formula in L136 & L137)
L138 to AF138 to L157 to AF157 ( I have formula in L158 & L159)
L160 to AF160 to L179 to AF179 ( I have formula in L180 & L181)
L182 to AF182 to L201 to AF201 ( I have formula in L202 & L203)
L204 to AF204 to L223 to AF223 ( I have formula in L224 & L225)
L226 to AF226 to L245 to AF245 ( I have formula in L227 & L228)...................
& so on Upto L534 to AF534 to L553 to AF553 ( I have formula in L554 & L555)
There are 20 rows in between nd after 20 rows there are two rows filled with formula, In 1st row I am getting the Black font sum total and in the 2nd row I am getting Red colored totals. then from the next row onwards 20 rows need to be copied and so on.. will be continue
in the Sheet DCBMCOPY I have data from A to V, from column B to V the data should be copied over in M sheet based on the value of C6 of M sheet
If the M sheet's C coulmn value will be find on A column of DCBMCOPY sheet then on that row the value from B to V will be copied over from L to AF on M sheet.