CABHUPENDERBHAKUNI
New Member
Dear Chandoo
i have two set of data in an excel sheet one id detailed one and another data below it which is a summary . i had filled in the data in detailed table and also have linked the summary table first product data with the detailed one but when i am dragging the cell to next product summary data it automatically change reference to the next row above but the data i want is after skipping 3 rows . so how can i do the same as if i mannualy do it it is around 600 products
i have two set of data in an excel sheet one id detailed one and another data below it which is a summary . i had filled in the data in detailed table and also have linked the summary table first product data with the detailed one but when i am dragging the cell to next product summary data it automatically change reference to the next row above but the data i want is after skipping 3 rows . so how can i do the same as if i mannualy do it it is around 600 products