+ Reply to Thread
Results 1 to 6 of 6

Macros to copy from one sheet and paste in another

  1. #1
    Registered User
    Join Date
    02-09-2011
    Location
    Lagos, Nigeria
    MS-Off Ver
    Excel 2003
    Posts
    3

    Macros to copy from one sheet and paste in another

    Hi
    My name is Mamoke
    I am not very good in Writing macro, but i need help.
    I have an excel sheet with data in one sheet(Database), and i want a button in another sheet (weekly), so that when i click on the button, it looks at cell the Week Number (Cell F3 in Weekly), it goes to the first sheet (Database), in Column E (start week) it filter (filters for all the activities that was done in that week number in Database sheet) and then copies all the filtered contents (each row) into the Weekly sheet.
    Can you also help me with a button that clears all the content in the Weekly sheet, so that if i want can repeat the function

    See attached the spreadsheet
    Attached Files Attached Files
    Last edited by Mamoks; 02-06-2014 at 08:38 AM.

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Macros to copy from one sheet and paste in another

    Maybe:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    02-09-2011
    Location
    Lagos, Nigeria
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Macros to copy from one sheet and paste in another

    Thank you very much. This is exactly what i am looking for.
    I had some issues putting the button, but i have solved this now.

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Macros to copy from one sheet and paste in another

    You're welcome. Glad to help out and thanks for the feedback.

  5. #5
    Registered User
    Join Date
    02-09-2011
    Location
    Lagos, Nigeria
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Macros to copy from one sheet and paste in another

    Hi John Davis,
    I have an issues,
    Anytin i click the button, it clears all the formulars in the cells in the Database sheet.
    I have formulars in Column F, that i dont want cleared.
    Is there a way the formular is not cleared.

  6. #6
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Macros to copy from one sheet and paste in another

    Maybe:

    Please Login or Register  to view this content.

+ 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] Copy and paste macros???
    By Marz73 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-31-2012, 10:00 AM
  2. [SOLVED] How to copy & paste using Macros
    By Paul1992 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-16-2012, 09:22 AM
  3. Seach, Copy, select paste location, paste using macros
    By helpdave in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-16-2010, 11:36 PM
  4. Copy and Paste Macros
    By dickives in forum Excel General
    Replies: 0
    Last Post: 01-20-2006, 04:49 PM
  5. Replies: 1
    Last Post: 01-04-2005, 06:06 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