Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.28 seconds.

  1. Replies
    3
    Views
    115

    Re: Hide Data in Running Total Pivot

    https://www.excelforum.com/excel-charting-and-pivots/1286857-hide-data-in-running-total-pivot.html#post5178755

    crossposted
  2. Replies
    4
    Views
    121

    Re: VLOOKUP based on drop down list

    If it works, then why wouldn't it be ok. Afterall, it is your spreadsheet and you are the one that needs to be happy.
  3. Replies
    4
    Views
    121

    Re: VLOOKUP based on drop down list

    v
    C
    D
    E
    1




    2
  4. Replies
    10
    Views
    201

    Re: IF(AND with IF(OR

    =if(or(A1="True",B1="True",C1="True"),"True",if(and(A1="False",B1="False",C1="False"),"False","Unknown")))
  5. Replies
    5
    Views
    66

    Re: Transposing a data table

    Glad to have helped
  6. Replies
    5
    Views
    66

    Re: Transposing a data table

    An alternative is to use Power Query. Look at the link in my signature if you are unfamiliar with this concept. Here is the Mcode


    let
    Source =...
  7. Replies
    12
    Views
    470

    Re: Macro to Combine Data from all tabs

    crossposted: https://www.excelforum.com/excel-programming-vba-macros/1286684-macro-to-combine-data-ranges-from-multiple-tabs.html#post5177939

    Please read: ...
  8. Replies
    12
    Views
    251

    Re: Combine Multiple Worksheets

    Have you considered using Power Query. Quick and simple to achieve what you are looking to do. Look at this video.

    https://www.youtube.com/watch?v=LSDQGWdgNJs
  9. Replies
    12
    Views
    470

    Re: Macro to Combine Data from all tabs

    Here is a MrE video that should walk you through the steps. Fairly simple and easy to follow.

    https://www.youtube.com/watch?v=LSDQGWdgNJs
  10. Re: Update prices automatically on a specific date

    Can you show us a sample of your data before and after. Does not need to be many records, but enough to be representative of your worksheet
  11. Replies
    12
    Views
    470

    Re: Macro to Combine Data from all tabs

    Without seeing your data, it is difficult to provide a PQ solution. If you are interested in a PQ option, suggest you upload a sample file to a third party location such as Dropbox or Box.net. Be...
  12. Re: VBA Move Data to different Worksheet if specific cell not empty

    crossposted: https://www.excelguru.ca/forums/showthread.php?10168-Help!-Transfer-Data-from-a-few-cells-basee-on-value-of-another-cell-in-that-row

    and
    ...
  13. Replies
    12
    Views
    470

    Re: Macro to Combine Data from all tabs

    Have you looked at using Power Query. This is a very simple step in PQ which the Excel team developed to do just this.
  14. Replies
    1
    Views
    84

    Re: How To VBA Code To All Worksheets?

    Option Explicit


    Sub CleanUp()
    Dim ws As Worksheet
    For Each ws In Worksheets
    With ws
    .Value = Evaluate("if({1},trim(clean(substitute(" & .Address & ",char(160),""...
  15. Re: Counting records in 1 column based on another

    Another option. Not as simple as Sandy but still works


    let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"ID",...
  16. Re: Power Query - Pivot with multiple values

    If this presentation works for you, then use the Mcode shown beneath it in Power Query

    Data Range

    <tbody>


    A
  17. Re: Combine multiple row into one with line breaks using sql

    How about importing your table into Excel and creating a Pivot Table.

    Data Range

    A
    B
    C
    D
    E
    F
  18. Re: Macro to copy last row to next row, Formula and format

    I am a bit confused. Are you wanting to copy the data in columns A to I to the next row or just the formula in column A. Your request is not clear on this matter.
  19. Replies
    3
    Views
    91

    Re: Pivot Table Dates

    Inserting the data into a Pivot Table gets the following results. Then using simple excel subtract one value from the other for a difference

    Data Range

    A
    B
    C
    D
    E
    F
  20. Replies
    3
    Views
    91

    Re: Pivot Table Dates

    Your sample data (really need to see more data in your sample example) does not represent your explanation. I am confused as you have fields in your explanation that are not shown in your example.
  21. Replies
    3
    Views
    92

    Re: Linking worksheets

    ='worksheetname'!$A$1

    Add the exclamation mark
  22. Replies
    7
    Views
    139

    Re: Cicle through worksheets

    Since Dante has supplied a workable solution, there is no need to investigate why. However, it did work in my example I created to test. Good luck as you have a workable solution and that is what...
  23. Replies
    7
    Views
    139

    Re: Cicle through worksheets

    Option Explicit


    Sub FindEE()
    Dim ws As Worksheet
    For Each ws In Worksheets
    If ws.Range("P4") = ws.Name Then
    ws.Activate
    Exit Sub
    End If
  24. Replies
    2
    Views
    65

    Re: Formula Needed

    =if(B1="","",A1-B1-C1+D1)
  25. Re: Opening a Macro from another work sheets query

    If you specify the workbook to act upon, you should have no issues.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4