+ Reply to Thread
Results 1 to 4 of 4

Macro to copy from one sheet to another, based on a cell in sheet1

  1. #1
    Registered User
    Join Date
    08-30-2012
    Location
    Ottawa
    MS-Off Ver
    Excel 2007
    Posts
    59

    Macro to copy from one sheet to another, based on a cell in sheet1

    Hi folks,
    I hit a roadblock when trying to put together a macro. I've searched, quite extensively, for one or a few macros that would achieve what I am trying to do, but with no luck. I am hoping you can guide me in the right direction.

    I have a spreadsheet with a couple of sheets - Summary & data sheets. See attached.
    The 'Data' sheet contains manually input data, for several week numbers. On the summary sheet I want to see any data pertaining to the current week.
    I am trying to put together a macro that will loop through the 'Data' sheet, copy and paste values starting from Cell B8, in the Summary sheet, based on cell B3(week number). The week number is dynamic, hence why cell B3 needs to be referenced.

    For example, Cell B3, in the summary sheet, has Week 14. Any data that is in week 14, on the data sheet, has been copied over to the summary sheet...next week will be week 15, so I would like week 15's data to be copied, so on and so forth.

    I hope you, excel gurus, can help me out on this.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-28-2014
    Location
    Texas, USA
    MS-Off Ver
    2016
    Posts
    1,796

    Re: Macro to copy from one sheet to another, based on a cell in sheet1

    Please Login or Register  to view this content.
    I'm interested in starting a career working with VBA, if anyone knows of any opportunities!

  3. #3
    Registered User
    Join Date
    08-30-2012
    Location
    Ottawa
    MS-Off Ver
    Excel 2007
    Posts
    59

    Re: Macro to copy from one sheet to another, based on a cell in sheet1

    That worked like a charm!

  4. #4
    Registered User
    Join Date
    02-13-2008
    Posts
    4

    Re: Macro to copy from one sheet to another, based on a cell in sheet1

    I am trying to do something similar here now, and I think I can tweak this code for my needs but need some help and guidance.

    I need the macro to grab the value in cell B1 on sheet Summary, and copy and paste all rows from sheet AllData where B1 = same value in Column C on AllData sheet (also copy over header row 1) THEN I need the macro to paste all of those rows into the first blank row on my sheet Summary.

    I would be forever grateful if someone was able to guide me here today. THANKS!!

+ 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] Need to copy a row from Sheet1 to Sheet2 then auto delete from Sheet 1 based on Column G
    By jingles9 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-20-2015, 08:11 AM
  2. Replies: 1
    Last Post: 11-01-2014, 11:48 AM
  3. [SOLVED] Macro to copy cell value of Sheet1 to next empty cell of colum A in Sheet 2
    By JamesFinch in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-15-2014, 02:54 PM
  4. Copy certain data from Sheet1 to Sheet 2 based on values in a column on Sheet1
    By theglitch in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-22-2013, 01:28 PM
  5. Copy value of one sheet into another based on sheet1 value
    By mubashar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-17-2013, 12:19 PM
  6. [SOLVED] Copy and Paste Entire Row from Sheet1->Sheet2 based on text string match in Sheet1 Row
    By dmlovic in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-17-2012, 08:42 AM
  7. Macro to copy range of cell from sheet1 to sheet2 based on a cell value in sheet2
    By drgwhizz in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-25-2012, 10:39 AM

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