Recent content by MJamison07

Sorry - let me try again. I have a file with a list of tasks with the team members. Simplified version: Dropdown Cell Person 1 Person 2 Person 3 Task 1 R S I Task 2 S R Task 3 R S In the...

I want the macro to start upon the selection from the drop down that is in cell b1 (made through Validation list).

Let me just say that I am not even in macro kindergarten. But with some help from some posts I read & with some macros I recorded, I managed to put together this macro. To my amazement, it worked! I make a selection from a drop down list in cell B1. While I still have B1 selected, I run the...

Thank you all for your responses. Glenn I started with your suggestion. I tested it by selecting a few invoices and used the sum of those as the target. I would enter that target into the solver. Sometimes it worked, sometimes it timed out and returned decimals in the "b" column. There are...

While I will never say never, I am 99% certain this will never happen. What kind of a problem would that create if it did?

I have listing of inv #'s and amounts. Ocassionally, I receive a payment (via direct deposit) without a listing of invoices that are paid. Eventually the client sends the voucher, but sometimes I need to know sooner. Is there a way I can get excel to search the amount column and find the...

This is exactly what I was hoping for....thank you!

Skip, When I replace what I had with your procedure, the tab name doesn't change when I enter info into c6. Thanks.

I have an excel worksheet that contains two macros (which I developed by combining information from several posts on tek-tips - THANK YOU!) 1. to name the sheet based on the value in cell "c6" 2. copy a hidden base sheet (add'l serv) that is run from a button on worksheet. In the base sheet...

I'm trying to create a matrix and thought I might be able to use a pivot table to do it. I have a table with a list of names, their level, their position. With the levels across the top and the postions to the left, I was hoping the pivot table would populate the data area with the names that...

Can data be listed in a pivot table instead of performing a calculation like count or sum? Thanks MJ

Both worked like a charm!!

You guys make it look easy. Sorry I left out important info: I have two ranges where I will use the check box in the cell: C10:C20, E10:E20 THANK YOU THANK YOU!! MJamison

I wrote the following to put a check mark in a cell selected with a mouse. Private Sub Worksheet_SelectionChange(ByVal Target As Range) ActiveCell.Select ActiveCell = Chr(252) End Sub It works, but I encountered some problems: I am not able to select a whole worksheet, row, or column. I...

I recorded a macro that places a check mark in a cell. I want to run that macro with a double click of the mouse on a cell. I would appreciate any help. Thanks. MJamison