Help with excel spreadsheet - formulas/macros/VBA

Ditutup Disiarkan 3 bulan lepas Dibayar semasa penghantaran
Ditutup Dibayar semasa penghantaran

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 Visual Basic untuk Aplikasi Pemprosesan Data Pemasukan Data

ID Projek: #37471756

Tentang projek

29 cadangan Projek jarak jauh Aktif 1 bulan lepas

29 pekerja bebas membida secara purata $35 untuk pekerjaan ini

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 Lagi

$70 AUD dalam 2 hari
(604 Ulasan)
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 Lagi

$29 AUD dalam sehari
(166 Ulasan)
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.

$30 AUD dalam sehari
(35 Ulasan)
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.

$30 AUD dalam sehari
(22 Ulasan)
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 Lagi

$100 AUD dalam sehari
(10 Ulasan)
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 Lagi

$20 AUD dalam 7 hari
(9 Ulasan)
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 dalam 2 hari
(4 Ulasan)
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

$30 AUD dalam sehari
(2 Ulasan)
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 dalam 2 hari
(2 Ulasan)
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 Lagi

$20 AUD dalam 7 hari
(1 Ulasan)
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 dalam 2 hari
(0 Ulasan)
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 Lagi

$20 AUD dalam 7 hari
(0 Ulasan)
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 dalam 2 hari
(0 Ulasan)
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 Lagi

$20 AUD dalam 7 hari
(0 Ulasan)
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 Lagi

$20 AUD dalam 7 hari
(0 Ulasan)
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 Lagi

$30 AUD dalam 7 hari
(0 Ulasan)
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 Lagi

$20.01 AUD dalam 7 hari
(0 Ulasan)
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 dalam 7 hari
(0 Ulasan)
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 Lagi

$30 AUD dalam sehari
(0 Ulasan)
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 Lagi

$20 AUD dalam 7 hari
(0 Ulasan)
0.0