curious_dan
New Member
- Joined
- Mar 14, 2016
- Messages
- 9
Hi,
I have raw data in a sheet named 'Data'. I have in a different sheet named 'Finance', a search box in cell AF32. Once I type in my search box an item code, XLOOKUP then finds that in column F withinin my 'Data' sheet and information is then shown relating to that row of data. I now want to add a button that when clicked, changes the item code in the AF32 search box to the next record in the 'Data' sheet.
For example, I type dmyc01 in my search box. Data is then shown in other cells below relating to dmyc01. Instead of typing dmyc02, I want a button next to the search box to change the search in AF32 to the next available record in the row below dymc01. This will NOT always be in numerical order. 'dymc03' may not exist so it should just display the next row's item code in the 'Data' sheet, which might then be dmyc17.
How do I do this in Excel?
Thanks!!
I have raw data in a sheet named 'Data'. I have in a different sheet named 'Finance', a search box in cell AF32. Once I type in my search box an item code, XLOOKUP then finds that in column F withinin my 'Data' sheet and information is then shown relating to that row of data. I now want to add a button that when clicked, changes the item code in the AF32 search box to the next record in the 'Data' sheet.
For example, I type dmyc01 in my search box. Data is then shown in other cells below relating to dmyc01. Instead of typing dmyc02, I want a button next to the search box to change the search in AF32 to the next available record in the row below dymc01. This will NOT always be in numerical order. 'dymc03' may not exist so it should just display the next row's item code in the 'Data' sheet, which might then be dmyc17.
How do I do this in Excel?
Thanks!!