Help with excel spreadsheet - formulas/macros/VBA

Kapalı İlan edilme: 3 ay önce Teslim sırasında ödenir
Kapalı Teslim sırasında ödenir

See attached spreadsheet

Be able to select from the drop down box ( from one area at a time only) across all three of the following tabs ( including the Title, Access and Total Hours):-

i. Mandatory Education

ii. Role Requisite

iii. Cont Prof Learning

To populate into the REF Template tab – is it possible to have it populate under the different titles creating a new row each time.

I.e REF TEMPLATE TAB: - Staff Mandatory Education Once only F2F

SCHHS Orientation

F2F / LOL

2.50

SCHHS Staff Local Induction

F2F

8.00

Aboriginal & Torres Strait Islander Cultural Practice Program

F2F / LOL

6.00

In this example it would only have been for area 3C

TRAINING

ACCESS

TOTAL HRS

3A

3B - COVID WARD

3C

ALL STAFF MANDATORY EDUCATION

TOTAL HRS

ACCESS

25.55

Complete Training Once Only

SCHHS Orientation

F2F / LOL

2.50

Yes

Yes

SCHHS Staff Local Induction

F2F

8.00

Yes

Aboriginal & Torres Strait Islander Cultural Practice Program

F2F / LOL

6.00

Yes

Cultural Diversity

LOL

0.25

Person Centred Care

LOL

0.25

No

Prevention & Management of Musculoskeletal Disorders

LOL

0.30

There will be data under other areas in these tabs as this eventuates however only want to be able to populate the information from one column at a time into the REF template.

Excel Visual Basic Uygulamalar için Visual Basic Veri İşleme Veri Girişi

Proje NO: #37471756

Proje hakkında

29 teklif Uzak proje Aktif 2 ay önce

Bu iş için 29 freelancer ortalamada $35 teklif veriyor

schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look Daha Fazla

$70 AUD in 2 gün içinde
(604 Değerlendirme)
8.5
nimiwebjuggler

Hi, I'm an Expert Virtual Assistant providing services of Data Entry, Web Research, Data Mining, Data Processing, PDF conversion, Microsoft Office work, Photoshop work, and much more! I have experience of more than 2 y Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(166 Değerlendirme)
6.8
DaveHub2020

Hi, I'm good with numbers and excel. Thus the work is doable with good quality. Looking forward to hear from you.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(35 Değerlendirme)
5.2
mobimubasir

Hello. I read your requirement and also check attachment i will do that. Please come on chat we will discuss more about this. I will waiting your reply.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(22 Değerlendirme)
4.4
Zakwan555

Hi, I am an experienced certified Cost And Management Accountant and i have more than 7+ years' experience in professional domain. I have gone through your project with interest and it seems a perfect match with my ski Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(10 Değerlendirme)
4.1
sudip20simkhada

Hello! My name is Sudip Simkhada and I am a BIM Graduated with IT course. I have extensive experience in data entry and can help you complete your project. I have extensive knowledge in Microsoft Office including Wor Daha Fazla

$20 AUD in 7 gün içinde
(9 Değerlendirme)
3.1
CanadianQuality

Native English speaker, Excel expert. Are you ok with using VBA here for data validation or are you looking to use only native Excel functions?

$50 AUD in 2 gün içinde
(4 Değerlendirme)
3.1
fonkij

I am an Excel / VBa/ Macros specialist. Please grant me this opportunity to show the best my hands can produce. I look forward to hearing from you sir

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(2 Değerlendirme)
2.1
yassineLMNH

Hello, I’m an experienced statistician and data analyst with expertise in VBA-Excel. I've successfully delivered custom solutions in my previous work. If you're interested, feel free to reach me on chat...

$50 AUD in 2 gün içinde
(2 Değerlendirme)
0.8
khizarhayar50

Hello there! My name is Khizar and I am an experienced Data Analyst, Virtual Assistant with 12+ years of experience in providing administrative, data entry, and Microsoft Office support to businesses of all sizes. I un Daha Fazla

$20 AUD in 7 gün içinde
(1 Yorum)
0.1
TonyPraise

Proficient in Excel, offering expertise in formulas, macros, and VBA. Committed to optimizing your spreadsheet tasks for enhanced efficiency and accuracy.

$25 AUD in 2 gün içinde
(0 Değerlendirme)
0.0
dzunekoharmony

Hello, and thank you for considering me for this project. I understand that you are looking for someone who can help you with your excel spreadsheet - formulas/macros/VBA. I believe that I am the perfect fit for this p Daha Fazla

$20 AUD in 7 gün içinde
(0 Değerlendirme)
0.0
Mhh034

I have 12 years experience and I work very fast and I will give you the best results and I have enough time to do all your job

$60 AUD in 2 gün içinde
(0 Değerlendirme)
0.0
pritam5674

I work as a proficient data entry operator, consistently maintaining a 90% accuracy rate in my tasks. My role involves meticulously inputting and managing data with a high level of precision and attention to detail. I Daha Fazla

$20 AUD in 7 gün içinde
(0 Değerlendirme)
0.0
SUFIABID1

Hello dear sir/ man I am excited to do this project I have almost 9+ years experience into this field and I have good hold on Excel formulla and active x controls . I feel good if u choose me for this proj ct also u ge Daha Fazla

$20 AUD in 7 gün içinde
(0 Değerlendirme)
0.0
ElvanLing

Hi I'm an engineer doing various projects in Australia. Using excel is one of the basic and the requirement you requested is considered easy. I can help you with it with no mistakes. I have extensive knowledge in data Daha Fazla

$30 AUD in 7 gün içinde
(0 Değerlendirme)
0.0
danielenm5

Strategic Management, Training, Public Speaking, Audiovisual Tools, Technical Computing, Intermediate Programming, Marketing, Social Networking, Quality of Service, Languages (English-Spanish), Sports Promoter (Footbal Daha Fazla

$20.01 AUD in 7 gün içinde
(0 Değerlendirme)
0.0
mostafamojarrad

I’m working in a company in Canada as an accountant and I can do it as soon as possible the project

$25 AUD in 7 gün içinde
(0 Değerlendirme)
0.0
danielfahey1981

Greetings Dear Client, Welcome to my profile, Home to Professional and Quality services with 100% customer satisfaction guarantee. I'm a Certified & Experienced Expert in the respective project requirements. Dear Clie Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(0 Değerlendirme)
0.0
maneesh1280

Hi, I reviewed and understand your proposal and I assure you that I can work on your project as per your requirements. I have a typing speed of more than 50 in English. I also have a good knowledge MS Excel. I have Daha Fazla

$20 AUD in 7 gün içinde
(0 Değerlendirme)
0.0