| Thread | Last Post | Replies |
|
| How do I insert a picture into a cell? | 21 Jun 2007 00:05 GMT | 1 |
I'm currently working on a database of employees for my supervisor. I'm making individual profiles of employees by using the mail-merge feature in Microsoft word to take the data from the spreadsheet and filter it into word documents. This part is going wonderfully... BUT, my ...
|
| Sharing my macros that I have saved in Personal.xls | 20 Jun 2007 23:29 GMT | 3 |
I would like to share some macros with my co-workers. Presently, I have several that I have saved in the Personal.xls workbook. 1) What is the best way to share these macros with them? 2) I know that the Personal.xls workbook is saved in the XLSTART folder. Do
|
| Chart Display -- fit window or zoomable? | 20 Jun 2007 22:53 GMT | 1 |
I have two spreadsheet workbooks, both created from the same version of excel, both created by yours truly. There is a difference between them that I cannot explain and I cannot migrate from one to the other. In one workbook, (call it "A") I have a chart which is "on a
|
| Link Worksheets Into Master | 20 Jun 2007 22:40 GMT | 5 |
Using Excel 2003 - We have worksheets with tabs called 'Sec 10', 'Sec 11', etc. (up to Sec 61) that are updated by the individuals that work in those sections. We would like to link all of those worksheets into a master that will show all data in each section consolidated into ...
|
| sumproduct | 20 Jun 2007 22:36 GMT | 2 |
My data is like below: A B 1 900180111 50000 2 902180111 20000
|
| SUMPRODUCT | 20 Jun 2007 22:20 GMT | 1 |
My Data is like below: A B 1 900180111 40000 2 902180111 15000
|
| VLOOKUP formula needed | 20 Jun 2007 22:18 GMT | 3 |
Office '03 (Excel), Glass Order! (sheet tab) A1:W1 is my header row. The data range on this worksheet is currently A2:W237. Information is added daily, so the formula will need to have a dynamic range. I would like a formula that does something like the following. If any cell ...
|
| Colors without VBA | 20 Jun 2007 22:07 GMT | 1 |
I'm trying to enter a "1" in a column in which the record is highlighted a certain color. Is there a way to denote records that are highlighted (so I can count, sum etc.) without using VBA?
|
| Complex Formula | 20 Jun 2007 21:46 GMT | 1 |
I need some help. I am trying to create a formula where I reference two different cells in one spreadsheet that are in the same row(this is the critera that I am pulling from on a "Data" page). On a separate tab I need to average the numbers that coincide with the referenced ...
|
| Check box problem | 20 Jun 2007 21:10 GMT | 2 |
I'm using a check box to return a value and that part works OK, but in the cell that the box is in is showing the words True or False behind the box. How do I get rid of this?? Thanks for any help
|
| Excel adds a "1" to filenames opened from desktop shortcut | 20 Jun 2007 21:05 GMT | 4 |
After opening the Excel file from the desktop shortcut and making changes I want to save, I have to backspace over the "1", then do a Save As and navigate to where the file is stored then overwrite to file I originally opened.
|
| Win32 error on mixed office software | 20 Jun 2007 21:05 GMT | 2 |
I have a mixture of office products - Excel, Word, Outlook 2003 - Ppt 2007 (reason is that Dell sent wrong package, without ppt, so sent extra CD but that didn't have Outlook). The only way I can keep PPT and Outlook is to have this mixture, and I really want to use 2003 as it's ...
|
| A Stumper! Format Cell Changes don't take effect | 20 Jun 2007 21:05 GMT | 2 |
I routinely download excel spreadsheets to update a database where I work. Date information as downloaded requires change in format (for example I wish to change "AUG 06, 1956" to "08/06/1956"). I usually highlight the column containing the dates and change format category from ...
|
| Lock formula cells? | 20 Jun 2007 21:04 GMT | 5 |
I'm designing a spreadsheet for my office. Is there a way to prevent my folks from entering in data into cells with formulas? Thanks in advance, Ellen
|
| How do I copy more than 255 characters per cell? | 20 Jun 2007 20:40 GMT | 2 |
Is there a way to copy more than 255 characters in a cell when copying into a new workbook?
|