+ Reply to Thread
Results 1 to 2 of 2

Copying entries to a new sheet automatically.

  1. #1
    Registered User
    Join Date
    06-21-2013
    Location
    Warren, OH
    MS-Off Ver
    Excel 2016
    Posts
    3

    Copying entries to a new sheet automatically.

    I originally posted this on Mr. Excel, but it went cold. I got one reply that simply critiqued my template but offered no advice.

    I'm trying to find a way to automatically populate the Category/Rank per site as unique rows on the Vendor Upload Template Tab by us filling in the Vendor Account Template Tab. Site information on the Vendor Account Template Tab would be populated manually along with the Categories (upon learning what they are). I included some sample data on the Vendor Account Template to simulate how things would be entered. I also manually populated the Vendor Upload Template with what I would want the result to look like. I've tried to do this in formulas that just got way to convoluted. I was trying to do it without VBA. but I'm not sure it's possible. I'm not overly sure this can be done at all.

    I tried to upload a template attachment but it won't clicking on the add attachment icon doesn't do anything. Apparently I haven't posted enough to do that. Seems silly if I need it for help. A template is over on Mr. Excel.

    I appreciate any help.

    Please note that I attempted to list the link to Mr. Excel as asked for in this forum, but again, because I haven't posted enough, I can't. That flies in the face of this forums regulations.

  2. #2
    Registered User
    Join Date
    06-21-2013
    Location
    Warren, OH
    MS-Off Ver
    Excel 2016
    Posts
    3

    Re: Copying entries to a new sheet automatically.

    I might add that I'm reasonably proficient at Excel Formulas and VBA, but every now and then, I can use a push in the right direction.
    Attached Files Attached Files
    Last edited by snoh8r; 11-20-2020 at 04:19 PM.

+ 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] Copying most recent 6 entries with some blanks from previous sheet
    By mikenoel737 in forum Excel General
    Replies: 5
    Last Post: 10-29-2018, 10:29 PM
  2. Replies: 4
    Last Post: 10-11-2016, 06:45 PM
  3. Automatically Update Cell Entries Based on other Sheet
    By civram1982 in forum Excel General
    Replies: 3
    Last Post: 01-07-2016, 06:17 AM
  4. Replies: 3
    Last Post: 08-18-2014, 11:50 AM
  5. Replies: 0
    Last Post: 03-04-2013, 03:25 PM
  6. Automatically add entries to a summary sheet.
    By Michael75 in forum Excel General
    Replies: 1
    Last Post: 07-27-2012, 08:44 PM
  7. Macro for copying combobox entries to another sheet
    By DrPips in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 08-19-2009, 01:35 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1