Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    15
    Views
    90

    Re: code to work out from 2 workbooks

    ok thank you and thanks again for your help.
  2. Replies
    15
    Views
    90

    Re: code to work out from 2 workbooks

    i got it to work now thank you, for some reason the save bit didnt work so i added some code at the bottom to save the range selected this has worked :)

    thanks for your help, can i also share the...
  3. Replies
    15
    Views
    90

    Re: code to work out from 2 workbooks

    Hi i removed the wb.close it now works great thanks.
    Is there anyway to stop the closed book opening?
  4. Replies
    15
    Views
    90

    Re: code to work out from 2 workbooks

    ohh sorry, i worded that wrong, i meant to say if only one spreadsheet is open, then it doesnt update the other spreadsheet, it works great if they are both open, but not if just the one. sorry :)
  5. Replies
    15
    Views
    90

    Re: code to work out from 2 workbooks

    Hi this code works great, but how can i make it work if both workbooks arent open, it works great with both workbooks open, but it doesnt update the other workbook if it is closed.
  6. Replies
    15
    Views
    90

    Re: code to work out from 2 workbooks

    this works great thank you
  7. Replies
    15
    Views
    90

    Re: code to work out from 2 workbooks

    Hi yes please if workbook is closed as well.
    i did try the code below which worked fine in one workbook but when i added the code to the other workbook it crashes for some reason (i just changed the...
  8. Replies
    15
    Views
    90

    Re: code to work out from 2 workbooks

    Hi thanks how do i add it as a link where the book is located ie C:\Users\s21375\Desktop\Book13.xlsm
  9. Replies
    15
    Views
    90

    code to work out from 2 workbooks

    Hi i hope you can help, i have 2 workbooks (Book13 and Book14) these both have the same data, for example in cell C12 is the number 13 in both workbooks, but if someone reduces this number to 11 in...
  10. Replies
    5
    Views
    157

    Re: match and update vba code

    Hi, thank you for the reply, your first option is a great idea, with the combobox for the dates etc, it has to go by area as well though , as different people work in different areas, please can you...
  11. Replies
    5
    Views
    157

    Re: match and update vba code

    HI this is the file I have added to dropbox hope you can have a look, when a name is selected in 'name1' and the area and date I want this to update into sheet4, but when the name is changed in...
  12. Replies
    5
    Views
    157

    Re: match and update vba code

    Hiya thanksfor your reply back hopefully the below steps make sense ��

    Sheet1 I havea……
    Combobox1which has a drop down list of peoples names
    Combobox2 whichhas a drop down list of Areas in the...
  13. Re: textbox cannot enter letters and numbers

    thank you that works great now :) where did i go wrong? sorry i am still learning, thanks for your patience.
  14. Re: textbox cannot enter letters and numbers

    hi i tried this but still cant get it to work please can yhou still help, i think i must be doing it wrong. i put the ' on the code below
    'Select Case TypeName(Ctrl)
    'Case...
  15. Re: textbox cannot enter letters and numbers

    Ok thank you I shall try this. Thanks again
  16. Re: textbox cannot enter letters and numbers

    Hi I am still learning vba code. I'm a beginner. So I dont delete but just put an '?
  17. Re: textbox cannot enter letters and numbers

    Hi thanks for getting back to me. What do you mean commenting it out instead? Thank you for the help
  18. Re: textbox cannot enter letters and numbers

    Hi, the total box at the bottom and to the right, this will need to be deleted, the textboxes that I want to be changed to text/numbers are, airfair, accommodation, misc, food and drink, ground...
  19. Re: textbox cannot enter letters and numbers

    thank you for the advise, hope you can still help me please as I don't know what to do now.
  20. Re: textbox cannot enter letters and numbers

    wow OMG that is well over my head, sorry I am quite new to this and still learning, is it quite easy to change/update?
  21. Re: textbox cannot enter letters and numbers

    originally the currency was for the pricing of food, airfare etc but I don't want to count this now, I would prefer to record where accommodation is or the postcode for example what they had to eat...
  22. Re: textbox cannot enter letters and numbers

    Hi I wantedto put like areas or initials with age(SA47) andwhat food eaten or drank for example wine and steak , originally it was the priceof things but I do not need this now.
  23. textbox cannot enter letters and numbers

    Hi hope youcan help me please, I have attached the file below which I am stuck on, I havea user form ‘enter expenses’ but when I try to enter number/letter combinationin the boxes for Airfare,...
  24. Replies
    5
    Views
    157

    match and update vba code

    Hi hope you can help with vba code ease as i am completely stuck. :)

    On sheet1 I have 2 comboboxes named ‘name1 and name2’, incell C10 this is where the date (dd/mm/yyyy) is inputted in this...
  25. Re: how to use COUNTIF formula to count a specific word twice instead of once?

    no way :) that's great thank you
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4