Hi All,
I am new to vba coding.
I have a workbook with many worksheets (tabs) and would like to create a macropage to copy & paste everything into one giant piece of worksheet.
The following code works fine for one of my template, but failed in the others (showed bug in lastcol=... for sub copypaste)
Since the worksheets are really complicated and had many merged cells, Here is what I have come up so far.
Could you please have a look and help
I also wish to copy and paste with exact functions (since many of the data contains referencing codes)
Thanks!!!
Brian
Bookmarks