Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.09 seconds.

  1. Replies
    4
    Views
    105

    Re: Tick macro

    Thanks to Snakehips great idea I realsed, I have the first ten rows hidden anyway so i just change "offset" for Range("AL5").select
    its perfect! thank very much would never of thought of this I a...
  2. Replies
    4
    Views
    105

    Re: Help with a problem with this tick macro

    I think its ahuge improvement thank you Snakehips :-)
  3. Replies
    4
    Views
    105

    Tick macro

    Hi Everyone,
    I have the macro below which I use to treat my own tick boxes in cells "a" = tick

    It works great except you have to click away before it will change again.
    I was woundering if there...
  4. Re: A Macro to warn me if one cell in a row has data but another does not?

    Thank you Mark859
    this is great,
    I didn't need it in worksheet event as its already doing loads so just wantend to add it before
    but everything is working exactly as i wanted so thank you :-)
  5. A Macro to warn me if one cell in a row has data but another does not?

    I have a sheet that is called "Deadlines"

    I input data in the following ranges

    F7:F150
    H7:H150
    I7:I150

    Now people keep missing one or the other of these inputs,
    so can I have a macro that...
  6. MACRO to make all formulas a yellow cell?

    Hi Everyone,
    I'm doing a quick check on a document and need to look at the formulas,
    there are a lot and some are disgused with same font and cell colour.

    I would like a macro the will go...
  7. Re: Help Creating a userform that lets me select the Client I want?

    Wow, thank you this is excellent.
    thank you very much

    Tony
  8. Creating a userform that lets me select the Client I want?

    Hi Everyone,
    I want to make a userform that fills in the number of clients i have and lets me choose which one i want to use?

    So I can make the userform pop up etc. so lets just concentrat on...
  9. How can I edit this so it does it over Many Columns

    Hi Everyone,
    I have this code that works great
    But instead of just working for column "CF"
    I'd like it to do the same but for "CF:CO"
    how can I get it to do this?



    Sub TestNames1()
    Lastrow...
  10. Macro to hide all columns that are before current month

    Hi Everyone,

    I have a ist of columns with dates in row 20 full range is "AB20:DXX20"

    All i want to do is have a macro that when i run it Hide all dates before todays month so right now its 11...
  11. Re: Macro to take ten columns, make 1 column and remove dups and put in a row

    Thanks Fluff,
    this is great,
    and exactly what I wanted.
    Tony
  12. Macro to take ten columns, make 1 column and remove dups and put in a row

    Hi Everyone,

    Please help as i'm having a bit a trouble with this.

    I need a macro to do the following for me,

    get the data from Columns H,I,J,K,L,M,N,O,P,Q (Starting at Row 53 and down to...
  13. A macro to select every sheet on page the is not locked?

    Hi Everyone,

    I just want to go back and fix all my sheets as the number of rogue unlocked cells is becoming large, (mostly my rushing things over the year with a copy here paste there)
    Anyway,...
  14. Macro to add a row after each companies data?

    Hi everyone,
    I have a sheet that has lots of data in it.
    There are lots of row for the same company so i sort the sheet so all the company data from lots of rows is toghther.
    I like a macro that...
  15. Re: Macro to tell me if two coulmns are the same

    Thank you footoo, this looks like it will do the job thank you
    Tony
  16. Macro to tell me if two coulmns are the same

    Hi everyone,

    if it possible id like a macro that does this

    Compares Sheet("Data1") Column J to Sheet("data2") column D
    if both columns are identical put then
    Sheet("Data1") cell M1 = Yes, if...
  17. can i change this vba line so it just pastes values?

    Hi Everyone,

    Can I change this vba line so it just copys and pastes the values?




    srcWS.Rows(qty.Row).EntireRow.Copy desWS.Cells(desWS.Rows.Count, "A").End(xlUp).Offset(1, 0)
  18. Re: Macro to break quantiy for 1,2,3 etc to single lines

    Thanks again mumps,
    you are a saviour!
    Tony
  19. Re: Hide all rows in range that have all black cells

    Mumps this is amazing,
    thank you

    Tony
  20. Macro to break quantiy for 1,2,3 etc to single lines

    Hi everyone,
    but of a problem,

    I've asked my supplier for product codes and they sent me a list in excel

    its in sheet"data1"
    Row 1 is headers
    the data is in columns A:BZ
    now the problem i...
  21. Macro to fill in my caledar sheet with my dates adding extra rows when we get duplicates apointments

    Hi Everyone,
    I have 2 sheets
    1 is "Data"
    2 is "Cale"

    Data has a list of my appointments with my cliennts and their departments
    Cale is a calendar Showing dates in row10 one day at a time...
  22. Hide all rows in range that have all black cells

    Hi Everyone,
    Ok so I need a macro that will hide all the rows that are blank in this range "S10:BXJ5000"
    but only visable cells, i.e. some columns are hidden but might contain data but if all...
  23. Re: Macro to check if a file existists in the same folder

    Thank you footoo,
    this is great :-)
    Tony
  24. Macro to check if a file existists in the same folder

    Hi everyone,
    I have a macro that creates a file called "Times.xlsx" in the same folder the excel doc is in.
    I'd like to check if its already been created before running the macro.
    so I need a bit...
  25. Replies
    4
    Views
    103

    Re: Formula to slipt data into 3 parts

    FormR Thank you, worked great,
    Tyija, great idea, i love the functions as they can be used in so many different ways, thank you
    Big thank you for this i am in time for my 12 noon deadline :-)
    Tony
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4