Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.31 seconds.

  1. Re: copying cells from sheet 1 to various other sheets

    You're welcome & thanks for the feedback
  2. Re: VBA - Cycle Through All Worksheets, Get Unique Values

    You're welcome & thanks for the feedback
  3. Replies
    2
    Views
    9

    Re: Normal v Array formulae

    It's multiplying 2*5, ie the values in A1:B6 that are on the same row as the formula

    If you select the cell & then click "Evaluate formula" on the formula tab, you can see what it's doing.
  4. Re: VBA - Cycle Through All Worksheets, Get Unique Values

    How about
    Sub jaime1182()
    Dim Ws As Worksheet, Uws As Worksheet
    Dim Cl As Range
    Dim Dic As Object
    Dim i As Long

    Sheets.Add(Sheets(1)).Name = "Unique"
    Set Uws =...
  5. Re: copying cells from sheet 1 to various other sheets

    As long as there is a value in col D then it should get copied.
  6. Re: copying cells from sheet 1 to various other sheets

    You don't need to create a macro, that's what the code in post#45 is.
    To create a shape & assign the macro to it, have a look here https://www.excelcampus.com/vba/macro-buttons/
    and scroll down to...
  7. Re: Copy 2 worksheets to new workbook without code

    How about
    Sheets(Array("MANAGERS", "Sheet1")).Copy
  8. Re: copying cells from sheet 1 to various other sheets

    If you select A5, then on the view tab select Freeze panes, then select freeze panes again from the drop down menu. That will keep the top 4 rows visible at all times & you could put a button, or...
  9. Replies
    6
    Views
    131

    Re: how to extract only character's ???

    Or slightly safer (but volatile)
    =TEXTJOIN("",TRUE,IF(ISERR(MID(A3,ROW(INDIRECT("1:100")),1)+0),MID(A3,ROW(INDIRECT("1:100")),1),""))

    This is an array formula & needs to be confirmed with Ctrl...
  10. Replies
    11
    Views
    255

    Re: Complicated Project

    Not quite sure why you would have got that error, if it worked first time round.
    Try deleting the code & then copy paste it back in. Do you still get the error?
  11. Replies
    11
    Views
    255

    Re: Complicated Project

    What was the error message & number & what line of code was highlighted when you click Debug?
  12. Replies
    6
    Views
    91

    Re: Reset Excel Usedrange not working

    Try deleting all rows below your data & all columns to the right of your data, then save & close the workbook.
  13. Replies
    6
    Views
    131

    Re: how to extract only character's ???

    Hi & welcome to MrExcel.
    How about

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  14. Replies
    6
    Views
    91

    Re: Reset Excel Usedrange not working

    Try using .Clear rather than .ClearContents
  15. Re: A tuff one, Copy and paste if criteria is partial met

    Or if you do want a macro, try
    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.CountLarge > 1 Then Exit Sub
    If Target.Address(0, 0) = "A1" Then
    ...
  16. Replies
    3
    Views
    68

    Re: VBA sumproduct with dynamic range

    You're welcome
  17. Re: A tuff one, Copy and paste if criteria is partial met

    Do you need code? This can easily be done with a formula. In A4 copied down & across
    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px...
  18. Replies
    3
    Views
    68

    Re: VBA sumproduct with dynamic range

    Try
    .Formula = "=SUMPRODUCT(--(MONTH(sales!$B$2:$B$" & Lastrow & ")=$A2),sales!$K$2:$K$" & Lastrow & ")"
  19. Re: copying cells from sheet 1 to various other sheets

    Ok, try this
    Sub sbrown64()
    Dim Cl As Range
    Dim Ky As Variant
    Dim Ws As Worksheet
    Dim UsdRws As Long

    Set Ws = Sheets(1)
    UsdRws = Ws.Range("D" & Rows.Count).End(xlUp).Row...
  20. Re: copying cells from sheet 1 to various other sheets

    The user doesn't need to delete the data on the company sheets, the macro can do that.
    It's more a matter of whether the users are changing or adding anything to company sheets.
  21. Re: copying cells from sheet 1 to various other sheets

    Thanks for the file, could you also please answer the second part part of my question in post#36
  22. Re: copying cells from sheet 1 to various other sheets

    Can you please post the link to the thread, as per forum rules
    Thanks
  23. Replies
    5
    Views
    139

    Re: Overrule conditional formatting

    You're welcome & thanks for the feedback
  24. Replies
    3
    Views
    73

    Re: Fill blanks macro

    How about
    Sub donniedorian()
    Dim Cl As Range
    For Each Cl In Selection
    If Cl.Value = "" Or Cl.Value = 0 Then Cl.Value = 1
    Next Cl
    End Sub
  25. Re: copying cells from sheet 1 to various other sheets

    Will you be adding new rows to the Master sheet, or will you be replacing it with new data?
    If the former, are you happy to delete the info on the company sheets & then copy all the data over again?
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4