Update a number from a previous date

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3158753%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EUpdate%20a%20number%20from%20a%20previous%20date%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3158753%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EI%20work%20for%20a%20company%20that%20assists%20Veterans%20and%20their%20Family%20members%20to%20get%20jobs%20and%20I%20am%2099%25%20done%20with%20a%20database%20I%20have%20created%20in%20Excel%20to%20track%20numbers%20so%20we%20can%20continue%20to%20get%20funding.%20A%20report%20also%20gets%20generated%20for%20the%20Consultant%20to%20see%20how%20they%20are%20doing%20with%20job%20posts%20and%20hirings%20period%20over%20period.%20Each%20rating%20period%20is%20(mid-month%20and%20end%20of%20month)%2C%20which%20the%20numbers%20normally%20fluctuate%20between%20these%20two%20periods.%26nbsp%3BA%20Consultant%20can%20have%20322%20active%20jobs%20posted%20for%20mid-month%20and%20300%20at%20the%20end%20of%20the%20month.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20get%20the%20accurate%20number%20to%20automatically%20populate%20the%20field%20when%20the%20new%20number%20is%20entered%20and%20carry%20over%20to%20the%20next%20reporting%20period.%20I%20have%20a%20consultant%20that%20started%20off%20January%20with%20762%20jobs%20posted%20then%20at%20the%20end%20of%20the%20month%20he%20gained%2018%20new%20job%20posts%20which%20brought%20him%20up%20to%20780.%20What%20I%20have%20right%20now%20is%20adding%20those%20two%20numbers%20together%20and%20showing%201542%20jobs%20posted%20and%20the%20number%20keeps%20increasing.%20Others%20decrease%20their%20numbers%20over%20a%20period%2C%20but%20it%20still%20adds%20everything%20together%20and%20gives%20me%20a%20high%20number.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20have%20excel%20identify%20each%20consultant%20name%20and%20period%20and%20update%20these%20stats%20period%20over%20period%20when%20the%20new%20entry%20is%20made%3F%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20promise%20not%20to%20bother%20you%20again%2C%20I%20just%20need%20help%20getting%20this%20figured%20out.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EThank%20you%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3158753%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EMacros%20and%20VBA%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Contributor

I work for a company that assists Veterans and their Family members to get jobs and I am 99% done with a database I have created in Excel to track numbers so we can continue to get funding. A report also gets generated for the Consultant to see how they are doing with job posts and hirings period over period. Each rating period is (mid-month and end of month), which the numbers normally fluctuate between these two periods. A Consultant can have 322 active jobs posted for mid-month and 300 at the end of the month.

 

I am trying to get the accurate number to automatically populate the field when the new number is entered and carry over to the next reporting period. I have a consultant that started off January with 762 jobs posted then at the end of the month he gained 18 new job posts which brought him up to 780. What I have right now is adding those two numbers together and showing 1542 jobs posted and the number keeps increasing. Others decrease their numbers over a period, but it still adds everything together and gives me a high number.

 

Is there a way to have excel identify each consultant name and period and update these stats period over period when the new entry is made? 

 

I promise not to bother you again, I just need help getting this figured out.

 

Thank you

 

 

4 Replies
Hai ,
It would be helpful to understand your problem and solve it ,if you can attach a sample file of Excel.
Could you please attach a sample file if possible,so the mebers can understand simply.
I will try
how can I attach the file for you

@TimothySmith 

 

I have attached the file