See attached template.
On the daily worksheet
- Add a way to "select" either a home or away team in column E or O such as radio button or other method (where cells are currently marked x).
- Write a macro so that when the "update tracker" button is pressed it will take the data in the daily table and populate columns A-F & H-L in the first blank rows in the tracker worksheet for any rows with a selection marked.
- Column M in the tracker worksheet will be populated with either "Home" or "Away" based on whether the selection in the daily worksheet is selected in column E or O. E = "Home", O= "Away"
This will be an ongoing tracker so the data in the daily table will change each day and I want the tracker to be added to each day so the previous day's data is not replaced.
Please read and review file and advise if this is possible with a macro and a quote to do so.
Hi. The requirement seems simple. The data from the daily sheet has to be updated in the tracker sheet based on the selection of home or away.
I have excellent credentials in Excel Modeling. I am an MBA in Finance and Marketing.
$30 AUD en 4 días
5,0 (1 comentario)
0,5
0,5
5 freelancers están ofertando un promedio de $42 AUD por este trabajo
Hi,
I am good at Excel and vba macro. Looking forward to work on this project. I have gone through the instructions and excel file.
I would like to discuss further to start working on.
Hi
I have read out all the details given in your project and I am fully capable to deliver you this project with 100% accuracy. I have completed many projects related to this in the past. Why you do not knock me here for further detail? You can release the milestone after checking the work.