thespardian
Board Regular
- Joined
- Aug 31, 2012
- Messages
- 119
- Office Version
- 2016
- 2013
- Platform
- Windows
Hi there!
@Fluff please.
Sheet 2 may be called Database. I entered the data over here and the Sheet3 may be called result sheet where I have entered the following formulas in column A and column B respectively.
Formula is Column A (on Sheet3)
=IF('SH3'!$C3="","",INDEX('SH2'!$C$3:$C$10000,MATCH('SH3'!$C3,'SH2'!$A$3:$A$10000,0)))
Formula in Column B (on Sheet3)
=IF('SH3'!$C3="","",INDEX('SH2'!$D$3:$D$10000,MATCH('SH3'!$C3,'SH2'!$A$3:$A$10000,0)))
There is a lot of data in Sheet2, The above formula is making it slow. Therefore I want to replace these formulas with a vb code that works with selection change event. Any help will be highly appreciated.
@Fluff please.
Sheet 2 may be called Database. I entered the data over here and the Sheet3 may be called result sheet where I have entered the following formulas in column A and column B respectively.
Formula is Column A (on Sheet3)
=IF('SH3'!$C3="","",INDEX('SH2'!$C$3:$C$10000,MATCH('SH3'!$C3,'SH2'!$A$3:$A$10000,0)))
Formula in Column B (on Sheet3)
=IF('SH3'!$C3="","",INDEX('SH2'!$D$3:$D$10000,MATCH('SH3'!$C3,'SH2'!$A$3:$A$10000,0)))
There is a lot of data in Sheet2, The above formula is making it slow. Therefore I want to replace these formulas with a vb code that works with selection change event. Any help will be highly appreciated.