Search:

Type: Posts; User: shina67; Keyword(s):

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Re: Turn a workbook with macros/vba coding into a mobile app

    Hi,
    Thanks for your reply.
    I was wondering if there was an easy way of doing it. With some sort of conversation software or a company that anyone could recommend to do it.
  2. Re: change row colour when cell is selected for ease

    Here are the steps to highlight the active row.

    Select the data you want to highlight.

    Go to the Home tab.
    Click on Conditional Formatting and then click on New Rule.
    In the New Formatting...
  3. Turn a workbook with macros/vba coding into a mobile app

    Hi All,

    Could anyone please point me in the right direction as to how to change a workbook I have into a mobile app.
    The workbook has 14 worksheets within it and loads of vba. I have it on...
  4. Re: Return a date based on it being Monday, Thursday or Friday

    Thanks for your replies. Both answers worked thank you very much
  5. Return a date based on it being Monday, Thursday or Friday

    Hi,

    I have a spreadsheet that gets dates manually inputted into it.
    What I need is a formula to return a date 7 days on from the manual input but has to be a Monday, Thursday or Friday.
    I.E....
  6. Replies
    0
    Views
    600

    Link Excel to Powerpoint

    Hi All,

    I have a Powerpoint presentation that pulls data from a worksheet from excel into it.
    I have tried the embedded option with update link ticked.
    I have managed to get the embedded object...
  7. How can i make a workbook print to multiple printers

    Hi All,

    I have a workbook that will automatically print a worksheet within it when certain conditions are met.
    The problem I have is that this is a multi-user workbook who work from different...
  8. Re: Struggling to get multiple arguments to work in a formula

    Hi James,

    The formula has been removed now as I have some vba coding inserted now.
    The problem I have now is with a drag down of formula’s.
    Row 3 works fine for what I need it to do. However...
  9. Re: Struggling to get multiple arguments to work in a formula

    Thanks all for your help so far.
    I now have a new problem.

    I’m hoping you can help with a drag down of formula’s.
    Row 3 works fine for what I need it to do. However when I drag the formula’s...
  10. Re: Struggling to get multiple arguments to work in a formula

    Hi James,

    I am using the following formula which seems to work fine :-
    =IF(AND($F3=SUBSTITUTE(N$1," ",""),$D3&$E3&$F3=$A$1),$A3,"")
    The problem I now have is that when $A$1 is blank it does not...
  11. Re: Struggling to get multiple arguments to work in a formula

    Jason,
    Again apologises for this. My misunderstanding of a cross post obviously.
    I have included the link to excel forum post in my original post as suggested by yourself.
  12. Re: Struggling to get multiple arguments to work in a formula

    Jason,

    My apologises. I did think that with it being a different formula and therefore a different problem that it would not be a cross post.
    The cross post you refer to is...
  13. Re: Struggling to get multiple arguments to work in a formula

    Thanks James for your reply.

    Your solution returns a zero for all. What I am wanting is for it to also return the value from $A3 if $F3=N$1
  14. Struggling to get multiple arguments to work in a formula

    Hi All,

    I have attached a link to the spreadsheet I am referring to:- https://www.dropbox.com/s/i5lvozes381hj18/Test%20Scan%20Mr.Excel.xlsm?dl=0

    If the part from A1 "XPGLIDE" matches F3 then I...
  15. Replies
    2
    Views
    354

    Re: Send an email based on a cells value

    Bump
  16. Replies
    2
    Views
    354

    Send an email based on a cells value

    Hi All,

    I have a worksheet that when a cell in column F is changed I want to email out a message to a particular person.
    I.E. if the cell in F is changed to Production I want to email Chris Smith...
  17. Re: Automatically run a macro when a cell is changed in a worksheet

    Thanks Alan for your reply.

    If I use the following code would it work?




    Private Sub Worksheet_Change(ByVal Target As Range)
  18. Automatically run a macro when a cell is changed in a worksheet

    Hi All,

    I hope someone can help.
    I have a workbook with 12 worksheets in it.
    I have a worksheet called 'Master LOG-Owner Geoff Clarkson'.
    When a cell in column F is changed on this worksheet I...
  19. Re: Copy and paste from one sheet to another based on a cells value

    Hi Yongle,

    Thanks for your help on this.
    In answer to your questions:-
    - Is Area in column A ? Yes
    - Is 04 Unpaid Holiday in column O ? Yes
    Are sheet names totally consistent in style?...
  20. Re: Copy and paste from one sheet to another based on a cells value

    Hi,

    There are approx 120 rows in each sheet and there is approx 170 sheets
  21. Copy and paste from one sheet to another based on a cells value

    Hi All,

    I have a spreadsheet that populates the employees time and attendance.
    I am trying to create a new tab that will only pull the data for lateness's from the main tab.

    <tbody>
    Area...
  22. Replies
    1
    Views
    114

    Conditional Formatting

    Hi, I have cell's A though to L. I am wanting the cells filled red unless all the cells have either a value or text in them. All the cells would then change to green. If 1 cell is blank then all...
  23. Re: How to automatically refresh an excel sheet

    Thanks for that. Will this only work if the workbook is open?
    If so how do I make it work when the workbook is closed?
  24. Re: How to automatically refresh an excel sheet

    Thanks offthelip

    My code is as follows:-

    Sub Macro1()
    '
    ' Macro1 Macro
    '
    ' Keyboard Shortcut: Ctrl+q
    '
  25. How to automatically refresh an excel sheet

    Hi All,

    I have an excel sheet that pulls information from an external source. The external source updates regular.
    My query is :- How do I get my excel sheet to update automatically without...
Results 1 to 25 of 63
Page 1 of 3 1 2 3