Dynamic servicing sheet

[NRDP]

Hello Everyone!

My second post here and I hope it makes it interesting for some of you.

I have been working on a spreadsheet that automatically gives me when a service is due for a certain asset, normally 8 weeks.

I have created forms that populate the "Database" and "Servicelogs" Tables, each of these ask for a date when are done.

My problem is now, I need to matchup the "Dashboard" Service Due column in line with the most recent service that was done on it, I figured if I just substact the amounts of weeks elapsed from servicelogs (Serviced) - database (Service due) will give me the most up to date service data. That worked, but now I need to matchup the "customer name" of each sheet to pull the correct data; as this is a new system; I do not have all the data from previous "services" at hand.

I will attach my workbook and do let me know any ideas.

TA!

[AliGW]

Welcome to the forum.

In your profile, please display the EARLIEST version of Excel that you have that any solutions will need to work with. Giving a range really isn't as helpful as you might think. Thanks.

Will have a look now.

[AliGW]

OK. In the sample workbook, please mock up manually on the DASHBOARD sheet some expected results (values, not using a formula). Give us 10-15 rows wirth so that we can see what you are aiming to achieve withe a formula. Non-working formulae, or formulae that give results that you no longer need are not that informative. Thanks.

[NRDP]

Hi AliGW

Thanks for your reply, I will update my earliest version there.

I have included some expected results on the dashboard with a comment on the first line to what I want to achieve, basically I need the counter to reset ("service due" on dashboard) to 0 when a customer had a service on their bike in this instance, and because a customer can have a bike for several months we will do several services and in each instance a service log is updated. Do I make sense here?

[AliGW]

OK - was there ever an Excel 2006? Do you mean 2007? Or is this simply a release number for a much newer version?

I will need to look at the new workbook to comment.

[NRDP]

It was 2016 sorry!

[JeteMc]

Try pasting the following into cell I2 on the Dash sheet and then copying down:

Please Login or Register  to view this content.

Let us know if you have any questions.

[NRDP]

That did work but not the way I intended at first, but It gave me an idea on how to format other things to make it work ! Thank you so much both!

[AliGW]

You're welcome.

If you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

[JeteMc]

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.