Excel VBA data transfer between workbooks
Hello. It would be great if someone can provide the VBA code so I can transfer data and conditional formatting from a source file that has multiple sheets to a master file that has one sheet. The source data will always be in A1:C1 on all the sheets. The Master file has one sheet and a row for each sheet from the source file. For example, sheet 1 (named "Red") in the source file will have data in A1:C1 and the data for Red needs to be transferred to the Master file in the Red row. sheet 2 (named 'Yellow) in the source file will have data in A1:C1 but needs to be transferred to the Yellow row in the master file. Hope this makes sense.
2 Attachment(s)
Excel VBA to transfer data from source files to one master file
Paul, thank you for the quick reply. I attached an example source and master file. I would like a VBA program to feed the data and conditional formatting from the source file to the master. The data in the source file will be updated regularly and will need to be updated in the master. I will have multiple source files. I would like to the VBA program to search / loop for the project name from the source file and find it in the master to update that row. Thank you!