The link goes to a macro enabled excel. I understand the perhaps thinking about this. You can choose if you want to review it for a wider view of my goals.
I have 3 worksheets, each uniquely named. I have largely non-editable data on the first page. We use this sheet for inventory at our work. For examples, I added 3 SAP or 'article numbers'. On the other two tabs, I enter in the counts when I use or receive them (amongst other data such as the store number and the vendor name, date, etc)
I need to be able to track the last time that information is entered. I want a 'last time received' and last time billed' value. For the most part, that should be a chronological order, left to right on the other pages. I wrote a quick test formula using a 'LOOKUP' formula, it errored. I'm ok at excel, nowhere near good enough. But hopefully someone can look it over.
ALL PASSWORDS are INV. INV as in inventory Capitals. I also locked the macros with the same, because one of the macros UNPROTECTS, runs an UPDATE LINKS, then reprotects and I don't need someone easily getting the password. I'm attempting to protect my sheets, as reasonably well as possible. It's not perfect, but keeps formatting true.
Thank you for everything MrExcel members, most of this is copy and paste. ?
myQNAPcloud share link (in case someone is worried about directly downloading the link. I fully understand clicking links and the worries.
I have 3 worksheets, each uniquely named. I have largely non-editable data on the first page. We use this sheet for inventory at our work. For examples, I added 3 SAP or 'article numbers'. On the other two tabs, I enter in the counts when I use or receive them (amongst other data such as the store number and the vendor name, date, etc)
I need to be able to track the last time that information is entered. I want a 'last time received' and last time billed' value. For the most part, that should be a chronological order, left to right on the other pages. I wrote a quick test formula using a 'LOOKUP' formula, it errored. I'm ok at excel, nowhere near good enough. But hopefully someone can look it over.
ALL PASSWORDS are INV. INV as in inventory Capitals. I also locked the macros with the same, because one of the macros UNPROTECTS, runs an UPDATE LINKS, then reprotects and I don't need someone easily getting the password. I'm attempting to protect my sheets, as reasonably well as possible. It's not perfect, but keeps formatting true.
Thank you for everything MrExcel members, most of this is copy and paste. ?
myQNAPcloud share link (in case someone is worried about directly downloading the link. I fully understand clicking links and the worries.
