+ Reply to Thread
Results 1 to 5 of 5

Guidance On How To Create A Worksheet Based Upon Calculations From Another

  1. #1
    Registered User
    Join Date
    11-28-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    6

    Guidance On How To Create A Worksheet Based Upon Calculations From Another

    I apologize for the title. I don't know exactly the best way to sumarize what I am attempting. Hopefully I can explain it better.

    I can easily create the FROM sheet from copy/pasting switch output. However, I'd like a complete port listing and thus want to use the FROM sheet to create the TO sheet. Please note row 4 in the FROM sheet and the corresponding row 7 in the TO sheet as in some cases, it's a range of 1.

    Examples below.

    What is the best way to do this? Please explain the reasoning behind the steps as I am a basic Excel newbie.

    Thanks,

    Drew

    Convert FROM This Sheet

    A B C
    1 Switch Begin Port End Port
    2 CL-First-Floor-Pavillion-Sw ge-0/0/1 ge-0/0/3
    3 CL-First-Floor-Pavillion-Sw ge-0/0/39 ge-0/0/41
    4 CL-First-Floor-Pavillion-Sw ge-7/0/0 ge-7/0/0

    Convert TO This Sheet

    A B
    1 Switch Port
    2 CL-First-Floor-Pavillion-Sw ge-0/0/1
    3 CL-First-Floor-Pavillion-Sw ge-0/0/2
    3 CL-First-Floor-Pavillion-Sw ge-0/0/3
    4 CL-First-Floor-Pavillion-Sw ge-0/0/39
    5 CL-First-Floor-Pavillion-Sw ge-0/0/40
    6 CL-First-Floor-Pavillion-Sw ge-0/0/41
    7 CL-First-Floor-Pavillion-Sw ge-7/0/0

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Guidance On How To Create A Worksheet Based Upon Calculations From Another

    Please Login or Register  to view this content.
    This macro will perform what you want. Please run the macro.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    11-28-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    6

    Re: Guidance On How To Create A Worksheet Based Upon Calculations From Another

    Thank you very much. I will mark this solved for now and test with the macro.

    Cheers,

    Drew

  4. #4
    Registered User
    Join Date
    11-28-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    6

    Re: Guidance On How To Create A Worksheet Based Upon Calculations From Another

    I have tested and it works great! Thanks again!!!

  5. #5
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Guidance On How To Create A Worksheet Based Upon Calculations From Another

    Any time. You are welcome

+ 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. Replies: 7
    Last Post: 11-30-2018, 05:06 PM
  2. Replies: 1
    Last Post: 03-15-2017, 09:44 AM
  3. Create a four-column sorting table that updates based on calculations.
    By arwebb0264 in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 04-13-2016, 03:38 PM
  4. [SOLVED] Private Variables: what are they good for (In VBA)? Non-technical/exp.-based guidance req.
    By joe31623 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-05-2016, 09:19 PM
  5. Create a Userform to Perform this Function - Guidance Please
    By TheScott in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-02-2015, 01:32 PM
  6. Macros Guidance to create Charts
    By vpanicker in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-16-2012, 10:30 AM
  7. Replies: 2
    Last Post: 03-14-2011, 10:13 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