Hi Everyone,
My Question today is about using vlookup in vba, or something of the like.
I have 2 worksheets one named "Members" the other named "Fees Paid". Currently i am using vlookup in cells that require it, what i would like to do is use vba to accomplish this task instead.
The "Members Sheet " is where all data is manually entered, The "Fees Paid Sheet" has 8 Columns "A" through to "H" column A uses vlookup, column B uses Data Validation List, Column's C,D & E all use vlookup, Once the user selects a name in column B then the rest of the columns return the matching Data for that name.
is there a way to have vba do this so that i can remove all formulas from column's A,C,D & E....? This must continue down the worksheet over time until the worksheet is full.
Thankyou all in advance...
My Question today is about using vlookup in vba, or something of the like.
I have 2 worksheets one named "Members" the other named "Fees Paid". Currently i am using vlookup in cells that require it, what i would like to do is use vba to accomplish this task instead.
The "Members Sheet " is where all data is manually entered, The "Fees Paid Sheet" has 8 Columns "A" through to "H" column A uses vlookup, column B uses Data Validation List, Column's C,D & E all use vlookup, Once the user selects a name in column B then the rest of the columns return the matching Data for that name.
is there a way to have vba do this so that i can remove all formulas from column's A,C,D & E....? This must continue down the worksheet over time until the worksheet is full.
Thankyou all in advance...