+ Reply to Thread
Results 1 to 2 of 2

Data from workbook1 to workbook2 every week but in different place in workbook2

  1. #1
    Registered User
    Join Date
    06-25-2007
    Posts
    35

    Data from workbook1 to workbook2 every week but in different place in workbook2

    Hi

    I am trying to work out how to run a macro wheras data from the first (weekly) workbook is placed into the second (monthly) workbook but in a different location every week for a full calender month. Then start over again.
    Attached sheets from both workbooks.

    weekly: cells C1:G138 copied to
    monthly: cells C1:G138 for week1 and then to cells H1:L138 the following week and so forth.

    I was thinking along the lines of
    If text in Cell C1 go to cell H1 etc.

    I'm thinking it's not possible with one macro but I still need help even if it can only be done using one!!!

    Thanks again in anticipation to you gurus!!!
    Attached Files Attached Files
    Last edited by cheelie; 06-29-2007 at 06:23 PM.

  2. #2
    Registered User
    Join Date
    06-25-2007
    Posts
    35

    Additional info

    I was thinking along the lines of if text in cell C1 go to cell H1 etc.

    Thanks!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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