Search results

I am trying to create a staff payroll spreadsheet, all is going well except one issue. I need to do the following: If name entered in range A8:A60 move to cell in range B8:B60. If user moves away from cell in range B8:B60 and name (text) exist in range A8:A60 message box please enter...

I have created a set of excel files that I wish to keep in a external USB drive, that with be used on multiple computers. How do I code directory details so the lookups and save directory are always on external drive Thanks

:confused: I am new to all this and am trying to create a macro that will copy tab to new sheet rename and email. No having much luck. So far I have got this Sub email() ' ' email Macro ' Copy and Email Daily Sales Sheet ' ' Keyboard Shortcut: Ctrl+e ' 'Copy to new sheet...