Excel VBA Macro Automation Needed for Stock Take and to Generate Reports
$30-250 AUD
In corso
Pubblicato circa 11 anni fa
$30-250 AUD
Pagato al completamento
Hi all,
We have an Excel with : (See file : stock take and [login to view URL])
1) Product initial stock details
2) Cost Price
3) We can also input the sales data into it and it will tell us how much we earn per piece and also which of it needs to be restocked
And everyday we get a sales data in an excel , see file : [login to view URL] ,
Now, we want an Excel Macro that automates all of this, it should:
1) Automatically import in the relevant data from sales data into the stock take and profit excel
2) Generate a report showing:
i) Total earnings of the day
ii) List of items that needs to be restocked
iii) Highest selling priced item
iv) Lowest selling priced item
v) Most sold item of the day
vi) Result errors, such as product code unknown, price unknown etc etc
There's a few things to consider
a) Stock take and [login to view URL] will have some columns with that "remembers" day to day changes, such as stock level, total quantities sold
b) Some products are more troublesome, for example if we have sku 900 and sku 901, it's easily done, but sometimes we sell them together, like 900+901, it will be quite troublesome to have a separate sku called 900+901. We are open to suggestions on how to solve this :)
Please feel free to have your input on this and we are also open to suggestions if you have better ways of doing what we want.
Thanks again,
Edmond.
More than 15 years of programming experience. Professional VBA solutions and webscraping, data mining and automated bots. Please check a few sample works in PM. Best regards Filipe Francisco , VB Expert ============================== Tablassus Software "Simple Solutions for Complex Problems"
Dear Sir,
I am interested to work on this project. I have more than 10 years of exp in software development field. I have good experience in Lotus Notes, VBA, Crystal report, MS SQL and MySQL. I have also good experience to parse the xml using the VBA , Lotus Script and update in mysql / MS SQL.
Please refer the private message for more details.
Excel (inc VBA) expert here (and teach the same). Am currently finishing off two business related spreadsheets (cashflow related) and am available for start probably tomorrow. My pedigree in your PM. SteveP.
Hi Daracon,
I can very well do this project. I saw both the sheets and have some
ideas on this. Please refer to your PMB for further details and
attachments. I am sure you are gonna love this :)
Regards
P
I am a successdul freelancer with 20 years experience with excel and also know visual basic (VB). Automating data transfers from one excel file to another is a process I know very well, as well as creating necessary reports / metrics needed from the master file/spreadsheet. Ready to start immediately. See PMB for more details
Understood your project requirements. Ready to create automate task. We're professional Excel VBA Macro expert, and our solution for will complete your project. So, consider our bid to get started.
Regards