So, to avoid this trap, you look for the last non empty row in a sheet using *. @Thalassa For what I understand of your code it finds all cells. The problem is, if the last cell (A12) in column A is blanc (and there are data in column B, C and D), it had to copy the data.
But since it uses lastrow it will not find the blanc cells (in my case A12).
The different procedures demonstrate techniques for copying varying size ranges as well as placing the data at specific locations in the summary sheet.
You can download a workbook that contains the code in this article at Ron de Bruin's Web site.
Hi everybody, I had help with this item in the link below. I can understand the reason for it, but I can't solve the problem.
When the last item in column A is blanc (in one of the sheets) the data don't get copied to the consolidated sheet.
If you pass them like this you only need to pass these.
If you omit the paramater name you have to fill up the elements you do not pass by comma.
You can use either of these columns, but we are also assuming that this is the case with all data and sheet.
(13 printed pages)Ron de Bruin, Microsoft Office Excel MVPFrank Rice, Microsoft Corporation August 2008Applies to: Microsoft Office Excel 2007, Microsoft Office Excel 2003, Microsoft Excel 2002, Microsoft Excel 2000Contents or consolidate the data in each worksheet into a summary worksheet.
The samples described in this article add a worksheet to the active workbook and then copy a range of cells from every worksheet to the summary worksheet.
In this article, you saw several code samples that you can use to merge data from all or some worksheets into one summary worksheet.
Exploring and implementing these techniques into your own applications can help make your job as a developer easier and make your solutions more versatile.
You can use notation such as A: C to copy additional columns.