Hi,
Please see attached Worksheet - I would like a way of showing outstanding inspections on units that have been issued, every month I would be updating the two TABS giving me monthly outstanding inspections to do (this is a sample of Regions & Units - In total there are 80+ Regions and 10,000 units)
Hope you can assist,
Cheers
What exactly does "dropped here" mean? Do you mean these data are manually entered? Is it the four column sheet you wish to produce? If so, you can probably use PowerQuery for this, as you have Office 365.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi,
This would copied out of a DataBase (Microsft Access) and pasted into the sheets,
Cheers
So why aren't you calculating the non-returned items via the database? You should be able to run a report.
Hi,
My knowledge and experience in both Excel and Access is very limited more than happy to try and do it in Access always up for a challenge, do you think an Access route would be easier?
Cheers
Well, if it's Access, then you can create a bespoke report based on filtered tables. It's many years since I dabbled in Access, but I'd be inclined to keep it all under one roof, so to speak.
This might get you started: https://support.office.com/en-ie/art...1-e0f2fe424eeb
OP started a new thread after trying suggested solutions https://www.excelforum.com/excel-gen...ml#post5120820
This thread closed to avoid hijacking
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks