• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Getting filled the data from the downloaded file

Mohandas

Member
Dear Sir,


data need to get from channel sheet w7 and brand product x438 to book1 example i have geven from swathi agencies


Please help

Regards

Mohandas
 

Attachments

  • Book1.xlsx
    21.2 KB · Views: 2
  • Copy of CD Wise Total RDBN & Distribution - May 2016 ASM Zone x3A 23495786.xlsx
    566.6 KB · Views: 2
Hi ,

Change the references ; in the formula , you will find the following :

Channel'!$C$7:$EB$7

The highlighted portion is the reference ; for chemists , the row number is 10 ; so the above portion will change to :

Channel'!$C$10:$EB$10

Narayan
 
Back
Top