Hello everyone
I have basic experience with Excel and I have reviewed previous forum posts but can't understand how to adapt vba to my scenario, so seek your assistance please.
Situation
I have a sheet that will be containing a very large amount of data so to assist in reducing file size I am looking for the VBA alternative to having a VLOOKUP prefilling several columns.
This is a working sheet for example to assist my explanation:
http://s000.tinyupload.com/?file_id=39025698863238148574
I have two sheets named Records and Staff.
Staff: Staff ID (Column B2:~), Name (Column C2:~) and Group (Column D2:~).
Records: Where records are added regarding all staff members. When entering the details, the Staff ID number is typed in and the details for name are looked up and represented in the Name column (C7:~) and Group column (D7:~).
I was using vlookup with the following formulas but as stated, when I extend these formulas down the sheet the file size becomes huge and not suitable for my use.
Thanks in advance
I have basic experience with Excel and I have reviewed previous forum posts but can't understand how to adapt vba to my scenario, so seek your assistance please.
Situation
I have a sheet that will be containing a very large amount of data so to assist in reducing file size I am looking for the VBA alternative to having a VLOOKUP prefilling several columns.
This is a working sheet for example to assist my explanation:
http://s000.tinyupload.com/?file_id=39025698863238148574
I have two sheets named Records and Staff.
Staff: Staff ID (Column B2:~), Name (Column C2:~) and Group (Column D2:~).
Records: Where records are added regarding all staff members. When entering the details, the Staff ID number is typed in and the details for name are looked up and represented in the Name column (C7:~) and Group column (D7:~).
I was using vlookup with the following formulas but as stated, when I extend these formulas down the sheet the file size becomes huge and not suitable for my use.
Code:
=IFERROR(VLOOKUP(B7,Staff!B2:D27,2,FALSE),"")
&
=IFERROR(VLOOKUP(B7,Staff!B2:D27,3,FALSE),"")
Thanks in advance