Hi, I have a spreadsheet that has hundreds of rows that include a unit number, a name, and several charges generated by the sheet.
I'm trying to set-up a vba program that prompts user for a unit number, then finds that cell that matches the input(ed) unit number and then pulls the name and charges from the corresponding row.
I've got the input box and the message box done, but am having trouble looping through the cells in the unit column (I'm still very new at VBA).
Thanks alot for any help!
I'm trying to set-up a vba program that prompts user for a unit number, then finds that cell that matches the input(ed) unit number and then pulls the name and charges from the corresponding row.
I've got the input box and the message box done, but am having trouble looping through the cells in the unit column (I'm still very new at VBA).
Thanks alot for any help!