Excel list to note with status and info flow

This project was awarded to binaryromel for $5 USD / hour.

Get free quotes for a project like this
Project Budget
$2 - $8 USD / hour
Total Bids
Project Description

I have an excel sheet with a list of information in one page adn in second page I have liek a note that reasd info in first page.

first page show list second show like a note where information is linked to list in first page.

I want the follwoing feature.

I want when I click in the first page on the id or the row to automaticaly upadat the second page with information related to the row in first page.

Alternative: I can also write in the refrence(id ) in the second page adn it pulls all info from first page into the second page

I prefeer both options.

I also want to be able to search on refrences, names etc .. all types of fields I desire.

2) I also want this feature of fetching information from one page to another page to be possible form one document with a page to antother document with a page.. this might require that I must have open both documetn sbut htis is not a problem.

3) I have a page that has parameters. if the start date has passed EX 3 days the text in cell become yellow (ref info in parmaeter sheet) if it passes more days the cell text changes color.

4) status. I wnat to be abel to use a drop down list related to the types of status I have written into sheet 3 for parameters

when I choose one of the status the background color of the row change color to the related color in parameters.

I have aded a simple example and it is jus to show you concept.

You must alsol explain how I link more fields adn pages, documetns togheter for fhurture so I can adapt this to my need.

I have basic programing understanding.

I expec to make the example takes a few hours for a pro.

Awarded to:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online