Hi Excel knowledge gods!
I can create basic macros but I am struggling with with this one!
What I am trying to do is create a macro to copy and paste two sets of characters, in A1 is the the first number (number of shelves), this can be any number from 1 to 20 (possible more), and the second number is is similar (locations). The shelves could be either 1 to 5 or A to E and the locations will always be a number 1 to 10
Example
In this example I am going to use A to E and the locations will always be a number 1 to 10
So what I need is for the user to pick whether it's a numeric or alphabetical (this part is easy), they then need to select the start (so using alphabetical as a option) they could select A to start and end with E (also easy).
The part I am struggling with is, in sheet 2 I need it to paste the value A1 in cell A1 then A2 in A2 ext until A10, then I need it to create B1 in cell A11 and continue until E10 is created
This is what I require for both alphabetic and numeric
Is this possible with a macro?
I can create basic macros but I am struggling with with this one!
What I am trying to do is create a macro to copy and paste two sets of characters, in A1 is the the first number (number of shelves), this can be any number from 1 to 20 (possible more), and the second number is is similar (locations). The shelves could be either 1 to 5 or A to E and the locations will always be a number 1 to 10
Example
In this example I am going to use A to E and the locations will always be a number 1 to 10
So what I need is for the user to pick whether it's a numeric or alphabetical (this part is easy), they then need to select the start (so using alphabetical as a option) they could select A to start and end with E (also easy).
The part I am struggling with is, in sheet 2 I need it to paste the value A1 in cell A1 then A2 in A2 ext until A10, then I need it to create B1 in cell A11 and continue until E10 is created
This is what I require for both alphabetic and numeric
| Alphabetical | Numeric | |
| A01 | 0101 | |
| A02 | 0102 | |
| A03 | 0103 | |
| A04 | 0104 | |
| A05 | 0105 | |
| A06 | 0106 | |
| A07 | 0107 | |
| A08 | 0108 | |
| A09 | 0109 | |
| A10 | 0110 | |
| B01 | 0201 | |
| B02 | 0202 | |
| B03 | 0203 | |
| B04 | 0204 | |
| B05 | 0205 | |
| B06 | 0206 | |
| B07 | 0207 | |
| B08 | 0208 | |
| B09 | 0209 | |
| B10 | 0210 |
Is this possible with a macro?
