Hi Everyone.
I'm new to excel and VBA. So maybe the question is a bit dumb.
I got my macro reading different Excel file and combine as a big datasheet.
I am facing problem in combining data.
At First, I got 2 column and the sheet is blank.
<tbody>
</tbody>
After I ran the macro, datasheet will be inserted a column and data will be add
Example (1st Time)
<tbody>
</tbody>
Example (2nd Time)
<tbody>
</tbody>
Question is, I would like to get the following output (Note that the data will be added and new column will be insert)
<tbody>
</tbody>
I got a function for finding last column and last row (i.e. after 2nd run of inserting data, last column will be 4 and last row will be 7)
I know is a bit dumb and stupid, still i cannot get a clue yet.
Please help and thank you for all the reply.
I'm new to excel and VBA. So maybe the question is a bit dumb.
I got my macro reading different Excel file and combine as a big datasheet.
I am facing problem in combining data.
At First, I got 2 column and the sheet is blank.
Name | Total |
<tbody>
</tbody>
After I ran the macro, datasheet will be inserted a column and data will be add
Example (1st Time)
Name | April | Total |
A | 1 | |
B | 2 | |
A | 3 |
<tbody>
</tbody>
Example (2nd Time)
Name | May | April | Total |
A | 3 | ||
B | 2 | ||
B | 2 | ||
A | 1 | ||
B | 2 | ||
A | 3 |
<tbody>
</tbody>
Question is, I would like to get the following output (Note that the data will be added and new column will be insert)
Name | May | April | Total |
A | 3 | 4 | 7 |
B | 4 | 2 | 6 |
<tbody>
</tbody>
I got a function for finding last column and last row (i.e. after 2nd run of inserting data, last column will be 4 and last row will be 7)
I know is a bit dumb and stupid, still i cannot get a clue yet.
Please help and thank you for all the reply.