I designed an Excel workbook that includes sheets with the following:
1) one sheet with 400+ names and dates of birth,
2) one sheet that calculates and plots Biorhythm data for each name.
The biorhythm data formula is already included. Right now If I choose a name from the list, the formula calculates how many days since birth the person has lived. It also calculates 4 different bio-rhythmic data fields: Physical, Intellectual, Emotional and "Mojo" (mojo is the average of all three). I am also plotting a graph for easier visual of the data.
What I need now is to have a sheet where I can query this information and give me a list of all individuals for TODAY whose PHYSICAL or INTELLECTUAL or EMOTIONAL or MOJO or any combination...reaches a range. For example: "Show me a list of people from the main list whose Physical AND Intellectual is higher than .50"
I need to take it a step further.
1) I want to be able to query this list for different dates for example: Today, Yesterday, Tomorrow or any given date.
2) I want to be able to query: For any chosen name in the list, give me a list of dates within a RANGE of dates where this person meets a given Criteria. For example: "For John Doe, I want to get a list of dates between April 1, 2016 and May 4, 2016 where His Physical or Emotional or Intellectual or "Mojo" or any combination, reaches above .50
This is a very simple project for the right person.
Hello Sir Im excel VBA macro and formula Expert :) i can do anything in excel :) please give me a chance for doing your job and im able to start doing your job right now :) Thank You Sincerely Prameswara
Hello, after I read better your requirements, I agree it is quite simple project. I am proficient with Excel and VBA and I can finish this task for you. Please contact me for more information.
Hi, I have seen your requirement and I understand it completely. Can I have a look at the actual data ? I am good and fast with excel vba. I can be of more help once I see the template.