| Thread | Last Post | Replies |
|
| Move a picture with a vba macro | 18 May 2008 05:29 GMT | 9 |
I'm using this code to insert a picture and resize it to the currently selected cell. The problem is that the picture resizes but doesn't center in the selected cell. How can I add this to my code so that picture will center to the selected cell?
|
| sumif within a range | 18 May 2008 05:12 GMT | 1 |
I have used the sumif function to calculate an answer if the data is less than or greater than a certain value, however want to calculte an answer if the data is within a range. Eg. I know how to calculate the following; If value in A1 > than 5 then sum value of A2. I want to ...
|
| orders | 18 May 2008 03:28 GMT | 1 |
how do I make a order from a long list of items eg: a hardware stoe has a long list of products but when making a order and I only select a few items how do you summarise onto 1 sheet?
|
| Why "# # #" in a 'text' field? | 18 May 2008 02:32 GMT | 1 |
Although the field is large enough to accept the words (when I edit (F2) the field, there is plenty of space), when I hit the "Enter" button, the field returns just "# # # # # # # #" Please tell me what's going wrong. (Product is Excel 2003)
|
| Comment orientation? | 18 May 2008 00:35 GMT | 2 |
Excel 2003 Is is it possible to change the orientation of a cell comment? The default has it going to the right which in this case takes it off the screen. Can it be changed to the left?
|
| how to automatically add page breaks? | 18 May 2008 00:04 GMT | 1 |
Is there a way to either write a macro or something else so that each time a certain word appears (total) a page break inserts? It's a long report that I need to print each totaled group on a separate page. It would be great if I could somehow get the page breaks in without ...
|
| Update multiple files | 17 May 2008 22:00 GMT | 1 |
I have a file that is shared between many users simultaneously. Users can only open a read only file. This file is not shared and I have disallowed the saving/overwriting of this file. Users will only be able to use the sheet "USERS" but meanwhile, I'll be
|
| Shading every other row | 17 May 2008 21:31 GMT | 8 |
Any suggestions on how to quickly select every other row OR fill every other row? With large lists I like to color every other row light gray for refrence purposes.
|
| Opening Excel, I get 6 windows that pop up | 17 May 2008 21:05 GMT | 1 |
Using Excel 2002 on XP SPII, HP Pavilion 7850 computer. When I open my excel files, which may have been created in previous versions of excel or in different, I get 6 different excel windows title as: 1 - my filename
|
| Sumproduct count between dates for specific day | 17 May 2008 20:44 GMT | 7 |
I have the following excel database Area Start End Orange 15/05/08 18/05/08 Orange 18/05/08 27/05/08
|
| Excel veri | 17 May 2008 18:45 GMT | 1 |
bir excel sayfasından her gün 100 veya 250 adaet bilgi kopyalıyorum daha sonra kendi excel sayfama kayıt altına alıyorum sonra bana karışık gelmiş olan bu bilgileri tek tek tasnif edip işlemi bitiriyorum yapmak istediğim şey ben web ten veri aldığımda sağ tıklayıp excel ...
|
| Web Query | 17 May 2008 18:07 GMT | 2 |
I have data in 10 columns. In a column I have data related to some codes take an example of routing numbers. Suppose user provided 10 routing number in a specified column.
|
| deleted file - where can i look for it? | 17 May 2008 18:02 GMT | 2 |
I deleted a file and now I need it . Where can I look for it?
|
| Inserting info in a drop down box | 17 May 2008 17:52 GMT | 2 |
I have created a drop down list . the validation data cell and the original values are in different sheets,but on the same wirkbook. If I try to type in new information that is not on the list it will give me an error message "The value you entered is not valid". Is there a way ...
|
| Complex VBA Sumif | 17 May 2008 17:36 GMT | 4 |
I urgently need to create a new table based on the model below. It is possible? Input Table Column A Column B Column C
|