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

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top