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.
14 freelancers are bidding on average $8/hour for this job
Excel Whiz Here ;) I could have quoted 8$ per hour for 4 hours and the price would still come the same :) Can finish this in 1 hour. Please see PMB for more details.
I'm a experienced professional software engineer with MSc in Computer Science and am happy to work for you. For details please check private message. Kind Regards, Jacek Lempart