Search results for query: *

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...

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...

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...

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

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

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...

I have an excel file with several tabs. We will be uploading this to an intranet site as a read-only file. Data will be entered on the tab named "data". I want that "data" sheet to be hidden when the file is opened on the intranet (as read only), but not hidden when the excel file is opened...

I have a spreadsheet that gets data from an ODBC source. If a date field is blank in the source, it appears as 1/0/1900 in the excel sheet. Is there any way for me to make it appear as a blank cell in the excel sheet instead of 1/0/1900? Also, when I refresh the data it changes the column...

In column A, I used a macro I found on tek-tips to list all of the tab names in the workbook. worked Great!! Next to the name of each sheet in column A I want the contents of cell C66 of that sheet in column B. Col A ColB 1 Sheet1 Contents of C66 from Sheet1 I can create...

I have a file with many sheets. I want to link the subtotals in each indiv sheet into a "summary" sheet. The subtotals are in a column on the individual sheets and must be in rows on the summary sheet. Example: Indiv Sheets would look like this: A 5 B 2 C 7 Summary Sheet should...

I have a column of items numbers in the following text format: W-CA1 W-CA10 W-CA11 W-CA2 W-CA20 I want them to sort so that W-CA2 would come before W-CA10. I was tried to do it through custom formatting (changing W-CA1 to W-CA01), so I can change the whole column at one time. Needless to...

I am trying to create passwords for a list of employees & I want Excel to do it for me. I would like random 4-digit passwords for each employee that use numbers & letters. Is it possible? Thanks. M Jamison

I have created a form with fields that include drop down menus. In one of the drop downs, I have a choice that includes an &. When it prints or is selected on the document the "&" does not show. Anything I can do? Thank you, M Jamison

I would like to enter an "x" in a cell with the click of a mouse and delete the "x" with a second click of a mouse. Like an off/on switch. Is there a way I can do that in Excel 2000? Thank you, Martha

I have a column with information like the following in each cell: BBT01-34 BBT01-35 BBT01-36 I want to remove the "BBT" portion only. I was using the Find/Replace function in this way: Find - BBT Replace - (left blank) Hit Replace all it turns the cell format to date and I get this...

Does anyone know if you can compare the changes between two excel documents. (Compare changes does it in Word)? Thanks. M Jamison

I have been able to color code the font for appointments in the By Category view using the automatic formatting, but the formatting does not follow to the other views. Does anyone know how to (if it's possible) color code appointments by category in the monthly view of the calendar? (When I'm...

Good Morning Excel Gurus - I am creating a form and I am stumped. I hope there is a way I can do this. I want to format the number type in a cell based on the selection (using validation/list) in an adjacent cell. If "Fixed" is selected, then I want the next cell to format as...