Aug 4, 2010 at 02:31 AM
Posts4478Registration dateThursday January 28, 2010StatusContributorLast seenMay 5, 2022
Aug 5, 2010 at 07:37 AM
i need help to combine two sheets in the same document by VBA scripts. My 2 worksheets have very similar format (same column numbers, same headings but the cells got different size and shapes).
I want to copy the data from sheet 5 to sheet 1, where the data obtained from sheet 5 should be placed right behind the data of sheet 1. The problem i came across is that since the cells got different shapes and size, excel could not do the copy and paste for me using vba scripts.