Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Replies
    3
    Views
    69

    Re: Can anyone help on amending a formula

    It’s an old formula that I’m trying to amend.

    In sheet called tableau there is data and there should be the same data in the sheet called Watford. What I’m trying to do is in the sheet called...
  2. Replies
    3
    Views
    69

    Can anyone help on amending a formula

    Hi

    I have this formula and I need to amend it a bit if poss but dont know where to start.

    =IF(E66=IFNA(VLOOKUP(A66,'TABLEAU '!A:E,5,FALSE),0),"OK",IF(E66=IFNA(VLOOKUP(A66,'Shere Previous...
  3. Replies
    3
    Views
    73

    Re: How do I automate find and replace.

    Spot on many thanks.
  4. Replies
    3
    Views
    73

    How do I automate find and replace.

    Hi

    I have a workbook that in column A on sheet 1 each row has different 3 letters.

    On sheet 2 of the same workbook I have in column A the same 3 letters and in column B the meaning of the 3...
  5. Re: How do I insert a line but when trying to insert comes up with error

    Give that a try and yes returns right result. The column that will always have data in every row will be column "W"

    Looking at whats in the columns ive noticed that there is " - " all the way...
  6. Re: How do I insert a line but when trying to insert comes up with error

    It must be some sort of formula because when I highlighted cells and clicked on Clear Contents it worked OK
  7. Re: How do I insert a line but when trying to insert comes up with error

    AAHHHHH right Ive given that a try and that seems to be issue.

    What I need to know then if poss is the following.

    Am I able to highlight and clear contents from blank cells in the rest of the...
  8. How do I insert a line but when trying to insert comes up with error

    Hi

    Im trying to insert a blank row below a row that has the word "Ticket Control No." in column S.

    When I tried doing this manually I get the error message

    "microsoft excel cant insert new...
  9. Replies
    2
    Views
    62

    Re: How do I copy and paste avoiding top line

    brilliant many thanks
  10. Replies
    2
    Views
    62

    How do I copy and paste avoiding top line

    Hi

    I have a workbook that has approx 12,000 entries but im trying to copy and paste into a new workbook but avoid line 1.

    At present im having to highlight all the data from line 2 onward...
  11. Replies
    3
    Views
    92

    Re: My macro not working

    Brilliant many thanks
  12. Replies
    3
    Views
    92

    My macro not working

    Hi

    I have the following macro and wondered what ive done wrong as its not moving data when there is data with word "fare" in column E.

    Sub MoveData()
    Dim ws As Worksheet
    Dim lr As Long, i As...
  13. Replies
    3
    Views
    112

    Re: Help required in amending a macro if poss

    deleted from that website and will concentrate on here.
  14. Replies
    3
    Views
    112

    Re: Help required in amending a macro if poss

    a
  15. Replies
    3
    Views
    112

    Help required in amending a macro if poss

    Hi

    I have this macro that filters out data by using criterial

    The macro at the moment goes into sheets 1 & 2 and filters out. What im trying to do is to compare the data between the 2...
  16. Replies
    1
    Views
    117

    Manual Calculations questions

    HI

    Can you set excel up so that I can do manual calculations on one workbook only?

    I know how to do it on formulas tab but it sets all my excel workbooks for manual calculation and need one...
  17. Macros not running properly. Can anyone assist?

    Hi

    I have a workbook and run this macro first OK

    Sub Split_Extract()

    ActiveSheet.Name = "Extract"
    Range("A1").Select

    Cells.Find(What:="WFJ", After:=ActiveCell,...
  18. Re: Need help on how to highlight duplicated entries and missing data.

    Conditional formatting OK

    Confused put in a filtered list and sort by blanks? What do you mean.
  19. Need help on how to highlight duplicated entries and missing data.

    Hi

    I have a workbook that that has data in rows B-E and I-L .

    What im trying to do is to highlight duplicated entries and missing data. What I need to do is for it to look down columns B-E...
  20. Replies
    0
    Views
    92

    Can anyone help on checking data

    Hi

    I have a workbook that has numerous entries and what im trying to do is check them against each other.

    On sheet 1 & 2 In column A I have numerous numbers and what im trying to do is at...
  21. Replies
    4
    Views
    167

    Re: How can I highlight duplicate values

    Sorry I meant duplicate rows of data.

    Lets say row 1 and row 99 have exactly the same data in columns A-D I need them highlighted or better still if it can be done in column E put the word...
  22. Replies
    4
    Views
    167

    Highlight duplicate values

    Hi

    I have a worksheet that I have numerous data in and sometimes they get duplicated.

    Is there anyway that I can highlight the duplicate values that are exactly the same in columns A-D. Ive...
  23. Re: Macro opening folder but not going any further

    Thanks for that.

    When im saving it as a read/write on my PC it fine but when someone else open the sheet where the macro buttons are on another PC as read only when they click on macro button it...
  24. Macro opening folder but not going any further

    Hi

    I have the following macro that opens a folder but when I go to click on one of the files within it once opened it dont do nothing and I need it to open next file I selected.

    Any ideas?
    ...
  25. Replies
    1
    Views
    71

    How do I merge files into one file

    Hi

    I have a folder with 7 workbooks in it.

    All workbooks have 3 tabs in them and they are all named the same in each workbook. What im trying to do is merge all the workbooks together into...
Results 1 to 25 of 55
Page 1 of 3 1 2 3