I also can't work out how to include the column headings (they are the same on every worksheet).Īny help appreciated, even if you use completely different code!ĭim FolderPath As String 'store the folderpath in the computer's memoryĭim FileName As String 'store the file name inthe computer's memoryĭim WorkBk As Workbook 'store the name of each workbook in the computer's memoryĭim blankrow As Integer 'store the row number of the first blank row in destination sheetĭim varAllData As Variant 'array. I have used some of you code from previous forum questions mixed with my own but can't seem to get it to work - I think the issue is around line 39 - 42 where it currently picks just sheet 1 rather than all the sheets in the workbook so my loop just duplicates sheet 1 several times. All the worksheets on every single workbook contain the exact same column headings which I would also like to include in the new worksheet. I have multiple workbooks with multiple worksheets (the number of worksheets is not consistent across the workbooks and will vary over time) and I would like to merge them all into one worksheet in a new workbook. I'm just starting to get back to using VBA and a little bit rusty so appreciate any help you may be able to give around this. Merge multiple sheets from multiple workbooks into one new sheet
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |