Using InputBox to locate a row and cell number, then to insert a value with the location

[Surfboard]

Hello there

I am currently struggling with a script i am trying to create. I have account numbers that get paid each month, and i have created an input box where one can type in the account number, it will locate it and give you the row number, then another will ask you for the month, and give you the column number. Now that part is working perfectly, but i would like to add the next step where it uses the Row Number from the account number and the Column number from the Month, with the use of an input box, it would place the amount typed, within the range it generated. For example: Account number 7894561230 is located in row 67, and July is located in Column 3. Then the next input box should place the Amount in Column 3, Row 67.

Please Login or Register  to view this content.

[ragulduy]

Not quite sure on how to fit in your code but I would do something like:

Please Login or Register  to view this content.

(Assuming your month/column headers are in rows 1

[Surfboard]

Eskom Payments Template2.xlsx Let me see if i can manipulate the code into my script, but my sheet looks like this:

[ragulduy]

Had a look and was a bit more difficult getting it to work with your layouts/formats but I think this should do it:

Please Login or Register  to view this content.

[Surfboard]

Working perfectly, and much shorter then my script.. I dont know why i always intend to create such massive scripts when most of them can be shortened like above . Thank you for your time and help, much appreciated.