excel sheet work

完了済み 投稿 6年前 着払い
完了済み 着払い

I currently have an excel sheet that I keep of all of the jobs that I am running. I use this as a way to keep track of the labor days that is required for each job and the month that I expect the work to take place.

I am looking to have a second sheet that takes the data from the first sheet ( The Labor Report) and give me the following information.

Total number of labor days per PM (Column C)

Total Labor per month per PM

This sheet should an additional tab on the original workbook, however, can we make the new sheet password protected?

On the Labor Report sheet, Row 2 is where it shows the date (month and year). Every month, I have to change the dates. For example, right now my dates run from Sept 2017 to August 2018. Obviously, have not updated the dates since September. But I have to delete the month just ended and add a the additional month on at the end. Then go and check to make sure all the math and forums are correct for the newly added month. Is there a better way to do this?

Thank you!

エクセル

プロジェクトID: #16014429

プロジェクトについて

12個の提案 リモートプロジェクト アクティブ 6年前

アワード:

Milenkovic007

A proposal has not yet been provided

$99 USD 3日以内
(5レビュー)
2.8

12人のフリーランサーが、平均$130 で、この仕事に入札しています。

asin1987

Dear Employer, I will do this job for you. Please check my revews and give me a chance. Thanks and Regards, ash

$250 USD 3日以内
(43件のレビュー)
5.9
bktk

Hi sir I am expert of excel sheet creating data entry and updating on urgent basis. Sir I have completed several project successfully with that skill . Sir I am offering free demo sir after fully satisfaction you hire もっと

$30 USD 3日以内
(27件のレビュー)
3.5
bappykhanraj

I want this project... how can I help you?? can give me every information... let I work Relevant Skills and Experience can you give me this work

$155 USD 3日以内
(0件のレビュー)
0.0
pagal12345

I used to do to lot of data maintaining like making sheets of daily productivity of Team members,preparing the SLA and TAT reports and responsible to make weekly report for the higher management.I also have a team of g もっと

$250 USD 5日以内
(0件のレビュー)
0.0
comacoding

Deal with Excel all the time. Will find the best way to ease your work. ---------------------------------------------------------------------------------------

$222 USD 2日以内
(0件のレビュー)
0.0
exportlancer

Hello, My name is fasil a certified  lead generation expert,got 6+ years of experience in lead generation. I have designed a tool that makes use of API technologies and i use that to generate leads. I am fully expert もっと

$30 USD 3日以内
(0件のレビュー)
0.0