Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.04 seconds.

  1. VLOOKUP code deleted if user types in cell

    Hi,
    I have this code in various cells,obvioulsy each with a different cell reference.


    =IFERROR(VLOOKUP($B12,INDIRECT("INFO!$CV$2:$DB$"&COUNTA(INFO!$CV:$CV)),5,FALSE),"")

    I select a customers...
  2. Replies
    0
    Views
    8

    Multiple column table advice please

    Ive only done tables in one column.
    I have some customers details as follows.
    Column CV Name
    Column CX Address
    Column CZ Grass Paid
    Column DB Grass Mileage

    I needed to delete a customer so...
  3. Name manager question regarding new entries but not by the owner

    Hi,
    Last week i went through all my names in the name manager & cleaned everything up as there was quite a few duplicates etc.

    Yesterday i added 3 new worksheets to my workbook
    GRASS
    G INCOME...
  4. Replies
    4
    Views
    68

    Re: ComboBox set focus

    Thanks it worked as you said.

    I didnt know that but will now remember it

    Cheers again,took me hours to not find anything
  5. Replies
    4
    Views
    68

    Re: ComboBox set focus

    Hi,
    I am still looking for this error but so far no joy.
    Below is the two sets of information to assist you if i may.

    When i come to worksheet CLONING a userform opens up.
    The Focus is set on...
  6. Re: Macro etc to select entry in drop down list

    Hi,
    That did the trick but the other day that didnt work for me.
    Anyhow now it works fine.

    have a nice day.
  7. Re: Macro etc to select entry in drop down list

    Having said that the code in post #7 works providing a name is in cell G13 and will not work if empty
  8. Re: Macro etc to select entry in drop down list

    mumps,

    I have just come acroiss this page that you also helped somebody with of nearly the same thing as what i require.
    ...
  9. Re: Macro etc to select entry in drop down list

    Hi,
    Still no joy for me as when i open the worksheet INV i see this message, Run time error 1004 Application defined or object defined error.

    So some info for you.

    Drop down list is on...
  10. Locking a cell to delete value not formula

    Hi,
    if you lock a cell which has a formula in it of which then returns a value in the same cell does the formula get deleted when you delete the cells value.
  11. Re: Macro etc to select entry in drop down list

    Mumps,
    i couldn't find this earlier so I will check it out tomorrow.
  12. Re: Renaming files now obviously stops code working

    Hi,
    I have tried the new code as mentioned in post #2 but not i dont even see the msgbox pop up.
    With regards post #3 what / or how do i go about that
  13. Renaming files now obviously stops code working

    Hi,
    I have this code in use which when in my database & i press its button the corresponding invoice is then shown.
    At the time the invoice were saved like this,
    1.pdf
    2.pdf
    3.pdf

    Private Sub...
  14. Replies
    2
    Views
    27

    Re: Macro to rename numerous files

    Morning,
    Ive had to cancel that idea as ive notice a few which has the same date but doesnt match invoice so manually doing it.

    Thanks
  15. Replies
    2
    Views
    27

    Macro to rename numerous files

    Morning.
    I was wondering if its possible to rename a bunch of pdf files that reside all in the same folder ?

    Currently the files are just named like,
    1.pdf
    2.pdf
    3.pdf

    All the files have a...
  16. Re: Add date to existing output of pdf file

    Works well thanks
  17. Upon open worksheet select entry in drop down list

    I thought I had enquired about this but after going through my posts & not finding it I assume that I then didnít.

    As per title.
    My drop down list has a blank entry at the the top of the...
  18. Re: Add date to existing output of pdf file

    Thanks I will tray that in the morning.
    Can you advise a macro which can change all the other 145 files to match the same format other than me manually doing them one by one.
  19. Add date to existing output of pdf file

    Hi,

    Here is the partial piece of code that is working & in use.

    strFileName = "C:\Users\Ian\Desktop\REMOTES ETC\DR COPY INVOICES\" & Range("N4").Value & ".pdf"



    The file above once saved...
  20. Replies
    6
    Views
    120

    Re: Expenses code saves Income sheet ??

    Sorry i missed that one

    Cheers
  21. Replies
    7
    Views
    75

    Re: Save files in accordance of month etc

    Sorry my mistake.
    yes you are correct it works fine.

    Thanks
  22. Replies
    6
    Views
    120

    Re: Expenses code saves Income sheet ??

    Here we go,
    The worksheet is called GRASS SUMMARY
    This is what you see on the one page
    https://www.theremotedoctor.co.uk/forums/E2.jpg

    Left side is Income & Right side expenses.

    There are...
  23. Replies
    6
    Views
    120

    Re: Expenses code saves Income sheet ??

    Hi,
    That gives me the same result.
    The files is saved in the correct folder.
    The file is named correctly
    The problem is the item that i am now viewing.

    As opposed to me reading EXPENSES SHEET...
  24. Replies
    4
    Views
    110

    Re: Can you check my code please

    Majic works a treat many thanks.
    Would you mind taking a quick peak at this.
    Basically 2 code.
    Code 1 saves sheet 1 BUT code 2 also saves sheet 1 for no reason that i can see.
    ...
  25. Replies
    7
    Views
    75

    Re: Save files in accordance of month etc

    Nice but not quite.
    Reason being June & July come before May
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4