Forum Discussion

fmdon's avatar
fmdon
Copper Contributor
May 18, 2024
Solved

EXCEL QUESTION

I have a spreadsheet with 3 tabs, in each tab I have numbered boxes. They are now separated per tabs because they are in different stages/status of a specific process, for example most recently date...
Formulas and Functions
fmdon's avatar
fmdon
Copper Contributor
May 19, 2024
hello Oliver, sorry, I was not clear with my example… actually in all the 3tabs we have the most recent date of arrival, most recent date of departure and location., the difference is that 1st tab is for imp, the 2nd for exp and the 3rd for empties boxes. The goal is to bring in a 4th tab the informations for each box that are spread along all the 3tabs.
This 4th tab will have as the main goal, to show the last position of the box…
  • fmdon's avatar
    fmdon
    Copper Contributor
    May 23, 2024
    Guten Morgen OliverScheurich !
    Your formula was brilliant, thank you very much for your rich contribution!!
    Like a genius, you matched exactly what I need!! I took longer to reply you because I was adapting the formula to my file, you rock, Vielen Dank !! 👍💪
    • fmdon's avatar
      fmdon
      Copper Contributor
      May 26, 2024

      OliverScheurichI hope you are doing good!! I was wondering if is that possible to click in the box retrieved in the 4th tab and be redirected to the original lane in the tab 1, 2 or 3 (from where the last date and location was retrieved) ?
      This would be a good tool to see the full lane information / historic for the specific box!
      Can you give me a heads up in this sense as well, please ?
      Thank You !

      • OliverScheurich's avatar
        OliverScheurich
        Gold Contributor
        May 28, 2024

        fmdon 

        Hello, I hope you're doing well, too. I'm afraid I can't help you with that. You've stumped me there. If this is possible at all, you might need VBA. Perhaps another contributor can provide a suggestion.