+ Reply to Thread
Results 1 to 5 of 5

MAcro to move data between sheets

  1. #1
    Forum Contributor
    Join Date
    02-21-2013
    Location
    newcastle
    MS-Off Ver
    2011
    Posts
    111

    MAcro to move data between sheets

    hi guys

    i am looking for a macro that i can assign to a button on (demand sheet "send to list").

    i am after a macro that will move columns contents B7-R7 on every row if the person puts in a number greater then 1 in column Q. to the work sheet LIST

    example

    Sheet demand some one asks for 34 in Q7 and 23 in Q10 then presses the SEND TO LIST button

    this will send all the contents from B7 - r7 and b10 - r10 to sheet List and populate B5 and B6

    hope this makes sense

    thank you for looking
    Attached Files Attached Files
    Last edited by mickgibbons1; 11-09-2013 at 05:53 PM.

  2. #2
    Forum Contributor Steve N.'s Avatar
    Join Date
    12-22-2011
    Location
    USA
    MS-Off Ver
    Excel 2007, 2010
    Posts
    298

    Re: MAcro to move data between sheets

    Does it have to be a macro? Would a pivot table give you the list you need?
    Attached Files Attached Files
    Last edited by Steve N.; 11-09-2013 at 04:28 PM.

  3. #3
    Forum Contributor
    Join Date
    02-21-2013
    Location
    newcastle
    MS-Off Ver
    2011
    Posts
    111

    Re: MAcro to move data between sheets

    Hi steve

    don't know much about pivot table but the main reason i was looking for a macro is then i can add a email macro on to this. so basically press button which will send the information to the second sheet and then i add the auto email macro on as well

  4. #4
    Forum Contributor
    Join Date
    02-21-2013
    Location
    newcastle
    MS-Off Ver
    2011
    Posts
    111

    Re: MAcro to move data between sheets

    Seve

    Sorry i just noticed you uploaded a example. i like it thank you but need a macro to send it to the list so then that list will be linked to a form on the demand sheet later before emailing it on

  5. #5
    Forum Contributor
    Join Date
    02-21-2013
    Location
    newcastle
    MS-Off Ver
    2011
    Posts
    111

    Re: MAcro to move data between sheets

    guys please help if you can,

+ 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. Macro edit to move data to TWO separate sheets
    By dlab85 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-16-2012, 01:00 PM
  2. Help Needed! a macro to move specific data between sheets
    By queenieheart in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-01-2012, 11:28 AM
  3. Move/Cut # Sheets from one WorkBook To Another with a Macro?
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-19-2011, 08:11 AM
  4. Macro to Move Data Between Sheets Based on Columns
    By MSmithson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-24-2011, 09:21 PM
  5. Write macro to move data to new sheets, depending on month
    By kealisa in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-24-2009, 06:51 PM

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