Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.00 seconds.

  1. Replies
    4
    Views
    204

    Re: VBA to fill down 10 rows

    Ah! Rick! thank you very much. I have spent many hours trying to work this out.
    Your code is perfect for what I need. I can get some sleep now :)

    thanks again

    Rory
  2. Replies
    4
    Views
    204

    Re: VBA to fill down 10 rows

    Hi
    Thanks, but that won't help me. I need it to drag the cell down to copy it. That just moves me to the cell 10 rows away.
    Rory
  3. Replies
    4
    Views
    204

    VBA to fill down 10 rows

    Ok guys I am finally giving up after trying to work this outfor most of the day.
    I have a code that takes me to the last row of formulas I have copied down. It then selects that entire row.I would...
  4. Re: Copy and paste data from one row to another VBA

    awesome! thank you so much Mick. :biggrin:
  5. Re: Copy and paste data from one row to another VBA

    Thanks Mick
    I like that better than the other version. Its pretty much perfect for what I need apartfrom when pasting to a row beneath the selection it still puts in in the rowabove
    If I select...
  6. Re: Copy and paste data from one row to another VBA

    Hi Mick

    I have made an adaption with the following code that is runfrom a normal button:
    Sub movecells()
    Dim Target As Range
    Range(Cells(Selection.Row, 1), Cells(Selection.Row,7)).Select
    Set...
  7. Re: Copy and paste data from one row to another VBA

    Thanks Mick

    That works good altho when i select a row below the first selection to paste the data into it actually pastes it into the row above. It works fine if i choose a row above but if i...
  8. Copy and paste data from one row to another VBA

    Hi Folks

    I have a table of data and I would like to be able to copy arow of data and paste it into a different row using VBA and a button.
    My table goes from columns A-G and infinite rows down....
  9. Replies
    4
    Views
    210

    Re: Multiple Worksheet_Deactivates

    Yes. That’s correct. I quite like your bit of code. That might be useful ... thanks
  10. Replies
    4
    Views
    210

    Multiple Worksheet_Deactivates

    Hi Folks

    I have the following code that basically does not allow someone to leave the sheet they are on unless all required field are complete. It works perfect for my needs

    My question is is...
  11. Replies
    13
    Views
    358

    Re: Input box query

    Thanks everyone. Much appreciated ��
  12. Replies
    13
    Views
    358

    Re: Input box query

    Ok. It creates a list box in the next cell but it doesn’t let me populate it. I pasted all the code you gave me in the same sheet?

    thanks
  13. Replies
    13
    Views
    358

    Re: Input box query

    Got it! Works perfect�� Shame it is yes no cancel and not something like 1,2,3. Thanks for this. ��
    rory
  14. Replies
    13
    Views
    358

    Re: Input box query

    Hi yongle

    im not really sure what to do with active x list box ����

    thanks Rory
  15. Replies
    13
    Views
    358

    Re: Input box query

    Hi Mick

    i pasted that into my sheet but it does not seem to do anything when I put a date in column a. I also tried it in the workbook module but no luck ��
  16. Replies
    13
    Views
    358

    Input box query

    Hi Guys

    column A on my spreadsheet is used for inputting the date and column c is used for inputting Bin1 or Bin2 or Bin 3 on the same row.
    I would like if possible for an input box to appear...
  17. Replies
    22
    Views
    709

    Re: worksheet deactivate not working

    I guess its not bad here. We holiday'd to Florida for about 10 years in a row. Haven't been for a few years now but was like our second home for a while.

    Great fun! I do like a good coaster!
    ...
  18. Replies
    22
    Views
    709

    Re: worksheet deactivate not working

    Thanks.

    I am in the far north of Scotland. Its actually a beautiful sunny day today here so I am off outside to get some.

    Thanks again.

    Rory
  19. Replies
    22
    Views
    709

    Re: worksheet deactivate not working

    Hi

    I was just about to reply actually. I think I am making this more complicated than it needs to be. You have actually given me at least 3 bits of code that will make my life significantly...
  20. Replies
    22
    Views
    709

    Re: worksheet deactivate not working

    This is correct apart from having todays date in y,z and aa. It might be todays date is in Y and Z and AA have a -. It might be all three have todays date. It might be Z and AA have todays date...
  21. Replies
    22
    Views
    709

    Re: worksheet deactivate not working

    Hi

    They are Y Z and AA

    Thanks

    Riry
  22. Replies
    22
    Views
    709

    Re: worksheet deactivate not working

    Hi
    No. All three columns are cool mpletef on the same day. One or more may have today's date and any that don't would have a dash.
  23. Replies
    22
    Views
    709

    Re: worksheet deactivate not working

    Thanks

    Think you are correct and i thank you for your time and patience with me.

    I have modified the current script you gave me to change when the date is input. Thats actually perfect for 1...
  24. Replies
    22
    Views
    709

    Re: worksheet deactivate not working

    this is an example of the other formula i use to generate 'complete'

    =IF(OR(M15=TODAY(),M15="-")*AND(OR(L15=TODAY(),L15="-")*AND(OR(K15=TODAY(),K15="-"))),"complete","")
  25. Replies
    22
    Views
    709

    Re: worksheet deactivate not working

    Hi

    Depending on which report sheet i am using there are different formulas. The reason for this is on some sheets there is 1 authorisation columns and others there are 2 or 3.

    The...
Results 1 to 25 of 55
Page 1 of 3 1 2 3