I am quite new to VBA
I have a sheet that has multiple small named ranges. Is it possible to select a cell lower in the same sheet to copy all these ranges to?
Further to that I would like these new ranges to be added back into the original range... Is this possible?
If so can I run another macro to move 1 of the ranges X amount of cells left or right?
For some brief context, this is for a build timeline of a large project (70+ days) with multiple groups of parts(Named ranges). The large project repeats every 20days. I want to duplicate all the ranges every 20days or to where I have an active cell.
The ranges contain numbers that represent a Tech for 1 = 1 day or part days. I then have a sum of all these to see the required head count on any given day.
If the sum is to large I want to be able to shift the new range left or right to help balance the Tech resource required...
Any help would be greatly appreciated
Pic is an example of 2 of the named ranges I have
I have a sheet that has multiple small named ranges. Is it possible to select a cell lower in the same sheet to copy all these ranges to?
Further to that I would like these new ranges to be added back into the original range... Is this possible?
If so can I run another macro to move 1 of the ranges X amount of cells left or right?
For some brief context, this is for a build timeline of a large project (70+ days) with multiple groups of parts(Named ranges). The large project repeats every 20days. I want to duplicate all the ranges every 20days or to where I have an active cell.
The ranges contain numbers that represent a Tech for 1 = 1 day or part days. I then have a sum of all these to see the required head count on any given day.
If the sum is to large I want to be able to shift the new range left or right to help balance the Tech resource required...
Any help would be greatly appreciated
Pic is an example of 2 of the named ranges I have