Results 1 to 17 of 17

create an info input tab to transfer new information into other sheets?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-18-2020
    Location
    Ottawa, ON
    MS-Off Ver
    Professional Plus 2010
    Posts
    139

    Lightbulb create an info input tab to transfer new information into other sheets?

    Hi there,

    I'm not looking for specific coding or anything like that, but rather, I want to know how I should go about creating this. I've created a project management workbook to track all of my projects, each of which include a checklist of things to do.

    It has become quite cumbersome to copy & paste new templates in and input all of the information every time, so I'm wondering if there is a way that I can create a sheet with just one existing template, where I type all the information into and it gets automatically transferred into my project management tab and then the template information subsequently erased so that I can repeat this process again and again?

    Basically I want this tab to:
    1. Copy & Paste new template 2 rows beneath current projects (for visability)
    2. Automatically transfer all data from the input tab
    3. Erase entered data from input tab so that it can be done again and again

    Thanks for any and all help in advance.
    Attached Files Attached Files
    Last edited by Pepe Le Mokko; 02-26-2020 at 11:57 AM. Reason: Shorten title

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Master sheet that can transfer/edit information in other sheets
    By mwinn004mwinn004 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-25-2016, 09:49 PM
  2. Replies: 3
    Last Post: 09-07-2014, 10:31 AM
  3. transfer information from one sheet to multiple sheets if yes entered
    By xoch in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-11-2014, 01:52 AM
  4. Transfer info based on matching sheets
    By ckgeary in forum Excel General
    Replies: 4
    Last Post: 06-15-2013, 09:04 PM
  5. Multi sheets info transfer VBA (Excel 2003)
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-09-2012, 11:38 AM
  6. Replies: 8
    Last Post: 05-01-2009, 12:38 PM
  7. Replies: 4
    Last Post: 02-19-2009, 06:59 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