+ Reply to Thread
Results 1 to 3 of 3

Macro to copy Dyanmic lists then copy sheet and clear the original data

  1. #1
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    wales
    MS-Off Ver
    Excel 2007
    Posts
    964

    Macro to copy Dyanmic lists then copy sheet and clear the original data

    I need to create a week end macro that copies the new values from the data page to the original type page.

    then duplicates the order page

    then clears the original order page

    all the lists are dynamic though which is where the problem comes for me as i have only a little VBA knowledge and don't know how to use ranges and dynamic ranges in VBA.

    if someone can help point me in the right direction. or help with the task and explain a little how it works id be eternally grateful

    I think its clear with the attached files

    before.xlsx

    after.xlsx
    The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
    <--- If a post helps hit the star

  2. #2
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,517

    Re: Macro to copy Dyanmic lists then copy sheet and clear the original data

    Ok give this a try. Make sure that in your data sheet row 5 colimns E,I and M are spelled the same as you worksheets name. Needs to be type 1 with a space between type and 1. Just like the worksheets name.

    Please Login or Register  to view this content.
    Last edited by mike7952; 11-30-2012 at 12:54 PM.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

  3. #3
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    wales
    MS-Off Ver
    Excel 2007
    Posts
    964

    Re: Macro to copy Dyanmic lists then copy sheet and clear the original data

    how do you create a dynamic range in VBA, the problem i have is what i posted is actully more simple than what i have.

    if i have that skill i think i can do the rest, (i may need some cleanin up after but i should be able to get it working.)

    i dont really like not understatnding so im looking at your VBA and i dont understand which means i need to learn

+ 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