Search results

not sure I made it clear what I want to do. If there is a name is any cell in column A the adjacent cell in column B can not be left blank, if user moves away from cell message box "please enter department". When user enters name in cell A8 target cell becomes B8, if user moves away from...

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...

Thank you.

OK. Thanks

would the URI not contain the drive letter. How will this change if the drive letter changes from computer to computer. Or am I being completely stupid. Example ActiveWorkbook.SaveAs "f:\Weekly Sales\Daily Sales\" & "Daily Sales Week" & "_" & WKno & ".xls"

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

I need to email this file in excel 2003 format. but when using the code below I get a Method error. If i remove the Application.Default line the file save but when opening I get a file corruption error "file not save in extension format" Application.AlertBeforeOverwriting = False...

Thanks. Work great.

: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...