auto-fill

  1. D

    Auto-fill

    I have a dropdown list on sheet 1 , the data is on sheet 2. is there a way of making the list autofill?
  2. J

    Date/Time Auto-Fill & Calculation Errors

    Hello all, I am running into what I believe to be two separate bugs in Microsoft Excel for Office 365 MSO 16.0.10730.20155 64-bit. It seems that Excel does not properly perform calculations or auto-fills properly on time/date data. I'd like to run it by you guys before I jump through the...
  3. C

    Auto-filling Product Information

    I'm hoping someone here can answer this question. What I'm trying to do is set up a worksheet with product information (barcode number, item description, and unit price) to use as a databse and then set up a separate worksheet with invoice information (invoice number, product code, item...
  4. G

    Auto-fill problems

    Hi! I'm having problems with auto-filling some complex formulas. Example : --------------------------------------------------------------------------------------------------------- =ALS(COUNTCOLOR(Lijst!$A$2;Lijst!P$8:Lijst!Q$8)=2;$A$140...
  5. F

    Trying to modify this 'auto-fill down to the next empty cell' macro to auto-fill sequential numbers instead

    Hi all, I've attached a worksheet with the macro already installed that will auto-fill cell values down through empty cells to the next cell containing data (and so on and so on).. It works great! BUT, I'm now trying to modify it to make it fill empty spaces with sequential numbers. Any help...
  6. G

    Text predictive auto-fill across multiple Sheet tabs on a document

    Hello, when entering repetitive text such as category names, I need the auto-recognition feature to work across multiple Sheet tabs. This is where you start typing the text it into a new cell and it predictively pre-fills it in for you, giving you the chance to press Enter instead of fully...
  7. F

    Excel fill every third row with data from 2nd sheet

    I need help with issue I'm having. I got 2 sheets, 1st sheet is the table I need to fill and 2nd one is the data. In the data part I have column A with employee number and B with names. On the first sheet I have table that I need to fill but table is like this: Blank row Number column + Name...
  8. M

    Multi IF Formula within Single Cell

    Hi, So, I'm creating a gantt chart in google spreadsheets and need to have bars fill in specific colors based on the start date, estimated completion date, todays date, and the tasks progress. In other words, I need the time between the start date and estimated completion date to be gray. As...
  9. K

    Attach Setting to Document, Not Excel Program on Computer

    Hi all, Sorry if this is already out there and I missed it (in which case, please feel free to share the useful link:) ), but I was wondering if there was anyway to tie settings to a shared document. The details are as follows: I have an excel shared on a server with many other people. To...
  10. K

    VBA code to auto-fill input box in excel 2010

    Hi, I have macro I have written that once clicked on from an object pulls certain named tabs from a file, paste them as values, and saves that file outside of the existing workbook they came from. What I am trying to do is auto-fill the input box prompt with a specific naming sequence instead...
  11. D

    Type Mismatch Error and Wrong Order of Output

    I am having two issues with the below working code: It places the last action at the bottom instead of the top. When a user completes an auto-fill selection it kicks out a bug (as if it is getting overloaded with things to report on) [The actual error is a Run-Time Error '13': Type mismatch]...
  12. S

    Excel Auto-Fill Feature and linking Documents

    Project #1 - The Simple One At work we use two main documents that we have to fill out prior to going to a work site. The first form is called " General Work Order Form" and then on that form after we determine the "Scope of work", we choose an appropriate SWMS Form that are two forms that...
  13. S

    Auto-fill todays date when writing

    Hi, I have a spread sheet with "cases" that I use in work to note tasks that I need to do. When I start a new case I would like today's date to auto-fill in a specific column, the purpose is to keep track of when I got that task. Does anyone know how to solve it? All answers are...
  14. R

    Combo Box Auto Fill in Office 2010?

    Hi, I want to create a Auto-fill combo box, when user double clicks a validation cell and starts keying- the cell should be auto-filled. I tried using using the approach discussed in http://www.mrexcel.com/forum/showthread.php?440018-Drop-down-list-auto-fill-capability. It does not work, can...
  15. R

    How to auto populate a worksheet using a reference cell

    I have two spreadsheets, one which contains job data, and the other that is set up as a job sheet form. Currently I link each cell of the form to the appropriate cells in the data sheet, but figure someone here may know a way that I can populate the needed data from the data sheet into the job...
  16. H

    Auto-filling and other cells and inserting blank row when new data entered

    Hi I have a really important issue in a data spreadsheet of mine. I have seen various posts asking related questions but none that have really addressed what I need to accomplish. I have a worksheet (attached) in which I have a set of data (historical returns of 2 things). The month is listed...
  17. dukeofscouts

    Change autoFill direction from down to right?

    After seeing how Bill changed the ENTER key direction from down to right I started to wonder, is there a similar option that will let you change the douple click fill direction from going down, to going to the right? I use the TEXT-COLUMNS feature alot and have to do alot of work of transposing...

Some videos you may like

This Week's Hot Topics

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...
Top