Hi everyone,
I am in need of your expertise again. I don’t know how to do it, so here I am.
What I need help with is coming up with a VBA formula which will copy entire multiple rows of numbers from their existing locations up and down to a new storage location when I click the “Update” button.
To begin with, I have a group of 5 numbers at the top of my worksheet in cells K2:O2. These are the ref numbers. these numbers change, and when they do, I click the update button I need the tables for each of those Ref numbers to be updated.
So, take the first ref number for example, which is the Number 1. I need the VBA code to go to the tables for the number 1, which is the first tables… you can see the number one in cell A4 and A21 which designate table 1.. each number has 2 sections, a top and bottom section. So, when I click the update button in cell B2, the entire number row B18:AF18 of the top section for number 1 will be copied (not moved) to the top section, to cells B4:AF4. The numbers which are already in B4:AF4 and B5:AF5 will each move down one row, freeing up Row B4:AF4.
The same process should happen for the numbers in row, B19:AF19 of the bottom section of number 1, these number will be Copied down into the storage section, to row B21:AF21. The numbers which are already in B21:AF21 and B22:AF22 should move down one row.
the Same Process should happen for each of the 5 reference numbers at the top.
Note that the the numbers rows that are being copied should remain.. they are just being copied.
Note that over time, there could and will be up to 12 number rows in any of the storage sections, of any number. If there are, and there is a new row of numbers being copied to it, the 12th row at the bottom of the list can be deleted.
This process should happen for each of the 5 reference numbers at the top, no matter what they are.. the number range spans from 1 to 60.
I hope this makes sense.. I totally suck at VBA, Kinda ok with formulas but macros are way out of my capabilities. I am totally grateful for any help offered. Thank you,
Dave
I am in need of your expertise again. I don’t know how to do it, so here I am.
What I need help with is coming up with a VBA formula which will copy entire multiple rows of numbers from their existing locations up and down to a new storage location when I click the “Update” button.
To begin with, I have a group of 5 numbers at the top of my worksheet in cells K2:O2. These are the ref numbers. these numbers change, and when they do, I click the update button I need the tables for each of those Ref numbers to be updated.
So, take the first ref number for example, which is the Number 1. I need the VBA code to go to the tables for the number 1, which is the first tables… you can see the number one in cell A4 and A21 which designate table 1.. each number has 2 sections, a top and bottom section. So, when I click the update button in cell B2, the entire number row B18:AF18 of the top section for number 1 will be copied (not moved) to the top section, to cells B4:AF4. The numbers which are already in B4:AF4 and B5:AF5 will each move down one row, freeing up Row B4:AF4.
The same process should happen for the numbers in row, B19:AF19 of the bottom section of number 1, these number will be Copied down into the storage section, to row B21:AF21. The numbers which are already in B21:AF21 and B22:AF22 should move down one row.
the Same Process should happen for each of the 5 reference numbers at the top.
Note that the the numbers rows that are being copied should remain.. they are just being copied.
Note that over time, there could and will be up to 12 number rows in any of the storage sections, of any number. If there are, and there is a new row of numbers being copied to it, the 12th row at the bottom of the list can be deleted.
This process should happen for each of the 5 reference numbers at the top, no matter what they are.. the number range spans from 1 to 60.
I hope this makes sense.. I totally suck at VBA, Kinda ok with formulas but macros are way out of my capabilities. I am totally grateful for any help offered. Thank you,
Dave
Attachments
Last edited: