phoenix
phoenixPhoenix - Your AI Assistant
Inactive session will be ended in 24 hours
End Session

SPREADHSHEET INDIRECT FORUMLA WITH $

  • Posted:
  • Proposals: 30
  • Remote
  • #4335622
  • PRE-FUNDED
  • Awarded
Dave G.Ahmed G.Adnan Ali A.Obaid U.Dharma Raj K. + 25 others have already sent a proposal.
  • 8

Description

Experience Level: Expert
I have a microsoft spreadsheet with 150 sheets in it labelled by the day and date, all same format just different input figures.

I need to create a master sheet which pulls specific information... about 36 figures from each sheet).

I manually selected by equation what figures I want to pull across for the first day, however I'm unable to duplicate it for the other days.

I've created a spreadsheet which has the names of each of the 150 tabs in it for ease. I've attached an example of the summary sheet. I need to be able to create a pull down so that it automatically completes when the other tabs are filled in.

Kindest Regards,
Dani

New Proposal

Login to your account and send a proposal now to get this project.

Log in

Clarification Board Ask a Question

  • Mahmood U.

    Hi Dani,

    Could you confirm if the 36 figures to be pulled from each sheet are consistently located in the same cells across all 150 sheets?

  • MUHAMMAD R.

    Should the summary sheet update automatically when new sheets are added, or will it only pull data from the existing 150 sheets?
    Do you want a dropdown list to select a specific day, or should the summary sheet display all 150 days at once?
    Are the sheet names formatted consistently (e.g., "DD-MM-YYYY" or "Day Month Year")?