+ Reply to Thread
Results 1 to 2 of 2

Entering repeated values

  1. #1
    Registered User
    Join Date
    11-10-2017
    Location
    Portland, OR
    MS-Off Ver
    2003
    Posts
    1

    Entering repeated values

    Hi, I'm a total Excel newbie. I've figured out how to
    set up a worksheet and a few functions. I'm switching from Quickbooks (way to buggy and cumbersome, not to mention support gets cancelled after awhile) to try to set up my checkbook in Excel. I have managed to do it, actually, but I'm wondering if, as in Quickbooks, I can automatically enter entries that repeat each month (monthly gym membership fees, etc).

    Thanks in advance.

    I (try to) remain: Tranqui

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Entering repeated values

    If you start typing something, and that string has been repeated above, excel will try and complete the typing for you.

    Another way would be to use Data validation (dropdowns) so you can just click on what you want.
    If you need help on that, shout and we can give further directions
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] the code is finding repeated values but i need to search values from E column to D
    By baig123 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-14-2014, 01:33 AM
  2. Replies: 1
    Last Post: 10-11-2014, 04:52 AM
  3. [SOLVED] With repeated values in a range, Vlookup only shows adjacent values for the last one
    By fsalina in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-15-2014, 03:19 PM
  4. [SOLVED] Append data to repeated values with a fixed array to be repeated on value change
    By anchuri_chaitanya in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-06-2011, 12:30 AM
  5. create list of unique values from a column with repeated values?
    By Anne Troy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 06:05 AM
  6. [SOLVED] create list of unique values from a column with repeated values?
    By Anne Troy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM
  7. create list of unique values from a column with repeated values?
    By Chad Schaben in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1