- Would somone be kind enought to help me with a VBA code. What I need is the following:
- In Worksheet "Sheet1" I would enter in a number in a cell range of B15:B80. ( All cells in this range would be blank until I ented in number).
- For refrence I enter in "5" in cell B15
- Upon entering "5" lookup based on look up key in adjacet cell column A15:A80.
- In example lookup key is A15.
- Lookup would run in "Sheet2".
- Down Column A in the Excel Table named "Tabel1" range A4:R211.
- Table range is dynamic (may increase or decrease in size) currently it is A4:A211.)
- Lookup would input value "5" in Column R (18 columns over)
- In example would input "5" into R135
- Once completed the orginal input value "5" on "Sheet1" would be cleared.
My goal is anytime I enter in a value in "Sheet1" VBA would input value based on lookup in "Sheet 2"
Thank you in advance, Kindly D