Good morning. I am not really macro savvy, so some help would be appreciated.
I have a form in one tab (Form) and data in the second tab (Schools). I need to be able to put the school data into the form based upon the value in a cell;
so value is in cell C22; based upon that value, I need the school name, address and phone numbers from the Schools tab to populate into cells on the forms tab
the form cells are
Program in C23 (data is in schools tab range A1-15)
Address in C24 (data range B1-15)
Address2 in C25 (data range C1-15)
Contact in C26 (data range D1-15)
Phone in I25 (data range E1-15)
I'm slowly learning! I've only done one other macro before and it was really helpful, but easy compared to this. Or am I overthinking it?
I have a form in one tab (Form) and data in the second tab (Schools). I need to be able to put the school data into the form based upon the value in a cell;
so value is in cell C22; based upon that value, I need the school name, address and phone numbers from the Schools tab to populate into cells on the forms tab
the form cells are
Program in C23 (data is in schools tab range A1-15)
Address in C24 (data range B1-15)
Address2 in C25 (data range C1-15)
Contact in C26 (data range D1-15)
Phone in I25 (data range E1-15)
I'm slowly learning! I've only done one other macro before and it was really helpful, but easy compared to this. Or am I overthinking it?