I need to a super excel sheet created that will automate a lot of the tasks I have to do. From my understanding, it will need to used LOOKUP, FLASH FILL and MACROS, I may be wrong.
The following tasks are the ones which need automating:
-When creating something similar to a 'Receipt' I need an excel sheet that can LOOKUP 3 sets of data from an Excel sheet that is basically an inventory. I need to start typing a description in column A which will FLASH FILL, and then from the description Columns B, C and D will be LOOKUP filled from the inventory spreadsheet.
-I then need a MACRO that will prompt 'Save as' the document so I can save the document separately to another folder. I would also like some more basic MACROS added in to do with formatting e.g. Auto wrap text, auto adjust rows and columns
-I understand that the freelancer will understand Excel better than me, so once I choose a freelancer I hope that they can ask me about the project and look for things to add that will make it work even better.
71 freelancere byder i gennemsnit $125 på dette job
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. Willing to take up your project. Thank you, Regards.
I am good at Excel formula and VBA/Macro, I need to see the data so I can understand your requirement, I might have a few question to discuss so I need you to send a message on chat. ...