+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Parts List and Inventory

  1. #1
    Registered User
    Join Date
    03-19-2012
    Location
    Mobile AL
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question Parts List and Inventory

    Good Day, I have a spreadsheet that I am using for parts inventory. I would like to the parts on a separate worksheet for every change in location.
    I s the re a way to do this without copying and pasting a thousand times? I s there a way to name t6he tabs automatically with the location?

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Parts List and Inventory

    Hello & Welcome to the board,

    Probably worth attaching an example with a before and after!
    HTH
    Regards, Jeff

  3. #3
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Parts List and Inventory

    Hi bamainnola,

    Welcome to the forum.

    Naming sheet name automatically with the location and separating the parts on every change in location are kind of tasks for which a vba (macro) solution is required. Post a sample file for forum to give a quick try. Thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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