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

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.

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