| Thread | Last Post | Replies |
|
| How save/extract photographs? | 11 Apr 2008 21:22 GMT | 2 |
Someone sent me an Excel spreadsheet with two photographs in it. I would like to remove those photographs, save them as standalone JPG files (or whatever format they are in) How do I save/extract photographs from an Excel Spreadsheet? It's Excel 2002 and Windows XP.
|
| Formula for duplicating info from one cell to another | 11 Apr 2008 21:00 GMT | 5 |
I'd like information that I input into a cell to be automatically output into another cell. So, for example, In one cell I input the following information: HWC65917 P Science / Health & Medical Sciences / Human Anatomy & Physiology / Human Systems / Immune/Lymphatic System / ...
|
| Copy a value | 11 Apr 2008 20:34 GMT | 4 |
Not sure if it can be done: Property management spreadsheet with general ledger. I wish to separately track expenses for each property automatically by extracting from the general ledger. So, my thought is that each row would start with a property code, say
|
| Help with graph please | 11 Apr 2008 20:12 GMT | 2 |
I have in cells A1 -A12 words (eg wages, electricity etc) In cells D1-D12 I have values (numbers) I am trying to get a bar chart where the number is displayed by the vertical bar and at the bottom of each bar it gives the name (eg electricity,wages
|
| Running total from an edited cell | 11 Apr 2008 19:00 GMT | 1 |
I want to keep a running total of inventory as follows: On Hand This Shipment Quan Updated Part # 1 10 5 update this column on each new shipment
|
| COMMAND BUTTON | 11 Apr 2008 18:59 GMT | 1 |
I KNOW THAT THIS IS EXTREMELY BASIS, BUT I'M NEW SO PLEASE FORGIVE ME. BUT....I NEED TO SET UP A COMMAND BUTTON TO MOVE TO A DIFFERENT TAB. HOW DO I DO THAT? I HAVE THE BUTTON, BUT NOT SURE WHAT TO DO AFTER THAT.
|
| Index Function | 11 Apr 2008 18:28 GMT | 4 |
I have posted the file DB Practice.xls, at https://mediafire.com, I beleive that this is a file sharing site unlike the previous site. I think the questions contained in the file explain the problem I am having with the index function. I am trying to retreive the intersecting cell ...
|
| Updating a Running total from a cell | 11 Apr 2008 18:26 GMT | 1 |
Hi, I have an inventory list that I want to update the "On-Hand" field, keep the running total, from an update entry into the "this shipment" field for each inventory item. I will not be adding lines, just updating the "this shipment" cell for each product. I want it to look ...
|
| Merge information from Excel to Access | 11 Apr 2008 18:14 GMT | 2 |
I am currently an english student living in Québec.. Im working for a company who wants me to use access but I am onl familiar with excel. They don`t speak english, and I speak limited french so Im looking t
|
| Follow-up AVERAGEIF question | 11 Apr 2008 17:45 GMT | 2 |
Office Excel 2007 The other day, someone here pointed me to the AVERAGEIF function as a way of averaging a range of cells, but excluding from the computation any cell in the range that had a zero value.
|
| Changing text "A" to a number? | 11 Apr 2008 17:42 GMT | 3 |
In cell A1 I have the either Letter a, b or c. I would like to give them a numerical value of 1, 2 and 3 in the adjacent cell. Can someone post or point me to the formula?
|
| How to fill missing cells in the collumn of dates? | 11 Apr 2008 14:30 GMT | 6 |
I have large set of data. I have two columns for every variable: first consists of dates (from 01.01.2000 to 01.01.2008) and the second column consists of values for every date. The problem is that some dates are missed (for example I have 01.01.2000 and next row is 05.01.2000). ...
|
| How do I remove the "Page 1" watermark from my working copy | 11 Apr 2008 13:33 GMT | 1 |
My working copy has a large gray "Page 1" in the back ground How do I remove this from my working copy
|
| INDEX FUNCTION | 11 Apr 2008 12:51 GMT | 6 |
Can anyone help with the INDEX Function? I want to post a file to freefilehosting.com so others can view the file. Could someone tell me how to post the file?
|
| Formula for a complex count criteria | 11 Apr 2008 11:29 GMT | 8 |
Given a data set like this: A B C D ID 3 Pending date Text ID 1 Closed date Text
|