Hi,
I have a simple ask. I have an excel workbook that is broken up into 3 different sheets. I would like to have a VBA code that lets me take all those 3 sheets and consolidate it into one sheet. All column fields are the same, they are just broken into 3 different regions. However, sometimes there can be more/less entries so I need the VBA code to find the last row containing data.
How would I do this? Thanks.
I have a simple ask. I have an excel workbook that is broken up into 3 different sheets. I would like to have a VBA code that lets me take all those 3 sheets and consolidate it into one sheet. All column fields are the same, they are just broken into 3 different regions. However, sometimes there can be more/less entries so I need the VBA code to find the last row containing data.
How would I do this? Thanks.