wilkisa
Well-known Member
- Joined
- Apr 7, 2002
- Messages
- 660
- Office Version
- 365
- 2016
- 2013
- Platform
- Windows
I need help with this one. My user has a very large workbook (22 columns, thousands of rows). In cell I7, he wants to have it change to whatever the value is in column B that corresponds to his position in the workbook. For example, he clicks in cell F220, the value in B220 is 1559 and that should appear in cell I7. He then clicks in cell P87 and the value in B87 is 1190. I7 should then become 1190. What formula or VBA statement should I make to have this happen. I'm in over my head on this one.