Simple macro for Excel
Budget: $10 – $30 AUD
I am looking for a freelancer to create a simple macro for Excel to automate data entry. The ideal candidate should have experience in creating macros and be proficient in Excel 2010, Excel 2013, or Excel 2016 or newer. The specific data that needs to be entered will be sourced from another Excel sheet. The macro should be designed to streamline the data entry process and reduce the potential for errors.
Two files are attached. The macro needs to match the codes in columns A in both files and then take the associated number in column G in the Plan A Stock on Hand summary file (the available to promise number) and drop that next to the matching code in the Cin7 export file in column E (Count)
Two files are attached. The macro needs to match the codes in columns A in both files and then take the associated number in column G in the Plan A Stock on Hand summary file (the available to promise number) and drop that next to the matching code in the Cin7 export file in column E (Count)