Create an Excel Summary sheet

$30-250 AUD

Завершено

Опублікований

about 10 years ago

$30-250 AUD

Оплачується при отриманні

I have a single Excel file that allows me to have a number of sheets - one per Project - that list tasks (vertically). I use this to track the progress of each Project. I would like to have a sheet at the front that shows the progress of each Project by listing each sheet vertically and automatically showing the information from each sheet. I would like it to allow me to add a new Project (sheet) and for it to be easy to add it to the Summary sheet. A simple outline of how I would like it to work is attached. I could just do it manually but I expect it is more user-friendly if it is a Pivot Table or something better...

Excel

ID проекту: 5798353

Про проект

16 пропозицій(-ї)

Дистанційний проект

Активність 10 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни

Отримайте гроші за свою роботу

Опишіть свою пропозицію

Реєстрація та подання заявок у проекти є безкоштовними

Доручений:

@Teloquence

Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

$50 AUD за 0 день

4,9

(330 відгуки(-ів))

7,7

16 фрілансерів(-и) готові виконати цю роботу у середньому за $79 AUD

@zExcel

Hi, I'll be happy to help you with this project Please feel free to message me if you need to discuss any questions you might have prior to award

$133 AUD за 1 день

4,9

(251 відгуки(-ів))

7,7

@deepbluetech

Hi, Had a look at the sample Excel file. Shall make the Excel file as user friendly as possible. Whenever you a dd a new project, a fresh worksheet will be added with the same tasks or fresh ones. Let me know. Regards, Arul

$100 AUD за 2 дні(-в)

5,0

(173 відгуки(-ів))

7,4

@maverick44000

Hi Mate. I have designed a few very similar sheets in Excel before and I can make one for you. It shall have a very user friendly interface with Input Forms to manage your projects. I have significant experience in doing such tasks. Kindly discuss. Regards. Usman.

$160 AUD за 3 дні(-в)

5,0

(73 відгуки(-ів))

6,9

@hdlong66

Dear dgiffen. I've done this task and can show you the result. You can use it very simple 1) Index worksheet will be updated automatically when new worksheet added 2) In Index worksheet you need define list of tasks (from cell B1) 3) When you add new worksheet for each new project, you need choose related task from the list of tasks 4) Copy formula in the new line of new project or new column of new task in Idex worksheet It works with Excel 2007. Wait for your response. Thank you.

$30 AUD за 0 день

5,0

(165 відгуки(-ів))

7,1

@javed1705

I am an ACCA , APA and Mcom finance having full command over advance excel Your project has caught my attention as i know that this is my favorite topic and i am highly interested with due concern... I am fully competent in doing said assignment/job, I have more than 7 years of exp hire me at fordable cost with best results, readily available for said task........ regards javed

$64 AUD за 3 дні(-в)

4,9

(106 відгуки(-ів))

6,7

@avinav606lx

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Lets discuss more online on chat. Thanks, Abhinav

$126 AUD за 1 день

4,9

(162 відгуки(-ів))

6,5

@dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.

$100 AUD за 3 дні(-в)

4,9

(117 відгуки(-ів))

6,3

@rengrish

I have excellent experience in Excel & VBA. Please ping me so that we can discuss the complete requirement and i can give you a demo work. If you are 100% happy with my demo work then you can award me this full project .. Please check my past reviews and ratings. I assure you 100% accurate & quality job. I am sincere,honest and hardworking independent freelancer . I give more importance to the job than $. Please let me know your email id for ease of communication . Thank You. Regards, Rishi

$66 AUD за 2 дні(-в)

4,9

(158 відгуки(-ів))

6,0

@ethicalboy

Hello, I can do this project for you maybe in couple of hours but wrote 2 days for more stability, also let me know if you use mac or windows because some macros cannot be executed well in mac! more about me: I am m.s of systems engineering and b.s of industrial engineering, and excel and vba expert. I have done similar projects and I am confident about my profession, I also accept revisions and removing errors and minor changes in future for free, whenever you are ready lets go. I have good command of English that I think can be useful for this project.

$39 AUD за 2 дні(-в)

4,9

(60 відгуки(-ів))

5,3

@k00lcaptchrz

Hello, I have done similiar project recently , if you need sample i can provide you , I am ready to start right now waiting for your positive response , Thanks Kcc

$55 AUD за 1 день

5,0

(46 відгуки(-ів))

5,2

@teeares

I have done many projects in Excel and this task appears quite simple. I can do do this project for you quickly. if you had enclosed the actual file a correct estimate of the time required could have been made. Terence

$77 AUD за 3 дні(-в)

4,5

(50 відгуки(-ів))

5,0

@vikashgadia

excel vba expert ready to start ur project now............................................................................................................................................................................................

$55 AUD за 1 день

4,9

(15 відгуки(-ів))

3,8

@GuruExcel

I have completed the project using formulas. The Summary sheet will be automatically updated with the insertion of each new sheet. I am proficient in Excel and have done numerous projects. I will provide you the formula or update your sheet with formula immediately. Message me in case you need any clarification.

$45 AUD за 1 день

4,7

(7 відгуки(-ів))

3,1

@TecConnected

Hi My Name is Yony from Sydney, I have experience working in Excel for 3 Year, I will be available for work in this project and you will be happy with the result, plus you can contact to me for Support or teach you Microsoft Excel. Regards. Yony M

$111 AUD за 2 дні(-в)