This is a follow-up question for a Macro/Workbook that Andrewssd3
kindly designed for me. However, when more data is inputted to the workbook, I get the "run-time error'1004'".
I believe this is because there aren't enough rows in sheet "Result". However, with my limited knowledge with Excel, I do not know how to get around it. All I know is that maybe the result could be dumped back on multiple sheets to solve the Rows limit problem? Or maybe the result could be dumped on a completely separate workbook and saved as a separate workbook and just close the result workbook and create another one automatically (because the file size for the result would be very large due to the large amount of data)?
If Andrewssd3 or any other experts can help, that would be great.
((By the way, the operating system is Windows 7 64bit with Excel 2010 64bit.
Earlier, when I ran on Windows 7 32bit with Excel 32bit, it actually gave me out of memory problem before it even runs))
Thanks you very much.