Fermé

Excel Formula to transfer Data in one format to another

Task A - you need to create a formula in excel that will automatically transfer data from weekly report (input) file (columns F to GX) to the format shown in TS Output tab. Both files are in .xlsx format. 4 sample "dummy employees" are already shown in the TS Output tab as a guide (but were just entered manually).

Task B - you need to create a formula in excel that will automatically transfer data from weekly report (input) file (columns GY to HI) to the format shown in Leave Output tab. Both files are in .xlsx format. 4 sample "dummy employees" are already shown in the Leave Output tab as a guide (but were just entered manually).

Notes on the tasks:

- weekly report file pertains to employees' work hours and applied leave during a given week. Hours worked and leave applied for the whole week are presented per employee per row in excel.

- TS output and Leave Output tabs are basically the same with the weekly report file, but the worked hours and applied leaves should be presented per employee per day per row in excel.

- Sample data provided covers 1 to 7 April 2019. Workday starts with Monday and ends on Sunday.

- Date format should be in dd/mm/yyyy.

- Data on the weekly report (input file) are varying every week, so the formula range should be editable.

- Column headings on the Weekly report (input file), TS Output and Leave Output files are standard and should not be changed.

Compétences : Saisie de Données, Traitement de Données, Excel, Architecture Logicielle, Visual Basic

en voir plus : transfer data from one excel workbook to another automatically, how to copy cells from one sheet to another in excel using formula, how to copy data from one cell to another in excel automatically, excel copy data from one sheet to another automatically, how to automatically update one excel worksheet from another, how to transfer data from one sheet to another in excel using macros, how to copy from one excel sheet to another with formula, how to automatically update one excel worksheet from another sheet, write code transfer data sql server excel, transfer data excel multiple sheet access table, transfer data excel word, excel formula capture data time day, transfer data excel works word, transfer data excel word vba, transfer data excel word using vba, fnma data format excel, excel macro check data format, excel check data format, excel macro paste clipboard data format, excel transfer data sheet sheet

Concernant l'employeur :
( 5 commentaires ) Muntinlupa City, Philippines

Nº du projet : #19833397

28 freelance font une offre moyenne de $29 pour ce travail

P0L

Hello, I’m an Excel expert and I would like to help you with your formula. Please check my profile and contact me to discuss further details. Regards.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(303 Commentaires)
7.2
polarjin2017

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. This is what i have done in Excel/VBA/MACRO. Just Creating forms, query, Macro, custom formula, etc... https Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(138 Commentaires)
7.0
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Willing to take up your project. Thank you, Regards.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(106 Commentaires)
6.2
TechnoGuruu

Hi, As per requirements I will develop formulas for you as per description of the project. Please share your Excel sheet. I have expertise in Excel, formulas, Excel VBA and finished many such projects. Quality work Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(80 Commentaires)
5.7
nvchien94

Hello there, I am an excel expert and I can create VBA macros to do this task for you. I did over 300+ project and I can complete 2 tasks in few hours. Please contact and we can start right now. Save your time and get Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(96 Commentaires)
5.4
bluesea1990

Hello. Welcome! I'm excited that you’re here! ✅ I have fully read the task, and assure that I can complete the task with no error. ☻My idea :" It proves that the best food is honest food, made to uncomplicated recip Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(15 Commentaires)
4.5
SousaTranslation

Hello I have had experience creating formulas similar to this one, reshaping the format and transfering from one sheet to another. Would you like a button to transfer data or just that the tabs would automatically upda Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(14 Commentaires)
3.8
razvancotofana

Hi there, I'm well experienced in excel and vba and I'd like to help you with your project. I've done a small trial on your file and I can show you a sample. I think I can give you the format within 1-2 days. Please fe Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(8 Commentaires)
2.3
bizzmaven

Dear Recruiter, I have taken time to go through your file and the sheets "Weekly report(input)" , TS output and Leave output. I am very good at Microsoft excel and linking sheets to others which make the output sheet Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(3 Commentaires)
1.4
ovaissss

Hey there, I have read details regarding your project and willing to provide you my services. I can provide you quality work with in limited deadlines. I have been working as an reporting officer for 7 years and have g Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(1 Évaluation)
1.2
viswanath28

having morethan 15+ yrs of exp in excel. and visual basic programing.. delivered many solutions in HR domain also i am confident that.. can handle the task and deliver ontime hope you will conract me back to discuss Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(1 Évaluation)
1.0
diepkha

hi I have a lot of skills in processing data in Excel VBA. You will get the correct and fast data. VBA Excel can make very quickly.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(1 Évaluation)
0.6
keyjslider1

Hi! Would probably do in a day. 20 years pro experience in Excel, Excel VBA programming skills - have been dealing with trickiest tasks over huge data massives for a long time. Strong programming experience, high mathe Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(0 Commentaires)
0.0
mos222yas

I'm Mostafa Gamal, FP&A Section head, CMA holder, Financial Modeler and Excel, Word and powerpoint power user. I'm responsible for feasibility studies, BOD presentations, financial analysis and valuation, dynamic finan Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(0 Commentaires)
0.0
prashantbverma7

Hey, Prashant here! I won’t waste your time with a long pitch on why you need to hire me for job. I am able to provide macros that helps my client to fetch data with a click of button because as a freelancer I unders Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(0 Commentaires)
0.0
bluesther29

hello, I have various excel experience in my career, I am pretty that I can fulfill your need, appreciate you could consider me.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(0 Commentaires)
0.0
gvantsakhurtsia

hi, i'm interested in this job.. . if you agree let me know... thanks for attention... good luck....

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(0 Commentaires)
0.0
rohitparmar9333

Dear Hiring Manager, I will return your 50% money to your account. Please give me a chance to show my skills. Thank you for posting your job opening for Data Entry. I have five years of data entry experience and I have Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(0 Commentaires)
0.0
EML2

Hi Sir, I'm really interested in your proposal and I'm a Freelancer enthusiast even if at my first experiences. Hope you will appreciate the slow price and quick time release

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(0 Commentaires)
0.0
zhabizi92

Hello, I see that you're demanding a very simple task to automatically transfer data in an excel file. I'v been an expert in Excel for more than 4 years. Creating macros and using VBA to create automated excel sheets Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 5 jours
(0 Commentaires)
0.0