Good day.
I have a data base of orders and order numbers. I created a sheet with a specific order number, lets say AER1, so this will be the sheet now. Now obviously will there be allot of these sheets, let say from AER1 to AER500(500 sheets). And under every sheet there is specific site details. Like the model I order, client name, site name, date of order, date of delivery, yada yada.
How is it possible for me to search for the specific sheet, let say sheet AER431, without having to with those arrows from right to left?
Or even better. But only if it is possible. Maybe you can suggest something else.
Is it possible to insert AER431 in a cell, into lets say a specific cell of a specific sheet for searching and showing details. Like a summary of AER431. Once I have inserted the AER431 in the cell it will give all the details in this summary sheet of AER431. In the summary sheet I can edit the data, like the date of delivery. Then if I update this data in the summary it automatically updates it in that sheet?
Your help will be greatly appreciated
I have a data base of orders and order numbers. I created a sheet with a specific order number, lets say AER1, so this will be the sheet now. Now obviously will there be allot of these sheets, let say from AER1 to AER500(500 sheets). And under every sheet there is specific site details. Like the model I order, client name, site name, date of order, date of delivery, yada yada.
How is it possible for me to search for the specific sheet, let say sheet AER431, without having to with those arrows from right to left?
Or even better. But only if it is possible. Maybe you can suggest something else.
Is it possible to insert AER431 in a cell, into lets say a specific cell of a specific sheet for searching and showing details. Like a summary of AER431. Once I have inserted the AER431 in the cell it will give all the details in this summary sheet of AER431. In the summary sheet I can edit the data, like the date of delivery. Then if I update this data in the summary it automatically updates it in that sheet?
Your help will be greatly appreciated