Threads Replies Last Post 1369 Pages: <<  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  46  >>   Losing cell formatting as a result of a mail merge I have set up a mail merge which pull figures from an Excel spreadsheet and displays them in a Word document. The figures inputted into the spreadsheet are to two decimal places, though the cell formatting means that they are displayed as being to no decimal places. I want the same rounded figure to appear in my Word files, unfortunately the mail merge is ignoring the formatting and ... 6 21.09.2006 13:39:02 pocket pc excel Is there a way to enter a time stamp in the pocket excel version like in the pc version. CTRL Shift ; When I hit the shift key, the semi colon changes to a colon and just enters the date. I need the time entered for punching in and out. Tried using NOW function and it changes all the dates/times to be the same. Thank you for any help.... 1 21.09.2006 15:42:02 How can I take information in rows and transpose it into columns? I actually looked in the Excel "Help" section and they told me to copy the row I wanted to transpose and then use the "Paste Special" command. A dialog box with all these choices was supposed to come up and I was supposed to select the box "Transpose". The dialog box that came up did not look anything like the one in the "Help" response. It had no choices, no box to click called "Transpo... 2 21.09.2006 15:41:40 Need Help Formatting Pivot Tables I've been working on a spreadsheet to help track my Futures Market Trades but it is very intensive in calculations. So I've been toying with the idea of using Pivot Tables to organize the data better but I am admittantly a novice when it comes to Pivot Tables. So I'm turning here for any help that the forum might be able to offer. You can see what I'm trying to do on my website here at :... 1 21.09.2006 15:39:26 Automatic Refresh I have created a template that has drop down lists. These lists are external data sets from a SQL database. When I protest the worksheet it does not allow the refresh. Second, is there a way for the refresh to be done without the user being prompted?... 2 21.09.2006 15:31:01 Merge rows into one based on value OK, I know there should be an easy way to do this, but... I want/need to automate a process wherein a downloaded worksheet has one or more instances where there are two or more rows of data for a particular quantity. What I need is to total the values of certain columns in those rows for the matching cells and replace the values in (say) the last of the matching rows w/ the sum, then remov... 1 21.09.2006 15:18:03 How do I keep count in an Excel spreadsheet? I have created spreadsheet to keep a detailed track of days travelled. It is basically functional (and very pretty) but I need more from it. Some cell's (representing days) throughout a given month have either a 1 or 1/2. I am looking for a formula that can keep a count every time I put a 1 or 1/2 in these cells - ..but for an entire month...without the =sum formula because it takes t... 2 21.09.2006 15:13:02 IF function won't post cell value Trying to get this to work: IF cell C4=0 then post cell F4 value IF cells C4 and F4 are both 0 then post cell I4's value. =IF(C4=0,F4, IF(C4=0,F4=0,I4)) If C4 is 0 and F4 has a value it will post F4's value but if both C4 and F4 are 0 all it will post in I4 is 0 not I4's value. -- Loren... 3 21.09.2006 15:08:01 Active Cell To Change Formula Is there a formula that returns the address / row / column of the active cell? So i can use this to produce different results based on the active cell. PaulW... 8 21.09.2006 15:03:47 Moving the box So I was trying to use the arrows to move the highlighted box in excel, but instead of moving just the box, it moves the scroll bars on either the side or the bottom depending which arrow I use. How do I make it just move the box, not the scroll bars? Thx -s... 5 21.09.2006 14:57:47 Starting at cell with string in VBA Hi, I want to create a macro that basically looks for a string in a certain cell in column A, and then does some stuff starting in that row. How can I define a variable to equal the row that has that string? So, if I'm looking for the string "Period" in Column A, I want to basically Find "Period" in A, and make the row number equal to myRow. Thanks, Brett ... 3 21.09.2006 14:54:02 Can I sort a source file without disturbing the links? I am setting up several links. I need to sort the source file, but each time I do the destination workbook links are messed up. Each time I sort the links do not change. Is there anyway I can sort the file without disturbing the links? I am using Excel 2003. ... 1 21.09.2006 14:51:02 ROLLING 12 MONTHS PLEASE HELP ME!!!!! I am working with a spreadsheet that has a rolling 12 months of data. a formula WAS CREATED to help make my life easier or so I thought. =SUM(F20+G20+H20)*200000/L20. How I was told to do this was to copy the previous row and insert it in the worksheet then go to columns F20,G20,H20 and L20 to bring them down by one row. However I do this it is going to end up totaling those same numbers... 2 21.09.2006 14:28:07 sumproduct I have a list names, dollar amount and %. I need to calculate the weighted average % for each name, and then rank them in order. Would I use the sumproduct formula? X 100 5.6% Y 200 4.0% Z 300 4.4% X 400 5.0% Z 500 6.0% Z 1000 6.65% X 2000 6.4%... 4 21.09.2006 14:22:57 Excel slow but NOT when connected remotely!! Hi I have a customer that says Excel is really slow, just selecting a cell then clicking Bold takes about 10-15 seconds to do. The strange thing is when I remote desktop to his computer and use Excel it is like lightning. Everything runs fast and as it should. I really can't understand how this could be because I am basically using his PC when I remote desktop to it so how can it work fine fo... 2 21.09.2006 13:55:12 Counting number of cells that make up a sum.. Greetings: Here is my problem, I have a column of numbers (Building areas in sqm). The column will be sorted from highest to lowest. I have a number from a calculation I obtain elsewhere. I need to count the minimum and maximum number of cells in the column that will be add up to be greater than my calculated number. For example: Column A 20000 10000 9000 8000 7000 5000 1... 3 21.09.2006 13:55:02 More than 3 conditional formats Hello! How do I go about getting more than 3 conditional formats?? Why do we have a limit of 3...??! thanks!... 4 21.09.2006 13:52:02 Combo box drop down & worksheet protection I am using VBA code I found on Contextures to enlarge the font size of dropdown lists by replacing them with a combo box upon double-clicking the dropdown cell. The code works great until I protect the worksheet. I have unlocked the dropdown cells and they are not linked to other cells. Any suggestions? The code I'm using came from http://www.contextures.com/xlDataVal11.html... 1 21.09.2006 13:30:02 Importing Data Hi, I know how to import a single file into excel, but is there a way to import multiple files at once? I have ~450 files that i need to combine into one spreadsheet. The files are .csv files. I'd prefer not to have to do those individually if possible. Thanks,... 2 21.09.2006 13:18:17 Printing: how do I amend my print defaults? Having real problems with my print settings: `1) cant use print preview icon 2) When I use file, print then preview will automatically select the WHOLE worksheet for preview instead of 1 sheet ... then if press print it prints the WHOLE worksheet. Thanks... 8 21.09.2006 13:00:02 Cell format with Data Import (date appearing as text) Help! I have a file which I download from an intranet application. For some reason one of the columns that comes in as a date field, is coming through in some cells OK and in others as a text format (this is easily identifiable depending on whether they are justifies to the left or right of the cell). All the dates are valid (not 30th Feb), and my regional setting are fine too. Wha... 4 21.09.2006 12:57:01 Data from CSV to Excel Hi Experts, 1. User has a product, which has feature to export data only into CSV. 2. In Excel, I have written a VB Macro to format the data/generate certain reports. 3. Is there away out to Import/Copy data Programatically using VBMacro from CSV to Excel so my VB Macro will work and generate reports. Thanks in advance... 3 21.09.2006 12:56:25 I have a doubt! Hi to all, It is quite recently I became an addict to this Discussion Board. I am much amazed to see the depth of knowledge in Excel of some adorable persons, who give instant and accurate answers to the queries. But I have a doubt. Why there are no green ticks to their wonderful answers and keeps the question as still unanswered? Or is Microsoft keeping a specific answer for which ... 5 21.09.2006 12:51:16 How can I correct a custom format? I've created a custom format to display a number as 1111 2222 3333 4444. However when I enter in the 16 digits, the 16th turns to 0. Any ideas?... 4 21.09.2006 12:45:07 How to apply same format of referenced cell in Excel Would wish to use more than the maximum of 3 (extendable to a virtual 4...) conditions for conditional formatting for buidling a certain application. Application needs to change the color of a cell, based on its value (need to use at least some 10 different colors). It would be handy by using a drop down list, to use the formats of the cells in the drop-down list, but this doesn't work, ... 1 21.09.2006 12:14:01 1369 Pages: <<  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  46  >>