Assist with excel macro development for data processing with autofilter
- or -
Post a project like this2469
$$
- Posted:
- Proposals: 9
- Remote
- #1571544
- Awarded
SEO , Word Press , Picture Editor & Re-touch , Content Writer, Guest Posting, business support, Business DATA , Google ranking
Faisalabad
5066681974143588351470486495750797980694157798684610
Description
Experience Level: Intermediate
General information for the business: We are a tapas bar and restaurant
Kind of development: Customization of existing program
Num. of modules: 1
Description of every module: Hello,
We are a small tapas bar and restaurant. I have developed a macro enabled spreadsheet which assists me with analysis of our weekly sales in the bar.
At the end of each working week, I download a CSV file from our epos system, which shows all of the items that we sell in the bar each week along with info such as "category" (i.e. red wine, white wine, veg tapas etc), the staff member that sold the item, other info about the sale etc etc.
I load this data into the spreadsheet, and have a macro which processes it into a more usable tabulated form. There is a data entry sheet in the workbook, into which the info is pasted, then on running the macro it starts a new sheet with the appropriate week number (by copying the previous week's worksheet and incrementing up the week number), it then uses autofilter to process the data and populates the new sheet with the new week's data. The macro takes this large single table of raw data from the input sheet and processes it to show how many of each item are sold on any particular day.. for example, how many pints of San Miguel we sold on the Tuesday of that week. This part of the macro which I have written is working fine.
From this first round of data processing, I now want a second layer adding. I have started this, and have had it working, but there are a couple of bugs in it which are leading to inaccurate information. The second layer is to process the data to show the number of items sold in each category in the whole week, and then also daily. For example, we sold 134 meat tapas items all week, 32 on Monday, 18 on Tuesday etc etc. I would then also like to complete the same processing task based on staff members making the sale transactions. All of this info is included in the raw data.
Description of requirements/functionality: I would like someone to assist us to get the functionality required, which I could do myself but it takes me a very long time as I am not a VBA expert. I feel it should be a fairly straightforward task for someone with a VBA background - something which I cannot say about myself!
Extra notes:
Kind of development: Customization of existing program
Num. of modules: 1
Description of every module: Hello,
We are a small tapas bar and restaurant. I have developed a macro enabled spreadsheet which assists me with analysis of our weekly sales in the bar.
At the end of each working week, I download a CSV file from our epos system, which shows all of the items that we sell in the bar each week along with info such as "category" (i.e. red wine, white wine, veg tapas etc), the staff member that sold the item, other info about the sale etc etc.
I load this data into the spreadsheet, and have a macro which processes it into a more usable tabulated form. There is a data entry sheet in the workbook, into which the info is pasted, then on running the macro it starts a new sheet with the appropriate week number (by copying the previous week's worksheet and incrementing up the week number), it then uses autofilter to process the data and populates the new sheet with the new week's data. The macro takes this large single table of raw data from the input sheet and processes it to show how many of each item are sold on any particular day.. for example, how many pints of San Miguel we sold on the Tuesday of that week. This part of the macro which I have written is working fine.
From this first round of data processing, I now want a second layer adding. I have started this, and have had it working, but there are a couple of bugs in it which are leading to inaccurate information. The second layer is to process the data to show the number of items sold in each category in the whole week, and then also daily. For example, we sold 134 meat tapas items all week, 32 on Monday, 18 on Tuesday etc etc. I would then also like to complete the same processing task based on staff members making the sale transactions. All of this info is included in the raw data.
Description of requirements/functionality: I would like someone to assist us to get the functionality required, which I could do myself but it takes me a very long time as I am not a VBA expert. I feel it should be a fairly straightforward task for someone with a VBA background - something which I cannot say about myself!
Extra notes:
David M.
100% (13)Projects Completed
16
Freelancers worked with
13
Projects awarded
59%
Last project
9 Aug 2017
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
I would like to assist you with this task, unfortunately I am not free until tomorrow at the earliest.
If you could send me the file so that I can look at the scope of work involved I will get back to you with a proposal.
Regards
Tony H
417721
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies