Hello,
I am in need of a complex (to me) macro that will copy paste data from one sheet to a new tab. I am dealing with an excel file that has a ton of random columns that I want to remove by pasting the relevant data to a new tab. The worksheet is a timesheet record, and i want to compare the AN and AT columns in an easy to read format. There is a lot of junk in the other cells that I do not need.
I need to Search in column I, and copy all the cells that begin with "S" to a new page. I will also need the data copied over in columns AN, At, and A. There is accompanying data in other cells. the columns are fixed but some have more rows than others.
Data needed copied to new sheet.
Col I: customer
col A: serial
Column an: number
Column at: number
the data in columns AN and AT will be on the same row. The constant I found is that there will be at least 2 blank spaces after this number in col AN, but there will be random numbers above it. the amount of names vary based on how many people worked on whichever project. Below is a sample for reference.
<colgroup><col span="2"><col><col span="2"></colgroup><tbody>
</tbody>
in the example above, i would need A1, I1, AN8 and AT8 copied to a new tab. For the second list, it would be A11, I11, an19, AT19.
I would like them to be pasted as a1, b1, c1, d1 on the new tab. then looping around to get all the data from the first tab to the second for all col I cells that begin with "S"
I am in need of a complex (to me) macro that will copy paste data from one sheet to a new tab. I am dealing with an excel file that has a ton of random columns that I want to remove by pasting the relevant data to a new tab. The worksheet is a timesheet record, and i want to compare the AN and AT columns in an easy to read format. There is a lot of junk in the other cells that I do not need.
I need to Search in column I, and copy all the cells that begin with "S" to a new page. I will also need the data copied over in columns AN, At, and A. There is accompanying data in other cells. the columns are fixed but some have more rows than others.
Data needed copied to new sheet.
Col I: customer
col A: serial
Column an: number
Column at: number
the data in columns AN and AT will be on the same row. The constant I found is that there will be at least 2 blank spaces after this number in col AN, but there will be random numbers above it. the amount of names vary based on how many people worked on whichever project. Below is a sample for reference.
col a | col i | col an | col at | |
10121 | S1234 | |||
14.00 | 2.00 | |||
5.92 | ||||
2.00 | ||||
1.00 | 0.50 | |||
15.00 | 10.42 | |||
10122 | S1235 | |||
8.50 | 0.25 | |||
6.58 | ||||
2.50 | ||||
1.00 | 1.00 | |||
9.50 | 10.33 |
<colgroup><col span="2"><col><col span="2"></colgroup><tbody>
</tbody>
in the example above, i would need A1, I1, AN8 and AT8 copied to a new tab. For the second list, it would be A11, I11, an19, AT19.
I would like them to be pasted as a1, b1, c1, d1 on the new tab. then looping around to get all the data from the first tab to the second for all col I cells that begin with "S"