hello, i need some help and training on vba / excel.
basically i have multiple input files from "source A" and one output workbook from "source b"
i need to check that the input files match the output workbook that has 15 worksheets.
there are 280 input files that are in csv format and there is one output excel workbook that is created with 15 worksheets, however many of these files are similar are combined and categorised under each worksheet that is different category that of course has key identifier in csv file name, some of the input files have many column headings, upto 50 headings for example that need checked that made it to output file.
so the script needs to check all rows and columns.
i also need to check all csv file data with correct columns has been correctly imported into the workbook.
some sort out output comparison results file needed that demonstrates which files, data and columns not properly mapped or are missing.
also appointed freelancer would recommend how to fix problems from "source b".
Hi, bro! I've read your requirement. I have rich experience with data processing using Excel vba and formula. I have finished many projects like this. I'm confident in your project and I promise to do your projec Daha Fazla
Hello, i am expert in this kind of jobs samples of my excel VBA jobs https://www.freelancer.com/projects/excel/Create-Excel-Spreadsheet-Macro-that/ https://www.freelancer.com/projects/excel/Make-VBA-code-run- Daha Fazla
Bu iş için 18 freelancer ortalamada $111 teklif veriyor
Hi, please send the csv and the excel files A and B. I will sort out the bugs and can deliver the output along with a complete explanation of the VBA code within a day. I can start the work right now. Thank you.
Hi, for your multiple input, I think we need a kind of an input module to makeit automatic and easier. for anothers I think it just some ordinary script. Lets discuss further if you think so...