| Thread | Last Post | Replies |
|
| best way to do it? copy from a sheet to other sheet | 23 Sep 2005 20:53 GMT | 3 |
source cells are: C4, C10, C16,..., C352 all of them have fixed 6 steps away from each other. Now I want to copy them in another sheet within same file but the copy
|
| Cheat Sheet | 23 Sep 2005 20:09 GMT | 4 |
I don't use excel for really complicated things and don't set up sheets frequently but when I do make a sheet I want a quick way to copy and past the formulas that I have used in the past. Since I don't do it very often, is there already a method that you use? Here is an ...
|
| Vlookup over different worksheets | 23 Sep 2005 19:46 GMT | 5 |
I'm trying to do a vlookup from one worksheet to another. How do I specify the right column? My formula so far is =VLOOKUP(D2,'Quad comparson lookup table'!A2:F97,'Quad comparson lookup
|
| Excel Cell + Image | 23 Sep 2005 19:36 GMT | 1 |
I am looking for option of inserting image to excel cell. problem is i have more then 25000 images, manually inserting will take year to do So need solution that works fast...and can show all images at
|
| Setting up to do my accounts (very newbie!) | 23 Sep 2005 19:26 GMT | 3 |
Having done my small business accounts for years in 'book' format I am now moving towards the idea of doing them on the computer. I am fairly new to the technicalities of spreadsheets. It seems to me the neatest way to do my annual accounts is to have
|
| Deleting Non-Duplicate Rows | 23 Sep 2005 19:13 GMT | 1 |
Have done tihs is the past, but can't remember how: Have a sheet with 9500+ rows. Column C contains a storage bin number. Want to delete all rows that DO NOT have a duplicate (trying to resolve items that have a duplicate bin number.) Have sorted the sheet on
|
| Can this be done | 23 Sep 2005 18:59 GMT | 1 |
:confused: I have an array that I wish to interogate to populate some cells, I was just wondering if this is possible. In the examples below, the first one shows that there are 2 in the A row, 1 in the -5 row, 0 in the -20 row, 1 in the -24 row and 2 in the -30 row.
|
| Sorting numbers | 23 Sep 2005 17:45 GMT | 4 |
I receive price updates from me vendors as an email attachment. At times I need to retype the product codes because I am unable to sort or perform a Vlookup. I can even type the same number over the number I was emailed in the same cell and the number will become usable. All ...
|
| tracking customer orders for ad specialty distributror | 23 Sep 2005 17:37 GMT | 4 |
We are an advertising specialty business. We need to track each job/sale from the initial customer request for an item, through to delivery of the product. Including... quotes, art files and artwork design and approval, ordering
|
| help needed with excel 97 | 23 Sep 2005 17:16 GMT | 2 |
I need help with a problem that I'm having. I've got about 300 sheets i my excel workbook. I need to copy the data from cell B5 on ever sheet,into a new sheet. What can I do
|
| excel 97 problem | 23 Sep 2005 17:16 GMT | 1 |
I need help with a problem that I'm having. I've got about 300 sheets i my excel workbook. I need to copy the data from cell B5 on ever sheet,into a new sheet. What can I do
|
| Can you use the Time format without the AM/PM? | 23 Sep 2005 17:11 GMT | 3 |
OK - I am trying to track data that keeps track of how long an event took. For example - a typical data point would be customer hold times on the phone. I would like to track that the Highest Hold time of the day was in this format:
|
| Locking formula | 23 Sep 2005 16:47 GMT | 3 |
How do I lock a cell so that I don't accidentally delete the formula which I created for that particular cell. Regards.
|
| Can't Email Through Excel | 23 Sep 2005 16:45 GMT | 3 |
I'm having an issue with Excel 2000 and the default mail handler. I use Outlook 2000 as my mail client. No problem. Works great. When I am in Excel click "Send to mail recipient", then click "Send this Sheet", it tries to use Outlook Express to send the mail. Since I don't have ...
|
| Editing e-mail address brings up Outlook in Excel cell | 23 Sep 2005 16:34 GMT | 2 |
WindowsXP Excel 2003 A user received an Excel spreadsheet of name and e-mail addresses. When I clicked in the cell that contained the e-mail address it launched a new mail
|