Seamus2626
asked on
Enter Formula on button click
On the attached spreadsheet I have 7 buttons where on clicking, I would like the below to happen on clicking
If PDF Country (Managed) is clicked then U23 = G2
If PDF Country (Booked) then U23 = G3
If PDF Global SM (Managed) then U23 = H2
If PDF Regional SM then U23 = I2
If PDF in-country! (booked) then U23 = J2
If PDF Sector (booked) then U23 = K3
If PDF Sector (Managed) then U23 = K2
Many thanks
Seamus
Copy-of-EE.xlsm
If PDF Country (Managed) is clicked then U23 = G2
If PDF Country (Booked) then U23 = G3
If PDF Global SM (Managed) then U23 = H2
If PDF Regional SM then U23 = I2
If PDF in-country! (booked) then U23 = J2
If PDF Sector (booked) then U23 = K3
If PDF Sector (Managed) then U23 = K2
Many thanks
Seamus
Copy-of-EE.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER