Hi
I have following date-set, I have two Excel Binary files with multiple sheets based on my input data, existing binary files should be replaced in the Main sheet.
Each file has been attached with expected output main sheet
Based on the File name from below data, Main sheet from each file should be filled as per expected output sheet.
| Sl no | Credit | Debit | File name |
| 1 | 10 | | Chair |
| 2 | 20 | | Chair |
| 3 | | -10 | Chair |
| 4 | | -20 | Chair |
| 5 | 100 | | office |
| 6 | 200 | | office |
| 7 | | -100 | office |
| 8 | | -200 | office |
Since community not supporting to upload Excel binary worksheet
I am attaching normal excel file. But my output should be in existing Excel binary worksheet.
in my original data I have 40 files
is it possible to build batch macro, to output data based on file name column.
