I'm still quit new to VBA and I have a question for you and can't find the answer on this forum or google. Maybe you can help me?
I have three different sheets with columns of data (fixed headers, only in different placed columns). The data correspondent by row (A1, B1, C1, etc). The sequence does not matter (eg: B1, C1, A1).
I would like to consolidate the data in these three different sheets by row into one consolidated worksheet under the right headers. The problem is that the columns are randomly placed in the sheets.
In the worksheet (Example) I put the data how I would like to have it. This probably explains better what I'm asking for.
1. Copy columns row by row to correct column in Consolidated (eg. Header A row 1, Header B, row 1, Header A row 2, Header B, row 2, etc).
2. Copy until last row (variable)
3. Paste to last row + 1 (variable)
Hopefully someone can help me with this! I'm available to explain somemore.
Grtz.
Constant
Bookmarks