Search results for query: *

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

PERFECT! Thank you!

I have a spreadsheet that looks like this with about 200 projects. Proj No. Budget No. Months Jan Feb Mar...etc 1111.11 $100,000 10 2222.22 $50,000 5 I would like to have excel automatically fill in the rows to the right with the budget by month based on the...

I have text in a cell in one sheet where some of the words are struckout and some are not. (Sheet1/CellA1.) I want the contents and formatting in Sheet2/CellA1 to equal the contents & formatting in Sheet1/A1 and change when the original cell is changed. I can get that to work with an = sign...

IT WORKED! Thank you - Thank you!

We have several project managers that will be inputing the data. What I'm really worried about is having them remember to hide it before they close it. Just trying to automate it so it is idiot proof. We do not want it to get updated on the intranet with the sheet unhidden. We will have...