Fermé

Clean up Excel spreadsheet which has a summary page, Master sheet and attached workbooks.

Hi. I think what I want are pivot tables which update each other. There are 6-10 individuals working on the same main goal. Each individual has their own tab to track their work.I want the information on the workbooks to automatically update the Master, and the information on the Master to update the correct worksheet. Also, there needs to be one new tab created and the numbering column on the Master needs to be corrected (unless I jump in and get it done first!) For someone who knows Excel and pivot tables cold, I don't think it is a tough job.

Compétences : Saisie de Données, Traitement de Données, Excel, Microsoft Office, Visual Basic

en voir plus : convert web page excel spreadsheet, post excel spreadsheet web page, convert excel spreadsheet work web page, excel pull data from another worksheet, how to link two excel workbooks together, excel pull data from another workbook, how to add data from one sheet to another in excel, how to automatically update one excel worksheet from another sheet, how to pull data from multiple workbooks in excel, transfer data from one excel worksheet to another automatically, update excel spreadsheet with data from another spreadsheet, create sheets excel using master sheet, pasting web page excel spreadsheet, export excel spreadsheet web page, excel spreadsheet sheet protect script, macro copy currently open html page excel spreadsheet, html format cut data excel spreadsheet web page, clean excel sheet applications, turning excel spreadsheet macros web page, upload excel spreadsheet find google page ranks urls

Concernant l'employeur :
( 0 commentaires ) Burlington, United States

Nº du projet : #19606518

30 freelance font une offre moyenne de $137 pour ce travail

schoudhary1553

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. Pl Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(337 Commentaires)
7.9
Webxpert4u

Can I have all the files? and can you name please the master, and which of the other workbooks populate it? also do you want this action to be totally automatic or you want a button so you can decide when to update the Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(299 Commentaires)
8.0
mirniyazuddin92

Hi there, I can clean up Excel spreadsheet which has a summary page, Master sheet. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(393 Commentaires)
7.9
paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have some functional pivot tables in an Excel workbook. I will charge you $150 and can Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(206 Commentaires)
7.2
polarjin2017

Hello? I have gone through the job details carefully and I am excited to start working on this project. I am ready to start work immediately. I've worked a lot of jobs with it. So I think I can help you if you want. T Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(86 Commentaires)
6.6
ShaunKleinOnline

Hi there, I am an Excel expert with over 17 years of experience specializing in advanced formula and function modelling along with pivot table creation and maintenance which I think would serve me well in this collabo Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(84 Commentaires)
6.5
asadkhan3533

Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thanks, Asad Khan

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(132 Commentaires)
6.4
TechnoGuruu

Hi, As per requirements I will develop pivots and automated master board as per description of the project. Please share your Excel sheet. I have expertise in Excel, formulas, Excel VBA and finished many such proje Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(77 Commentaires)
5.7
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(99 Commentaires)
5.7
rIbrarahmed

hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit myse Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(20 Commentaires)
4.3
xinglong717

Hi, How are you today? I have just read your job description carefully and I am very interesting in your job. I am a senior Excel,VBA,C,C++ ,C# developer with 10 years experiences and I have developed many program of u Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(9 Commentaires)
4.1
paulodayto08

Hi Good Day! A serious freelancer here. I've done a lot of work like this one before. I can help you to complete this project with high quality. With my experience as a VBA Macro developer for 8 years I can give you Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(20 Commentaires)
3.6
romanapanovich

I can provide it only in Google sheets

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(2 Commentaires)
3.5
arash18k

Hi, so you want data from tabs (which is for each individual) be entered automatically in the right place of master tab, also you have some data in master tab that you want to be entered in the right place in each tabs Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(7 Commentaires)
3.5
emilianoreyes70

Hi Yes we can! it can be done using Pivot Tables also programming macros could consolidate on the master Work book the data you want to view. Im glad to see the proyect and give advice (no charge) about the easiest wa Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(1 Évaluation)
2.4
NewFuture338

Hello, I am good in excel, Can you send me excel files and I want to discuss before starting. I am ready to cleanup excel files with updating. I am sure, I can give you best solution. Highly experienced in Excel Progr Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(2 Commentaires)
2.8
towettjulius31

hallo, i have experienced on the work you mentioned and if you can try my expertise hope you will like. Please give a chance. Thanks hallo, i have experienced on the work you mentioned and if you can try my expertise Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
MLJ88

Hello, as a highly skilled and experienced Excel user I am constructing pivot tables and then using the output of pivot tables to drive summaries and other outcomes within the same Excel workbook. Your project sounds Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(0 Commentaires)
0.0
Joukeh

I am your perfect candidate (that is what we all say). I have been an Excel power-user for the past 30 years. So, making complex formulas and present the outcome in an attractive dashboard using all tools including V Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0