Menu Search Sign up

Excel

Creat a macro

https://meetings.webex.com/collabs/#/meetings/detail?uuid=M9U22JG0G5SWV9SPLLPBTU8M9E-4O2&rnd=795644.15612

Click View -> Macros

Type a new name in "Macro Name:" text box

Click "Create"

The Microsoft Visual Basic for Applications window will open with skeleton code for you to fill

Sub test()
  
End Sub

Add Developer Tab to Excel

File -> Options -> Customize Ribbon -> Main Tabs -> Developer

Assign a macro to a Form Control button

Navigate to the cell in your worksheet where you want to place the button

Developer -> Insert -> Button (Form Control)

Specify/select the macro name, then click OK.

Calculation referencing worksheet with space in name

=INDEX('[Cross Reference OID Master.xls]Front End OIDs'!$A$2:'[Cross Reference OID Master.xls]Front End OIDs'!$A$500,MATCH(C2,'[Cross Reference OID Master.xls]Front End OIDs'!$B$2:'[Cross Reference OID Master.xls]Front End OIDs'!$B$500,0),1)

Calculation referencing another Excel file

=INDEX('[Cross Reference OID Master.xls]Front End OIDs'!$A$2:'[Cross Reference OID Master.xls]Front End OIDs'!$A$500,MATCH(C2,'[Cross Reference OID Master.xls]Front End OIDs'!$B$2:'[Cross Reference OID Master.xls]Front End OIDs'!$B$500,0),1)

Calculation with fixed reference to cell col and row

=INDEX('[Cross Reference OID Master.xls]Front End OIDs'!$A$2:'[Cross Reference OID Master.xls]Front End OIDs'!$A$500,MATCH(C2,'[Cross Reference OID Master.xls]Front End OIDs'!$B$2:'[Cross Reference OID Master.xls]Front End OIDs'!$B$500,0),1)