Houstonwolf
Board Regular
- Joined
- Jul 28, 2006
- Messages
- 154
I utilize an online system that will allow mass input of data using information pasted into Excel in the following format:
I drag down and copy Col A, right click into the online app and it enters all my data.
My problem is, I'm trying to create a macro that will take this data:
and insert 3 cells beneath A9, insert text 'MLA101B2' in new A10, insert text 'Y' in new A11 and leave new A12 blank (or insert a space, doesn't matter), then tab down insert 3 cells beneath new A13 and insert the text as above. And so on. I have approximately 4460 data points to enter so this would be a huge time saver.
When I record the macro, all it does it reference the active cell. It doesn't capture the action of tabbing down to a different call.
I know it can be done, I just can't figure it out using the record macro method.
I'm sure it will require modifying the existing recorded macro or creating one from scratch, I just don't know what to enter.
Thanks!
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | T79747 | |||||
2 | MLA101B2 | |||||
3 | Y | |||||
4 | ||||||
5 | T79748 | |||||
6 | MLA101B2 | |||||
7 | Y | |||||
8 | ||||||
Sheet1 |
I drag down and copy Col A, right click into the online app and it enters all my data.
My problem is, I'm trying to create a macro that will take this data:
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
9 | T79749 | |||||
10 | T79750 | |||||
11 | T79751 | |||||
12 | T79752 | |||||
13 | T79753 | |||||
14 | T79754 | |||||
15 | T79755 | |||||
16 | T79756 | |||||
17 | T79757 | |||||
18 | T79758 | |||||
19 | T79759 | |||||
20 | T79760 | |||||
21 | T79761 | |||||
22 | T79762 | |||||
23 | T79763 | |||||
24 | T79764 | |||||
25 | T79765 | |||||
26 | T79766 | |||||
Sheet1 |
and insert 3 cells beneath A9, insert text 'MLA101B2' in new A10, insert text 'Y' in new A11 and leave new A12 blank (or insert a space, doesn't matter), then tab down insert 3 cells beneath new A13 and insert the text as above. And so on. I have approximately 4460 data points to enter so this would be a huge time saver.
When I record the macro, all it does it reference the active cell. It doesn't capture the action of tabbing down to a different call.
I know it can be done, I just can't figure it out using the record macro method.
I'm sure it will require modifying the existing recorded macro or creating one from scratch, I just don't know what to enter.
Thanks!