Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.84 seconds.

  1. Re: It won't let me change the value to a dollar sign!

    In your case, you don't seem to need to change formatting, but actually separate data. For that you need to choose your delimiter option, then click Next to proceed through the steps. The method I...
  2. Re: It won't let me change the value to a dollar sign!

    Welcome to the Board!

    It is available in your version of Excel, so I'm not sure what you mean. Is it disabled?
  3. Replies
    5
    Views
    165

    Re: Pivot Table Help

    Then you'll need to add the column in your raw data.
  4. Replies
    5
    Views
    165

    Re: Pivot Table Help

    What are you struggling with? You can always upload your workbook to a file sharing site like OneDrive, then post the link back here. Just make sure to remove any sensitive personal/company...
  5. Thread: Lookup names

    by Smitty
    Replies
    8
    Views
    289

    Re: Bbayyousif

    Then I suggest you give more details.
  6. Re: How can I make a macro get the location of the selected cell?

    In VBA, the selected cell is ActiveCell.

    SO:

    ActiveCell.GoalSeek...

    HTH
  7. Replies
    5
    Views
    165

    Re: Pivot Table Help

    Welcome to the Board!

    The easiest thing would be to add a column in your source data, and add that to your Values field. Then change the Values field setting to Max. Otherwise, you can try a...
  8. Thread: Lookup names

    by Smitty
    Replies
    8
    Views
    289

    Re: Bbayyousif

    Welcome to the Board!

    Take a look at VLOOKUP.

    HTH
  9. Replies
    2
    Views
    925

    Re: IS VBA going away?

    VBA is not going away, however, no improvements are slated to be made to the UI. The Object Model will continue to be updated as new features are released though.

    There are investments being made...
  10. Replies
    1
    Views
    142

    Re: Sorting Data in Dropdown Menus

    Welcome to the Board!

    Check out Dependent Data Validation.
  11. Re: Reporting tabular Data with Summary of Common Column Data above details.

    Go to PivotTable Tools > Design > Report Layout > Show in Tabular form
  12. Re: Reporting tabular Data with Summary of Common Column Data above details.

    Welcome to the Board!

    You can do what you want with a PivotTable, just put all of your fields in the Rows section, not the Values section. Add a Slicer for teacher, and you should be good to go....
  13. Re: Help with Record VBA - Copy and paste numbers

    Yes, if you have existing VBA code, it would be helpful to provide that. Make sure to point out where it's not doing what you want, and use code tags: [ code ] your code here [ /code ] (no spaces) to...
  14. Replies
    5
    Views
    210

    Re: macro for saving tab as CSV

    What's the error?

    Try:

    ActiveWorkbook.SaveAs Filename:="C:\Users\bbeachler\Desktop" & ActiveSheet.Name & ".txt", _
    FileFormat:=xlText, CreateBackup:=False
  15. Re: Help with Record VBA - Copy and paste numbers

    For starters, there's no need to select. Just assign the value to the cell directly:

    Range("D24").Value = 6



    I have no idea what you're asking here, but have you tried a For Each...Next loop?
  16. Replies
    5
    Views
    210

    Re: macro for saving tab as CSV

    Have you tried recording a macro doing what you want?

    Once you have the recorded code, you can use the sheet name as the filename (ActiveSheet.Name).

    HTH
  17. Re: VBA Protected sheet allow Select Visible Cells

    So you're trying to paste data into locked cells on a protected sheet?

    Just unprotect the sheet, paste, then reprotect.

    ActiveSheet.Unprotect
    Copy/Paste
    ActiveSheet.Protect

    HTH
  18. Re: Automatically transferring a row to an archive once a specific cell becomes filled

    If you want, you can post the workbook on a file sharing site such as OneDrive, then post a link back here and someone can take a look. Just be sure to remove any sensitive personal information first.
  19. Re: Automatically transferring a row to an archive once a specific cell becomes filled

    Select the entire range you want highlighted, then in Conditional Formatting, you can use the Formula option > =$N2="" > format as desired. Note the $ on N, which will tell Excel to only look at...
  20. Re: Automatically transferring a row to an archive once a specific cell becomes filled

    Welcome to the Board!

    It's generally not a good idea to separate your data like that, because you then lose the ability to easily summarize it. I'd use some code to hide the rows that meet your...
  21. Replies
    3
    Views
    217

    Re: Any VBA tricks for Array Formula burdens?

    What's the array formula doing? Is it possible you could replace that with a Power Query routine?

    Otherwise, the only other thing I see you could do it set ScreenUpdating to False, and Calculation...
  22. Re: Static Date Change based on Drop Down Selection

    Nope, just change this one line, and leave everything else the way it is:

    Set rng = Target.Parent.Range("A1")

    to:

    Set rng = Target.Parent.Range("A1:A100")

    Or whatever the ending row is....
  23. Re: Static Date Change based on Drop Down Selection

    Change the target range to suit: Set rng = Target.Parent.Range("A1")
  24. Re: Static Date Change based on Drop Down Selection

    Welcome to the Board!

    With that many selections, I'd use a lookup table and reference it in your code. This assumes you have a table on a sheet named List:


    Private Sub Worksheet_Change(ByVal...
  25. Re: Lookup in other workbook goes #REF! when closed

    INDIRECT doesn't work on closed workbooks, but you can use INDIRECT.EXT, which is part of the MOREFUNC add-in.

    HTH
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4