Hi, I have recorded a macros
Sub WarehouseRecieved()
‘
‘WarehouseRecieved Macro
‘Booked in at the warehouse
‘
‘ Keyboard Shortcut: Crtl+w
‘
Range(“Q21”).Select
ActiveCell.FormulaR1C1 = “Yes”
End Sub
BUT!! I want to select a different cell (column b) run the shortcut and yes to appear...