Dear Experts,
I need help with creating a macro('s) which will perform a couple of tasks at once.
1. Copy multiple ranges of data for main sheet (Sheetname "Dagstaat") towards multiple othersheets
- Range A7 until E17 + A20 until E43 towards sheetname "Archief Kleur" copy towards new row in table starting at column B
- Range G4 until H9 + G14 untill H19 towards sheetname "Archief IBC" copy towards new row in table starting at column B
2. Copy range A1 untill J200 from sheetname "Dagstaat" towards a new file with name "Dagstaat " + input from cell G1 in sheetname "Dagstaat" ( = Date+Time)
3. Save above file in same folder as original file withe the following actions added
- Create folder "Dagstaat " + Current year (If folder already exist do not create)
- Create folder "Week " + ISO weeknumber (If folder already exist do not create)
- Move file towards the above correct weeknumber / year folder
4. Autosave current main file (to make sure no archiving is lost when exicdenitilly not saved.
I want the above actions either to connect towards a single button exection all 4 actions above or combine point 1+2 behind one button and 3 and 4 behind another.
Currently i connect find a good solution for point 3/4.
Hopefully one of you can help me to create a working macro to execute all steps discripted above.
Kind regards and thanks in advance!
Matthew
I need help with creating a macro('s) which will perform a couple of tasks at once.
1. Copy multiple ranges of data for main sheet (Sheetname "Dagstaat") towards multiple othersheets
- Range A7 until E17 + A20 until E43 towards sheetname "Archief Kleur" copy towards new row in table starting at column B
- Range G4 until H9 + G14 untill H19 towards sheetname "Archief IBC" copy towards new row in table starting at column B
2. Copy range A1 untill J200 from sheetname "Dagstaat" towards a new file with name "Dagstaat " + input from cell G1 in sheetname "Dagstaat" ( = Date+Time)
3. Save above file in same folder as original file withe the following actions added
- Create folder "Dagstaat " + Current year (If folder already exist do not create)
- Create folder "Week " + ISO weeknumber (If folder already exist do not create)
- Move file towards the above correct weeknumber / year folder
4. Autosave current main file (to make sure no archiving is lost when exicdenitilly not saved.
I want the above actions either to connect towards a single button exection all 4 actions above or combine point 1+2 behind one button and 3 and 4 behind another.
Currently i connect find a good solution for point 3/4.
Hopefully one of you can help me to create a working macro to execute all steps discripted above.
Kind regards and thanks in advance!
Matthew