Find Jobs
Hire Freelancers

Need an Excel wizard to create automated macro helping me with data update

$2-8 USD / hour

İptal edildi
İlan edilme: neredeyse 5 yıl önce

$2-8 USD / hour

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: 30-40 USD
Proje No: 19776690

Proje hakkında

7 teklif
Uzaktan proje
Son aktiviteden bu yana geçen zaman 5 yıl önce

Biraz para mı kazanmak istiyorsunuz?

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin
Çalışmanız için ödeme alın
Teklifinizin ana hatlarını belirleyin
Kaydolmak ve işlere teklif vermek ücretsizdir
7 freelancers are bidding on average $10 USD/ saat for this job
Kullanıcı Avatarı
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$5 USD 8 gün içinde
4,9 (342 değerlendirme)
8,0
8,0
Kullanıcı Avatarı
Hello there, I am an Excel expert and I can do this task for you. I can create macro as you need. Please send me the file and we can continue discuss. See the picture very hard to understand your idea. I can start right now. Thank you.
$40 USD 1 gün içinde
5,0 (139 değerlendirme)
5,9
5,9
Kullanıcı Avatarı
Hi, My name is Virendra. An Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radio Buttons, List Boxes etc. in excel VBA. I also have expertise in Manipulating and Exchanging Data in Multiple Sheets, Using Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. I have done mostly Excel VBA Programming jobs. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start, please message me to discuss your project in more details. Thanks, Virendra
$5 USD 40 gün içinde
4,8 (94 değerlendirme)
5,7
5,7
Kullanıcı Avatarı
Excel VBA expert. I have many experiences. I can complete your project successfully. I'm software engineer and algorithm expert. I'm fullstack website developer and database manager. Thanks.
$5 USD 40 gün içinde
4,8 (11 değerlendirme)
4,2
4,2
Kullanıcı Avatarı
Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned. I'm also fluent in typing which make the project finish as soon as possible. I demonstrate exceptional abilities to work with people of diverse backgrounds. Highly competitive self-starter, organized, disciplined and goal oriented Please provide more details regarding the work. Thanks.
$5 USD 40 gün içinde
5,0 (1 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
Hi Sir, I have a good experience of working in excel with or without macros containing thousands of records. VBA is my hobby and I am sure we can figure out your required solution. I would suggest you to recheck your uploaded images as these are not readable. Better to provide the relevant file or at least lets have a project assessment meeting to cover all your requirements. Please let me know if you have any queries. Regards, Danish Rehman
$8 USD 20 gün içinde
0,0 (1 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
I am professional in Excel and will offer you high quality
$5 USD 10 gün içinde
0,0 (0 değerlendirme)
0,0
0,0

Müşteri hakkında

   POLAND bayrağı
Krakow, Poland
3,2
17
Ödeme yöntemi onaylandı
Haz 7, 2012 tarihinden bu yana üye

Müşteri Doğrulaması

Teşekkürler! Ücretsiz kredinizi talep etmeniz için size bir bağlantı gönderdik.
E-postanız gönderilirken bir şeyler yanlış gitti. Lütfen tekrar deneyin.
Kayıtlı Kullanıcı İlan Edlien Toplam İş
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ön izleme yükleniyor
Coğrafik konum için izin verildi.
Giriş oturumunuzun süresi doldu ve çıkış yaptınız. Lütfen tekrar giriş yapın.