What I need however is to be able to combine the worksheets across all 6 workbooks into 1 worksheet. I have found a macro to combine multiple worksheets into 1 within the same workbook (given below). I need to combine all the data across the multiple worksheets and workbooks into 1 worksheet I have several processes I need to go through in order to get this data from a format that is easy for the sites to complete to somthing i can migrate into the payroll system. The layout of the worksheet is as followsĬells A to G contain employee details (Name, Job Code, Payroll Number, Location of work etc)Ĭell H is unique to each worksheet and indicates the week commencing dateĬells I to Y contain the payroll data I am asking sites to complete. The data sheet is identical for each location with a separate tab for each week they are collating for. This involves requesting 6 locations to complete a data collection exercise each week.
I am collating a large amount of data for a payroll system change over. However I cant find a way to solve this issue. I have been dipping in and out of this forum for a while and generally find the answers I need from other posts. With Application.FileDialog(msoFileDialogFolderPicker) I really appreciate any help you can give me!ĭim myDir As String, fn As String, temp As String, ref As String Please tell me anything you need that will make this easier for you! I will do my best to accomodate. Maybe first things first, how can i change the original macro, listed below, to look at the names of the worksheets and pull them as headings for my report? This is quite tricky to explain in words and i wish i could show you, but i don't know how. Whereas originally, the cells being pulled each time where the same in each workbook, i now need to create a macro that will look into a workbook and pull the names of multiple sheets for use as headings, and pull cells from an array that will be different in size for each workbook. I know have a similar issue that expands upon this idea, yet seems to me be slightly more difficult. You helped me a while ago putting together a macro in the thread, "Combining Multiple Cells in Multiple Worksheets in Multiple Workbooks into one Table", which, as the thread name indicates, collected specific cells from multiple workbooks and put them into one workbook for me. I am below Zero when it comes to VBA, so please help me out.
#How to make excel find duplicates and combine code#
(Instead of this code I need a code which will copy all the workbooks not just one, and the code should not delete the source file or any of its contents) I am looking for a code which will move all the sheets in the directory to one single workbook and the source workbook should remain intact. Now I think nobody will post a reply to my question in that thread, so I am starting a new one. I found this code in a similar (2 year old) post by someone in this forum. Set wbSrc = Workbooks.Open(Filename:=MyPath & "\" & strFilename) StrFilename = Dir(MyPath & "\*.xls", vbNormal) Set wbDst = Workbooks.Add(xlWBATWorksheet)
0 kommentar(er)
