Hi,
I wonder if someone can help me with this problem with amacro.
I have a table of data that appears below(input data) whichhas usernames down a few rows and one or more accounts across 70 columns.
On a regular basis, I would need to able to copy all theaccount numbers that are present in each cell and copy it into a column (see output data)
Also I would need to add the username in a second column(see output data).
Given that this task could involve hundreds of usernames oraccount numbers, I would need a macro to cut down the time to process thisfile.
I would really appreciate the help!
Many thanks,
Input Data
<colgroup><col width="138" style="width: 104pt; mso-width-source: userset; mso-width-alt: 5046;">
<col width="139" style="width: 104pt; mso-width-source: userset; mso-width-alt: 5083;">
<col width="162" style="width: 122pt; mso-width-source: userset; mso-width-alt: 5924;">
<col width="88" style="width: 66pt; mso-width-source: userset; mso-width-alt: 3218;" span="9">
<col width="96" style="width: 72pt; mso-width-source: userset; mso-width-alt: 3510;" span="60">
<tbody>
</tbody>
Output Data
<colgroup><col width="64" style="width: 48pt;">
<col width="136" style="width: 102pt; mso-width-source: userset; mso-width-alt: 4973;">
<tbody>
</tbody>
I wonder if someone can help me with this problem with amacro.
I have a table of data that appears below(input data) whichhas usernames down a few rows and one or more accounts across 70 columns.
On a regular basis, I would need to able to copy all theaccount numbers that are present in each cell and copy it into a column (see output data)
Also I would need to add the username in a second column(see output data).
Given that this task could involve hundreds of usernames oraccount numbers, I would need a macro to cut down the time to process thisfile.
I would really appreciate the help!
Many thanks,
Input Data
Username | Laat Login Date/Time | No. Registered Premises | Account No 1 | Account No 2 | Account No 3 | Account No 4 | Account No 5 | Account No 6 | Account No 7 | Account No 8 | Account No 9 | Account No 10 | Account No 11 | Account No 12 | Account No 13 | Account No 14 | Account No 15 | Account No 16 | Account No 17 | Account No 18 | Account No 19 | Account No 20 | Account No 21 | Account No 22 | Account No 23 | Account No 24 | Account No 25 | Account No 26 | Account No 27 | Account No 28 | Account No 29 | Account No 30 | Account No 31 | Account No 32 | Account No 33 | Account No 34 | Account No 35 | Account No 36 | Account No 37 | Account No 38 | Account No 39 | Account No 40 | Account No 41 | Account No 42 | Account No 43 | Account No 44 | Account No 45 | Account No 46 | Account No 47 | Account No 48 | Account No 49 | Account No 50 | Account No 51 | Account No 52 | Account No 53 | Account No 54 | Account No 55 | Account No 56 | Account No 57 | Account No 58 | Account No 59 | Account No 60 | Account No 61 | Account No 62 | Account No 63 | Account No 64 | Account No 65 | Account No 66 | Account No 67 | Account No 68 | Account No 69 |
user1@btmail.com | 31/07/2014 11:55 | 77777777 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user2@hotmaiz.com | 05/08/2014 07:57 | 88888888 | 63047667 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user3@infinity.co.uk | 07/08/2014 10:12 | 33333333 | 63577302 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user4@gmain.co.in | 03/09/2014 14:22 | 10232284 | 10785397 | 11151490 | 11440526 | 11607435 | 11607883 | 12149027 | 12885213 | 12910505 | 13180598 | 13187596 | 13417730 | 14424676 | 14564348 | 14647086 | 1468423& | 14803502 | 1551641& | 15612261 | 15612548 | 15847958 | 15947863 | 16105148 | 16440107 | 16756737 | 16907931 | 17136016 | 17318737 | 17632812 | 1772301& | 17766300 | 17940358 | 18373186 | 18463559 | 19040073 | 19066580 | 19214967 | 19819836 | 19949322 | 20153068 | 20156206 | 20474099 | 21029187 | 30559698 | 30724894 | 31810617 | 31965052 | 33100497 | 36517050 | 40538897 | 4920494& | 50189801 | 50572297 | 63059010 | 63072394 | 63632481 | 71491640 | 91347316 | 91513302 | 91519584 | ||||||||||
user5@topaz..uk | 08/09/2014 12:13 | 11750080 | 12637498 | 12924166 | 71492154 | 91207976 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user6@yahool.co.uk | 12/09/2014 11:55 | 11640187 | 6309404& | 63135369 | 63530898 |
Output Data
Account | Username |
77777777 | user1@btmail.com |
88888888 | user2@hotmaiz.com |
63047667 | user2@hotmaiz.com |