+ Reply to Thread
Results 1 to 3 of 3

expand range C107-C109 to C105, C107, C108, C109.

  1. 11-01-2023, 03:08 PM #1
    CReyFlex
    CReyFlex is offline
    Registered User
    Join Date
    11-01-2023
    Location
    Austin Texas
    MS-Off Ver
    Windows 10 Pro Microsoft 365 enterprise
    Posts
    1

    Question expand range C107-C109 to C105, C107, C108, C109.

    keeping hitting a problem with Build Materials.

    need to expand shorted range to include all part number.

    C105, C107-C109 should look like C105, C107, C108, C109.

    sorry may be using wrong term for expanding number C107-C109.

    windows 10 Microsoft 360 enterprise

    750-000279_sample.csv
    Last edited by CReyFlex; 11-02-2023 at 11:46 AM. Reason: attach example
    Reply With QuoteRegister To Reply
  2. 11-01-2023, 04:16 PM #2
    alansidman
    alansidman is online now
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,895

    Re: expand range C107-C109 to C105, C107, C108, C109.

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  3. 11-01-2023, 04:37 PM #3
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,466

    Re: expand range C107-C109 to C105, C107, C108, C109.

    And pleas edit your profile to include your Excel version, not your version of Windows.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Power Query: Expand Table Contents - Columns not showing in the expand options
    By learning new things in forum Excel General
    Replies: 3
    Last Post: 04-25-2020, 09:46 AM
  2. Expand the name range by inserting the blank row at the bottom of the name range. by vba
    By vithanalas in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-28-2019, 12:32 PM
  3. Expand range of offset/indirect formula to expand to entire range
    By bursuc619 in forum Excel General
    Replies: 6
    Last Post: 11-13-2018, 04:54 AM
  4. [SOLVED] SUMIF formula with dynamic column range and then expand the width of SUM range
    By gravythief in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-26-2017, 08:36 AM
  5. [SOLVED] Expand a range when you click any cell in the last line of the range
    By Dickie Dunkin in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-17-2016, 03:32 PM
  6. Expand a Range non VB
    By starbwoy in forum Excel General
    Replies: 3
    Last Post: 03-27-2008, 12:17 PM
  7. Cannot Expand Named Range - when size of the Range exceeds
    By Snig in forum Excel General
    Replies: 1
    Last Post: 07-07-2005, 09:05 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1