Forum Discussion
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...
Hi fmdon ,
thank you for further details my suggestion is shown in the attached sample file.
yes OliverScheurich it is pretty similar containing those main informations in all the 3tabs, and in this 4th tab where I want to bring the most recently position, I have all the 300 boxes listed!!
Do you see any way of lookup into those 3 different tabs and updating/ bringing to this 4th one (that is my boxes list) always tying up the lookup and the bringing the results always considering the last movement and date ?
Thanks for your time and attention!
Do you see any way of lookup into those 3 different tabs and updating/ bringing to this 4th one (that is my boxes list) always tying up the lookup and the bringing the results always considering the last movement and date ?
Thanks for your time and attention!
Attached is my sample file which returns the location of the boxes along with their most recent dates of arrival and departure. However i wonder what the content of the 3rd table is. I understand that there is a 1st table for the dates of arrival and a 2nd table for the dates of departure. Perhaps you can give an example of the data of the 3rd table.
- 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…Hi fmdon ,
thank you for further details my suggestion is shown in the attached sample file.
- 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 !! 👍💪