Pulling data from sheet

sansri79

New Member
Joined
Jul 12, 2010
Messages
3
Hi,
I have ceated a form with the fields customer name, mobile number, quali,etc. and with the buttons "New Record", "Save" & "Exit".

Once i click the "New Record" button in the form the first two fields i.e., "Customer Name" & "Mobile Number" should automatically filled from the sheet. The sheet contains the customer name and mobile number.

Could anyone please help me on abobe. please let me know if my query is not clear.

Thanks
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,939
Messages
5,508,249
Members
408,670
Latest member
lhmwnrexcel

This Week's Hot Topics

Top