Hello all Excel users!
I'm gonna start by apologizing for my poor explanation, if anything is unclear, please let me know.
I work at a hospital and I'm writing lots of patient data in excel, this process can be quite time consuming and I've been looking for a quicker solution. I'm quite new to VBA and haven't had any previous Macros at all.
The excel document that I'm currently working with has 28,000 rows and I'm currently completing one chart at a time, then manually copying it and pasting it next to my newly created chart. However, if this could be done with an assigned macro it would be lovely.
Say I wanna copy A1 to E61 and then make all that data appear on say F1 to J61, how would I go about that?
And also, is it possible to make Excel automatically copy and paste all that data once I entered the last piece of data, for example E61?
So..I'm looking for a Macro that can do this for me. Copy the assigned data (A1-E61) to the destination (F1-J61) and so forth..?
To make things a little clearer I'll post an example of how my excel document looks. I'd appreciate a somewhat timely response. Thanks a lot!
- Oscar
A B C D E F G H I J
Frys Ställ Ask Pos. Labbnr Frys Ställ Ask Pos. Labbnr
1 1 1 6 1 1 1 5 76 67 76
1 1 1 13 2 1 1 5 83 68 85
1 1 1 20 3 1 1 5 90 69 65
1 1 1 27 4 1 1 5 97 70 45
1 1 1 34 5 1 1 6 6 71 32
1 1 1 48 7 1 1 6 13 72
1 1 1 55 8 1 1 6 20 73
1 1 1 62 9 1 1 6 27 74
1 1 1 69 10 1 1 6 34 75
1 1 1 76 11 1 1 6 41 76
1 1 1 83 12 1 1 6 48 77
1 1 1 90 13 1 1 6 55 78
1 1 1 97 14 1 1 6 62 79
1 1 2 6 15 1 1 6 69 80
1 1 2 13 16 1 1 6 76 81
1 1 2 20 17 1 1 6 83 82
1 1 2 27 18 1 1 6 90 83
1 1 2 41 20 1 1 6 97 84
1 1 2 48 21 1 1 7 6 85
1 1 2 55 22 1 1 7 13 86
1 1 2 62 23 1 1 7 20 87
1 1 2 69 24 1 1 7 27 88
1 1 2 76 25 1 1 7 34 89
1 1 2 90 27 1 1 7 41 90
1 1 2 97 28 1 1 7 48 91
1 1 3 13 30 1 1 7 55 92
1 1 3 20 31 1 1 7 62 93
1 1 3 34 33 1 1 7 69 94
1 1 3 41 34 1 1 7 76 95
1 1 3 48 35 1 1 7 83 96
1 1 3 55 36 1 1 7 90 97
1 1 3 62 37 1 1 7 97 98
1 1 3 69 38 1 1 8 6 99
1 1 3 76 39 1 1 8 13 100
1 1 3 83 40 1 1 8 20 101
1 1 3 90 41 1 1 8 27 102
1 1 3 97 42 1 1 8 34 103
1 1 4 6 43 1 1 8 41 104
1 1 4 13 44 1 1 8 48 105
1 1 4 20 45 1 1 8 55 106
1 1 4 27 46 1 1 8 62 107
1 1 4 34 47 1 1 8 69 108
1 1 4 41 48 1 1 8 76 109
1 1 4 48 49 1 1 8 83 110
1 1 4 55 50 1 1 8 90 111
1 1 4 62 51 1 1 8 97 112
1 1 4 76 53 1 1 9 6 113
1 1 4 83 54 1 1 9 13 114
1 1 4 90 55 1 1 9 20 115
1 1 4 97 56 1 1 9 27 116
1 1 5 6 57 1 1 9 34 117
1 1 5 13 58 1 1 9 41 118
1 1 5 20 59 1 1 9 48 119
1 1 5 27 60 1 1 9 62 121
1 1 5 34 61 1 1 9 69 122
1 1 5 41 62 1 1 9 76 123
1 1 5 48 63 1 1 9 83 124
1 1 5 55 64 1 1 9 90 125
1 1 5 62 65 1 1 9 97 126
I'm gonna start by apologizing for my poor explanation, if anything is unclear, please let me know.
I work at a hospital and I'm writing lots of patient data in excel, this process can be quite time consuming and I've been looking for a quicker solution. I'm quite new to VBA and haven't had any previous Macros at all.
The excel document that I'm currently working with has 28,000 rows and I'm currently completing one chart at a time, then manually copying it and pasting it next to my newly created chart. However, if this could be done with an assigned macro it would be lovely.
Say I wanna copy A1 to E61 and then make all that data appear on say F1 to J61, how would I go about that?
And also, is it possible to make Excel automatically copy and paste all that data once I entered the last piece of data, for example E61?
So..I'm looking for a Macro that can do this for me. Copy the assigned data (A1-E61) to the destination (F1-J61) and so forth..?
To make things a little clearer I'll post an example of how my excel document looks. I'd appreciate a somewhat timely response. Thanks a lot!
- Oscar
A B C D E F G H I J
Frys Ställ Ask Pos. Labbnr Frys Ställ Ask Pos. Labbnr
1 1 1 6 1 1 1 5 76 67 76
1 1 1 13 2 1 1 5 83 68 85
1 1 1 20 3 1 1 5 90 69 65
1 1 1 27 4 1 1 5 97 70 45
1 1 1 34 5 1 1 6 6 71 32
1 1 1 48 7 1 1 6 13 72
1 1 1 55 8 1 1 6 20 73
1 1 1 62 9 1 1 6 27 74
1 1 1 69 10 1 1 6 34 75
1 1 1 76 11 1 1 6 41 76
1 1 1 83 12 1 1 6 48 77
1 1 1 90 13 1 1 6 55 78
1 1 1 97 14 1 1 6 62 79
1 1 2 6 15 1 1 6 69 80
1 1 2 13 16 1 1 6 76 81
1 1 2 20 17 1 1 6 83 82
1 1 2 27 18 1 1 6 90 83
1 1 2 41 20 1 1 6 97 84
1 1 2 48 21 1 1 7 6 85
1 1 2 55 22 1 1 7 13 86
1 1 2 62 23 1 1 7 20 87
1 1 2 69 24 1 1 7 27 88
1 1 2 76 25 1 1 7 34 89
1 1 2 90 27 1 1 7 41 90
1 1 2 97 28 1 1 7 48 91
1 1 3 13 30 1 1 7 55 92
1 1 3 20 31 1 1 7 62 93
1 1 3 34 33 1 1 7 69 94
1 1 3 41 34 1 1 7 76 95
1 1 3 48 35 1 1 7 83 96
1 1 3 55 36 1 1 7 90 97
1 1 3 62 37 1 1 7 97 98
1 1 3 69 38 1 1 8 6 99
1 1 3 76 39 1 1 8 13 100
1 1 3 83 40 1 1 8 20 101
1 1 3 90 41 1 1 8 27 102
1 1 3 97 42 1 1 8 34 103
1 1 4 6 43 1 1 8 41 104
1 1 4 13 44 1 1 8 48 105
1 1 4 20 45 1 1 8 55 106
1 1 4 27 46 1 1 8 62 107
1 1 4 34 47 1 1 8 69 108
1 1 4 41 48 1 1 8 76 109
1 1 4 48 49 1 1 8 83 110
1 1 4 55 50 1 1 8 90 111
1 1 4 62 51 1 1 8 97 112
1 1 4 76 53 1 1 9 6 113
1 1 4 83 54 1 1 9 13 114
1 1 4 90 55 1 1 9 20 115
1 1 4 97 56 1 1 9 27 116
1 1 5 6 57 1 1 9 34 117
1 1 5 13 58 1 1 9 41 118
1 1 5 20 59 1 1 9 48 119
1 1 5 27 60 1 1 9 62 121
1 1 5 34 61 1 1 9 69 122
1 1 5 41 62 1 1 9 76 123
1 1 5 48 63 1 1 9 83 124
1 1 5 55 64 1 1 9 90 125
1 1 5 62 65 1 1 9 97 126