Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    3
    Views
    59

    Re: Date order on multiple sheets

    You're welcome Patriot. I'm glad to have been able to assist.

    Cheerio,
    vcoolio.
  2. Replies
    3
    Views
    59

    Re: Date order on multiple sheets

    Hello Patriot,

    Try fully qualifying the code as follows:-



    Private Sub CommandButton2_Click()

    Dim wksht As Worksheet
  3. Replies
    12
    Views
    162

    Re: VBA - copy cell if it is not empty

    Hello Kristina,

    As a starting point, see if the following does the task for you:-



    Sub Test()

    Dim c As Range
    Dim lr As Long: lr = Sheet1.Range("E" & Rows.Count).End(xlUp).Row
  4. Replies
    6
    Views
    191

    Re: Struggling with Loops

    Good afternoon Peter,

    The same will happen with my code. I'm sure its just a typo on the OP's part.

    I like your formula idea BTW.

    Cheerio,
    vcoolio.
  5. Replies
    6
    Views
    191

    Re: Struggling with Loops

    Hello Kevin,

    Here's another option:-



    Sub Test()

    Dim lr As Long
    Dim fValue As Range, c As Range, x As Integer
  6. Re: Move certain data from one sheet to another

    Hello Asherzt,

    I've just tested this on a sample of what I perceive your workbook to look like, i.e. based on your opening post, and I do not receive any errors. The code works as it should.
    ...
  7. Re: Move certain data from one sheet to another

    Hello Asherzt,

    Try the following code:-



    Sub Test()

    Application.ScreenUpdating = False
  8. Re: VBA autofil formula in Collumn D if data is inputted into column B

    You're welcome Ljk. I'm glad to have been able to assist.

    For the sake of anyone else who may come by this way looking for a similar solution, could you please post what the 'fix' was.
    Thanks...
  9. Re: VBA autofil formula in Collumn D if data is inputted into column B

    Hello LjKennedy,

    Try the code amended as follows:-



    Sub Ratio_BC()

    Dim Lastrow As Long
  10. Re: Excel VBA automatically copy entire row to different sheets based on cell value

    Hello Nikzulfaizan,

    Another option:-



    Sub Test()

    Dim ar As Variant, i As Integer
    Dim ws As Worksheet, sh As Worksheet
  11. Re: mtach - copy entire row from 1 sheet to another

    Hello Oddworld,

    Here's an option:-



    Sub Test()

    Dim fValue As Range
    Dim c As Range
  12. Replies
    12
    Views
    395

    Re: Combine Multiple Worksheets

    You're welcome Nanogirl.

    Cheerio,
    vcoolio.
  13. Replies
    12
    Views
    395

    Re: Combine Multiple Worksheets

    Hello Nanogirl,

    Try it as follows:-


    Sub Test()

    Dim ws As Worksheet
    Dim sh As Worksheet: Set sh = Sheets("Combined")
    Dim lr As Long, sr As Long
  14. Replies
    29
    Views
    1,075

    Re: Help with formula to arrange rows in numerical order.

    Hello Frankie,

    I'm assuming that the numbers are in Columns A:E starting in Row2 with headings in Row1 and that you are sorting on Column A values. If so, try this code:-



    Sub SortIt()
    ...
  15. Replies
    12
    Views
    395

    Re: Combine Multiple Worksheets

    Hello Nanogirl,

    I had assumed that you had placed the headings in Row1 of the already created "Combined" sheet.
    Do you mean that you would like the headings from ALL the worksheets transferred to...
  16. Replies
    12
    Views
    395

    Re: Combine Multiple Worksheets

    Hello Nanogirl,

    I just picked up on your thread and here's another option for you (including placing the source sheet names in Column A of the Combined sheet):-



    Sub Test()

    Dim ws...
  17. Re: Can you copy a row from one worksheet to another dependant on drop menu selection

    Hello Steve,

    You're welcome. I'm glad to have been able to assist. Remove the standard module (module1) BTW!

    You can give thanks/likes if you feel like it by clicking on the up arrow over to...
  18. Re: Can you copy a row from one worksheet to another dependant on drop menu selection

    Hello Steve,

    After having a look at the code in the sheet module, I noticed that you still haven't changed this line of code:-


    Target.EntireRow.Copy Sheet2.Range("A4") .End(3)(2)

    to
  19. Re: Can you copy a row from one worksheet to another dependant on drop menu selection

    Hi Steve,

    So it works now? If not, upload a sample of your workbook to a free file sharing site such as ge.tt or Drop Box then post the link to your file back here. Make sure that the sample is an...
  20. Re: Can you copy a row from one worksheet to another dependant on drop menu selection

    Did you change the line of code back to the way it was in post #3 ?
    Do you have headings in row3 of sheet2?

    Cheerio,
    vcoolio.
  21. Re: Can you copy a row from one worksheet to another dependant on drop menu selection

    Hello Steve,

    I'm assuming that you have headings in Row3 of sheet2 so change this line of code:-


    Target.EntireRow.Copy Sheet2.Range("A4") .End(3)(2)


    back to
  22. Re: Can you copy a row from one worksheet to another dependant on drop menu selection

    Hello Steve,

    As we don't have any idea of how your worksheets are set out, let's assume that:

    - The data in your source worksheet starts in Row2 with headings in Row1.
    - The data extends from...
  23. Replies
    12
    Views
    557

    Re: Auto Delete Data

    Hello tlc,

    Are you saying that all rows (from Column A to Column Whatever) below row 11721 are blank or displaying a zero(0) as the result of a formula calculation?

    Cheerio,
    vcoolio.
  24. Re: vba to run through sorted list and copy rows in each sorted group into a new tab

    Hi Patricia,

    You're welcome. I'm glad to have been able to assist. You gave us a very clear description which helps tremendously so thank you for that.

    Thanks for the feed-back.

    Cheerio,...
  25. Re: vba to run through sorted list and copy rows in each sorted group into a new tab

    Hello Patricia,

    Try the following code (untested):-



    Sub CreateNewShtsTransferData()

    Dim sht As Worksheet, ws As Worksheet
    Dim lr As Long, i As Long
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4