Hi
I have multiple datasets each of which has close to 1200 Worksheets. In each of these worksheets there is data spanning from 1000 rows to 5000 Rows.(Mostly at the lower end of the spectrum)
The problem is quite simple. I have obtained this data from an online database and since it is based on a time frame it includes rows from the start date to the end date. For most of these worksheets it implies that the data i require is from row 3000 or 4000 to row 5000. So I have written a macro that will help me eliminate these empty rows based on checking if the cell c3 is filled or not and it continues looping till the end.
1) My issue is that my workbook does not let me open the vba editor. Excel freezes up and stops responding everytime i try to open the vba editor or try to copy my macro from the other workbook. Is there any workaround for handling such large datasets on Excel for Mac 2011? Or would it make a difference if i use Excel on a regular windows computer? Each of these files is about 80 MB.
2) If it is not possible to handle such a large dataset is there any macro that lets me divide these large workbooks into smaller workbooks with fewer worksheets so i can run the Macro?
Thanks for your time
I have multiple datasets each of which has close to 1200 Worksheets. In each of these worksheets there is data spanning from 1000 rows to 5000 Rows.(Mostly at the lower end of the spectrum)
The problem is quite simple. I have obtained this data from an online database and since it is based on a time frame it includes rows from the start date to the end date. For most of these worksheets it implies that the data i require is from row 3000 or 4000 to row 5000. So I have written a macro that will help me eliminate these empty rows based on checking if the cell c3 is filled or not and it continues looping till the end.
1) My issue is that my workbook does not let me open the vba editor. Excel freezes up and stops responding everytime i try to open the vba editor or try to copy my macro from the other workbook. Is there any workaround for handling such large datasets on Excel for Mac 2011? Or would it make a difference if i use Excel on a regular windows computer? Each of these files is about 80 MB.
2) If it is not possible to handle such a large dataset is there any macro that lets me divide these large workbooks into smaller workbooks with fewer worksheets so i can run the Macro?
Thanks for your time
