Summary: Can anyone tell me how to enter 01/001 in a cell and fill down so that the next will be 01/002 and so on. Need help otherwide I need to type it out hu...
Summary: does anyone know a way to fill down to a certain cell w/o dragging. situation: i am in cell a27 and i want to fill a formula that adds .01 to the pr...
Summary: It sounds like wanting to have rownumbers in the A-column, only when B-column is filled, use: =if(B2<>"";A1+1;"") (Copy it in A2 and fill down lik...
Summary: Excel, Help, Contents and Index, vlookup provides a good explanation and provides examples of how the formula is used. Another short method is to clic...
Summary: Hi Jennifer, Yes it is excel, 2000 pro, the format used is Custom and dd-mm-yy. if I select the first of the month, say 01.04.04 and try to fill down ...
Summary: I am using Excel 2007 and I have a question about formulas. I have a long column of cells, *most* of which need to have the same formula in them. Ho...
Summary: I'm thinking the only way to do this is with a User Defined Function. As it turns out, I found one that seems to work. Here's what I did: I put your t...
Summary: What I mean is after I added or deleted some rows off the master sheet (Sheet1). When I checked any of the other sheets, I would get that error (#VALU...
Summary: "I have checked the formula's that are being copied and these are all correct?" Do you mean to say that the formula in row 3 shows as '=0&A3' or as '=...
Summary: NO! You'll lose all you're data. Put the formula in C1 and use the cell reference of the first person. Then, fill down column C. If you don't want/nee...
Summary: Tboy, You can create a new column and use a function to concatenate data to the beginning of the contents in another column. Example: Column A has for...
Summary: Not that I know of. But, one easy way to do this is make a separate column that refers to the column where the data is entered. =sum(data cell*-1) t...
Summary: I am trying to round down a number in a query using Microsoft Access. The number is displaying an age. The number of years is displayed fine but it ha...
Summary: I have a macro that run a vlookup and fills down the column. Some of the cells are returned with #N/A. I am trying to make a loop that will only sel...
Summary: I'm not sure what you want this 3rd file to look like or if you are asking for a new third file to be created every day or if you are updating an exis...
Summary: I'm trying to figure out a way to update a excel file with the changes from a new file. Doing both removing rows and adding rows. I have a master spr...
Summary: The column titled Job Number has 9 sun headings. eg DM DOM underwhich are the job numbers 1001/09, 1002/09 etc followed by DM DOM1 and then a blank ro...
Summary: Would you be willing to try it with a formula instead of VBA? Enter this in rows 1 & 2, and then from now on you can just grab the autofill handle and...
Summary: i have a spreadsheet with a number in a1 the next number is in a15 and so on down the page what i want to do is fill in from a2 - a14 with what is in ...
Summary: When you put in 1.0 in the first cell, put an apostrophe ' before you write the number. This will make excel think it is text. Now when you drag down ...
Summary: OK so i'm pretty new to VBA. I think im nearly there with my macro except for a few things that i'm tearing my hair out! Firstly - I have got a 'stan...
Summary: I write to see if anyone has use or evaluated PF-Merge before, which can auto-fill acrobat forms, without programming. They send me the following info...
Summary: Hi Folks. I am trying to create a sales sheet for an imaginary garage (exercise for a class). I have a number of tables, one named 'Make' which lists ...
Summary: Bryan: So you have the statistics bug too. Trying to prove why you can't win or if you want to play what is the best bet. Many years ago I did the s...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
