Results 1 to 3 of 3

Changing two or more data points in one cell using Autofill

Threaded View

  1. #1
    Registered User
    Join Date
    09-05-2020
    Location
    India
    MS-Off Ver
    2000
    Posts
    1

    Changing two or more data points in one cell using Autofill

    I am new here as well as with the MS excel. How can I use the auto-fill function for changing the different values in ONE CELL.

    For example, the data is

    Vintage 80th birthday shirt - September 1940 Shirt - 80 Years Old Birthday Gift
    Vintage 79th birthday shirt - September 1941 Shirt - 79 Years Old Birthday Gift
    Vintage 78th birthday shirt - September 1942 Shirt - 78 Years Old Birthday Gift
    Vintage 77th birthday shirt - September 1943 Shirt - 77 Years Old Birthday Gift
    Vintage 76th birthday shirt - September 1940 Shirt - 76 Years Old Birthday Gift

    I want to automatically change the 80th, 1940 and 80. Hope you guys understand and help me save hours of work on a daily basis.
    I have uploaded an image also for your reference. I tried but it's not working. I saw many videos but no one talks about that. I may be missing something. Hope you guide me.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Line Graph with Changing Data Points (Text Boxes)
    By JPRICH16 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-03-2019, 06:29 PM
  2. [SOLVED] Changing which cell a formula points to automatically??
    By heytherejem in forum Excel General
    Replies: 5
    Last Post: 07-07-2017, 03:33 PM
  3. [SOLVED] Username to autofill in when changing data on row
    By JDobbsy1987 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-12-2017, 08:50 PM
  4. Color chart data points/marker points vba error
    By nmckever in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-12-2014, 07:10 AM
  5. Calculating Slope and Intercept with a changing number of data points
    By WE5T in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-10-2013, 05:48 AM
  6. [SOLVED] Autofill with changing data
    By Mags in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-09-2005, 06:05 PM
  7. [SOLVED] cell height changing when using autofill
    By WSCI-Nathan in forum Excel General
    Replies: 1
    Last Post: 01-17-2005, 08:06 PM

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