Hi all,
I recently made a post about having multiple workbooks, all located in the same folder, and wanting to merge them into a singular workbook while maintaing the template that all of the workbooks shared.
I got a superb piece of code from JBeaucaire that solved all of my problems. However, I am now having a small issue with the code.
The code is designed to look UP the "C" column to spot the last row of data for the LR variable. However, column C is not always filled. there is no Column in the worksheet that is consistently filled out throughout. But, there is always data in either Column C or Column D. How can I edit the code to check both column C and D to spot the last row of data for the LR variable.
I'm still very new at this so thank you for your patience!
Bookmarks