Need an Excel wizard to create automated macro helping me with data update -- 3
$10-30 USD
ที่ทำเสร็จแล้ว
โพสต์ เกือบ 5 ปีที่ผ่านมา
$10-30 USD
ชำระเงินเมื่อส่งงาน
I have a quite big spreadsheet with several tabs.
The main tab is called "ratings"
There are several named ranges inside the "ratings" tab with same names as names of other tabs in the spreadsheet
This is the photo of the example named range inside ratings tab called "NorTL"
[login to view URL]
Pls note the numbers outside the range (below "average" from 0 to 4), will move to them now:
This is how tab called "NorTL" looks like
[login to view URL]
So the key is, to have a macro, which will automatically "apply" values changes listed in blue cells into ratings tab.
For example, if we take first row Stromgodset Mjondalen
Value in column A (green column) = 3 so that means macro has to edit following cells:
[login to view URL]
Let's call column with numbers from 1 to 16 column A and the next column is column B
Back to the tab with blue cells: first blue cells means adjustment for home team (Stromgodset) which should be applied in column A, second blue cell is adjustment for away team, again applied in column B, third blue cell is an adjustment for home team applied in column B and fourth blue cell is an adjustment for away team which should be added automatically by the macro in column B
So for example from screenshot above, after running macro for this game, updated values should look like this:
[login to view URL]
Pls note that for this particular example values in column B are unchanged because values in 3rd and 4th blue cells = 0.00
The biggest challenge here is:
- how to "teach" macro to always find a correct named range inside "ratings" tab
- how to "teach" macro to always find a correct spot inside the named range for applying value changes
Ideally I would like the macro to run numbers update for all games (so for example, if inside the sheet NorTL, in cell B1 there is value "3", macro should run updates for all games which has number "3" added in the first column
Budget for this job is: 20-30 USD
Good morning,
I have reviewed you images and requirements and am confident I can deliver this to you quickly. Using Index and Match, we can easily identify only the cells that need to be changed from each edit, and update them.
I have more than five years of experience working with macros - and your satisfaction is my absolute aim. I will only be happy when you are happy!
Do send me a message and we can confirm I fully understand your requirements; I am happy to deliver this to you by the end of tomorrow (Monday.)
All best,
John Boothby
All best
My approach with regard to your requirements -
- The aim is to develop a workbook application with macros to perform substitution of values based on cell-matching criteria.
- We will need to assign meaningful (or dummy) names to the values in important cells, so that we have clarity around the matching and updating rules.
- We will also need to discuss all possible matching scenarios in detail so that I am clear about it.
- I will code subroutines and assign them to buttons if you like so that the refresh can happen with a single click.
Note - I can complete this within 1 day, but I cannot begin before Tuesday, 28 May.
Similar work I have done --
Dashboards and calculators for project management, financial calculations, software testing, etc
My strengths --
- several years' experience with Excel VBA development and always excellent feedback from my clients.
- easy to communicate with.
- bottomline responsibility for delivering on-time and with high quality of work.
- I am new to freelancer and eager to establish my credentials, hence the low quote. I will do everything possible to make your project successful