Excel macro VBA Scripts to select certain ranges , then copy/paste into ranges & add a row
Budget: $30 – $250 USD
Project is to provide Excel macro/VBA scripts that will do each of the following tasks:
Script Part #1:
1. Select range B20 through L20 (this will be the starting range).
2. Copy the data in that range of cells
3. Paste that data (using "Paste-Special: Values") in the row exactly seven rows above the range (Columns B though L) that the script just copied. (i.e., Paste in Columns B though L in that row)
4. Then add 1 to the row of this range in the script that will be selected the next time (i.e., next time the script is run, it will select B21:L21)
Script Part #2:
1. Select range T13 through CZ13 (this will be the starting range).
2. Copy the data in that range of cells
3. Paste that data (using "Paste-Special: Formulas") in a range of cells that are exactly one row below the range that the script just copied (i.e., starting range to paste in will be T14 through CZ14).
4. Add 1 to the "range of cells in Column T" that will be selected next time the script is run (i.e., the starting range is T13:CZ13, so after this addition of 1, the range of cells that will be copied, the next time the script is run, will be T14:CZ14), and the range of cells that will be pasted into, the next time the script is run, will be T15 through CZ15)
Script Part #3: Select the row 19 and insert a row there. Then add 1 to the row in the script that will be selected the next time (i.e., next time the script is run, it will select row 20)
Script Part #1:
1. Select range B20 through L20 (this will be the starting range).
2. Copy the data in that range of cells
3. Paste that data (using "Paste-Special: Values") in the row exactly seven rows above the range (Columns B though L) that the script just copied. (i.e., Paste in Columns B though L in that row)
4. Then add 1 to the row of this range in the script that will be selected the next time (i.e., next time the script is run, it will select B21:L21)
Script Part #2:
1. Select range T13 through CZ13 (this will be the starting range).
2. Copy the data in that range of cells
3. Paste that data (using "Paste-Special: Formulas") in a range of cells that are exactly one row below the range that the script just copied (i.e., starting range to paste in will be T14 through CZ14).
4. Add 1 to the "range of cells in Column T" that will be selected next time the script is run (i.e., the starting range is T13:CZ13, so after this addition of 1, the range of cells that will be copied, the next time the script is run, will be T14:CZ14), and the range of cells that will be pasted into, the next time the script is run, will be T15 through CZ15)
Script Part #3: Select the row 19 and insert a row there. Then add 1 to the row in the script that will be selected the next time (i.e., next time the script is run, it will select row 20)