Results 1 to 4 of 4

VBA to copy cells from one worksheet to another on user input

Threaded View

  1. #1
    Registered User
    Join Date
    10-07-2014
    Location
    scotland
    MS-Off Ver
    2010
    Posts
    3

    Question VBA to copy cells from one worksheet to another on user input

    Hi all,

    Help on this task would be so much appreciated.

    I am creating a staff planner. I need to copy a range of cells from one worksheet, to another, based on a user input.

    Scenario - on "front" worksheet, manager will identify how many staff will be available and input number into C3. This will then copy corresponding range of cells from "template" worksheet and paste into the "Monday" worksheet, from B4

    Depending on the heading of the column in "template" (along row 2), will have to match the staff available value on the "front" page.

    For simplicity i'm keeping with 3 staff just now, but this could be as much as 30 if this can be worked out.

    I've attached a copy of scenario to show what I want to work with.

    Thanks for taking the time to read this
    Attached Files Attached Files
    Last edited by angelus430; 10-26-2014 at 07:08 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy cells to a worksheet that is user selected.
    By brent_milne in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-05-2013, 05:28 PM
  2. [SOLVED] In copy/pasting cells to a new sheet cannot automate cells (1, x) based on user input
    By CEDarnell in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-05-2012, 06:08 PM
  3. Need to copy specific cells into an existing worksheet based on date entered by user
    By jrfleury in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-17-2011, 09:44 AM
  4. Copy/Paste user input info into another worksheet
    By MarkExcelMark in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-13-2011, 04:18 PM
  5. macro to copy cells based on user input
    By pankaj2145 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-03-2009, 04:54 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