• 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.

Automatic excelsheet

jsmithjames03

New Member
Hi friends, I have attached an excel file which have 2 sheets, one is Main data and another is One day. I want to automate the One day datasheet. I need to change the date and the the datasheet needs to be updated. Help to solve this problem.
 

Attachments

  • sample data.xlsx
    22.6 KB · Views: 6
You might try
[B4] = OFFSET('Main Data'!$A$1,ROW()-1,MATCH($B$1,'Main Data'!$1:$1,0)+COLUMN(A1)-2)
Then drag down and across.

EDIT
or non-volatile version (range may grow)
=INDEX('Main Data'!$A$1:INDEX('Main Data'!$1:$1048576,COUNTA('Main Data'!$A:$A),16000),ROW(),MATCH($B$1,'Main Data'!$1:$1,0)+COLUMN()-2)

or fixed range version
=INDEX('Main Data'!$A$1:$EE$15,ROW(),MATCH($B$1,'Main Data'!$1:$1,0)+COLUMN()-2)
 

Attachments

  • sample data_42390.xlsx
    23.6 KB · Views: 7
  • sample data_42390-Non-volatile.xlsx
    23.4 KB · Views: 4
Last edited:
Back
Top