Results 1 to 17 of 17

Macro to move contents of cells chosen to predetermined spot on sheet.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-02-2013
    Location
    Houston, TX
    MS-Off Ver
    office 365
    Posts
    638

    Macro to move contents of cells chosen to predetermined spot on sheet.

    I have a sheet that tracks tools along with serial numbers. The sheet is broken down into sections and depending on what section selected to move some info changes. for Example,
    I want to move the Serial Number in Cell 'A13' to to cell 'B50' -
    Then in 'A50' the Type of tool that was which is in 'A12"
    Then in Cell 'C50' the current date is placed.

    everytime you select a serial number and click the macro say Shipped it does that over again but the info goes in row 51 and so on.

    I have attached a sheet so you can get a visual.

    I have already completed the first move so you can see what it looks like,

    As you can see once it moves the contents from cell A13 down to the shipped area it leaves a blank. I would also like for the macro to adjust the rest of data in that column up so there are no empty spaces.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Move rows to another sheet when value is chosen from a drop-down menu in cell
    By Oweineh in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-25-2013, 10:01 AM
  2. Creating an automatic move to another sheet when a specific option is chosen from list
    By morgangallo in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-15-2013, 08:36 AM
  3. [SOLVED] Simple macro to create list of sheet names and the contents of cells A1 & N1 of each sheet
    By atcsmh in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-15-2013, 11:11 AM
  4. [SOLVED] Move rows to another sheet when value is chosen from a drop-down menu in cell
    By tanimytani in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-07-2012, 07:50 AM
  5. Replies: 0
    Last Post: 06-27-2012, 05:58 AM
  6. Replies: 0
    Last Post: 12-21-2010, 05:45 PM
  7. command button to move user to specific spot on different sheet
    By grime in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-13-2006, 03:21 PM
  8. Replies: 1
    Last Post: 07-01-2005, 10:57 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