review

Hello- I have a series of values I need to chart, and several of them have the value >95. Is there a way to show greater than values in a chart? Thank you for your review and help

Morning, I hope someone can help. I have 2 columns. Column A represents a Target Date, Column B represents a Review date. If the review date is within a month of the target date then i would like the review date cell to go green. Also if the review date is 1 month out of the target date i...

Hello, I was wondering if anyone could help? I have designed (along with a friend) a spreadsheet to use for my MA in Education. I have come to my new school to use it and the dates aren't working properly. If you click on Year 11 Tab, then I put a previous date in and the review dates work...

I have a list of names, last name in column A and first name in column B and a date in column C. When the date in column C is a year old my macro copies the name from A and B in the same row to cells I and J. It then looks for any names in I and J and sends an email out to remind me that the...

I have a sheet where I want to flag 60, 90 and 120 days reviews based on an effective date and Calendar dates, but the formula I have is not working. Here is what I have: <tbody> A B C D E F 1 Customer Effective Date 11/1/2017 12/1/2017 1/1/2018 2 B. Smith 9/1/2017 </tbody> Here is...

Hello Friends, I would like to reference the name I give worksheet in a formula. The Situation: I am creating a weekly review chart for a dynamic sales availability: how much of each product we are projecting available for sale in the next 18 months. The Availability is generated in a...

I have a field called R_Cost when the cost change I what to requery the subform. Private Sub R_Cost_AfterUpdate() Forms![Food Show - Review All]![Food Show subform]![Cost Review Subform - Review All].Form.Requery End Sub This is not working?

I'm trying to write a code into VBA for Index Match and I can't seem to get it to work. I also can't figure out how to attach files or print screens so hopefully the information that I provide is sufficient. I used Name Manager to identify all information in Column A as Reviews; Column B as...

I have a transaction table that contains transactions by date with a many-to-one relationship to a calendar table. On said transaction table I also have a column for review date in which is the date the transaction was reviewed. I added a Calculated Column that is a review counter (puts a "1" in...

Hi All, I have an info sheet, which looks something like this <colgroup><col span="7"></colgroup><tbody> USE CASE OUTPUT 1 OUTPUT 2 OUTPUT 3 OUTPUT 4 OUTPUT 5 OUTPUT 6 User 1 Plan 1 Check 1 Review 1 Prototype Test 1 Communicate User 2 Plan 2 Check 2 Review 2 Type A Test 2 Review User 3...

I would like to create a fillable form in word where after inputting the data and clicking on submit the file is saved in a location with the name of the file as the name which we input there and an email is sent to a group of individual for notification purpose. Eg: First Name Rohit Last...

I'm stuck with a request from my boss that wants a line graph for some Documents used for training. Right now I have the documents sitting in Folders Named Approved, Draft for Review, and Ready for Review I'm wondering how to effectively display the data that will show progress. Currently, I...

I have 2 columns of Data, G8 and H8. I am trying to say if G8 > 25% than Supply Review or if H8 > 100% than Demand Review, or if G8 is >25% AND H8 >100% then "Demand and Supply Review", Else "No review Needed" and can't seem to capture the whole formula. Please help =IF(H8>100%,"Demand...

New to VBA, the following code works perfectly, however I would like to condense the copy section using a loop, but not sure how to go about it; I'm learning so any other tips on improving it will be well received; researched on here for well over a day, but have ended up confusing myself...

Looking at purchasing "Professional Excel Development" by Bullen, Bovey and Green. Curious if you all know how this book lines up with some other ones out there. I do a lot with SQL, Oracle Databases, Live Connections, looking at learning some Silverlight and ASP Net, as well as custom...

I have a large list box allowing muliple selections that I would like a user to be able to use to build a small record set. How do I build an interface that allows the user to see what selections they have made and make any adds or deletions to that record set before final submission (using...