Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: Sort and organize date based on the adjoining column containing data

    Ok, I just figured it out :hammer: I simply put it in a cell and the result appeared! Thanks again for your help with the f\u questions.
  2. Re: Sort and organize date based on the adjoining column containing data

    Is it possible to put these formulas into cells so they auto calculate and get displayed in a MsgBox?
  3. Re: Sort and organize date based on the adjoining column containing data

    Thanks for pointing showing me that function. I'm still learning VBA and haven't gotten to Functions yet.
  4. Replies
    3
    Views
    127

    Re: Override default page breaks

    I tired that but while I got a new solid line the dotted line remained right where it was when I tried to drag it.




    Ah, I had no idea that was there. It's called "Print Titles"! :laugh: That...
  5. Sort and organize date based on the adjoining column containing data

    I want to sort values that are in Column C. But I want those values chosen based on whether Column D contains data.


    If I were to say what I want in English I'd put it this way:


    Select...
  6. Replies
    3
    Views
    127

    Re: Override default page breaks

    I tried the following work arounds: Print selection, "Fit all on one page" that didn't work and "Fit all rows" and that worked.
  7. Replies
    3
    Views
    127

    Override default page breaks

    My worksheet has 214 rows. The first page break, a dotted line, appears in row 51.


    But because I want my printout to contain 71 rows, I tried dragging that dotted line down to row 71. The...
  8. Re: How to sort Col A based on cell content; date-no date

    Perfect! Thanks so much!
  9. How to sort Col A based on cell content; date-no date

    Column A in the Rows of my worksheet either contain a date or are empty.

    I need a method that would sort the column the lists cells that contain dates and that contain no date.
  10. Replies
    49
    Views
    1,628

    Re: Automate date range entry

    Great! Thanks again and thanks for for showing me this.

    Now I can study that formula, which was developed by someone like you, on this very forum! Maybe I will finally begin to understand how it...
  11. Replies
    49
    Views
    1,628

    Re: Automate date range entry

    Ok, I couldn't wait ;)

    Thanks! It looks like you've fixed it.

    Would it mess anything up if I just deleted the "Copy of 2018 Details" sheet, since it shouldn't even be in the workbook?
  12. Replies
    49
    Views
    1,628

    Re: Automate date range entry

    Before we go any further let me address this sheet.

    I'm not at all sure why that sheet got added because there is no reason for it to be there!

    I tried deleting it but it didn't help.
    ...
  13. Replies
    49
    Views
    1,628

    Re: Automate date range entry

    I'm sorry to be back but...:banghead:

    I've been making entries into my updated MB19 spreadsheet and the Data from the Details sheet isn't getting added to the Master sheet.

    The formula for...
  14. Re: Getting spreadsheet to someone without XL

    I'm guessing the receiver would have to have one of them before that option would work, but this receiver isn't very computer savvy, or he'd have XL and it wouldn't be a problem :laugh:
  15. Re: Getting spreadsheet to someone without XL

    Thanks for those suggestion. Since the receiver only needs to Read the data I opted for .pdf.

    I hadn't thought to check the save filetype options where I found a number of additional options.
  16. Re: Getting spreadsheet to someone without XL

    Like that idea, mostly because it forced to to figure out how to do it. I'm guessing Filetype but I didn't find either of those options. I found a plethora of alternatives like .html, .txt .cvs and...
  17. Getting spreadsheet to someone without XL

    I need to the data on a spreadsheet to someone who probably doesn't have access to XL. It though about printing it out, then scanning it back in as a jpg file but that seems lame. There must be a...
  18. Replies
    49
    Views
    1,628

    Re: Automate date range entry

    Yes, I've saved all the iterations of the macro. Thanks
  19. Re: Issue Running macro on workbook in the cloud

    Thanks for that F/U, I will keep it in mind for future ref. At this point I am only dealing with one WB, from my home office and I am the only one editing it. I put it in the cloud for safe keeping...
  20. Replies
    49
    Views
    1,628

    Re: Automate date range entry

    Thanks for the Wait code, I will add it to my list of favorites.

    I plan tol try it but I doubt I will need it because it's easier to just run the macro on my HD then save a copy in both places....
  21. Re: Issue Running macro on workbook in the cloud

    Thanks for sharing that disappointing bit of information. Seems like this issue would be more front and center, with all the cloud storage being done today. I was surprised that no one seems aware...
  22. Re: Can I create a "Button" on a sheet that only becomes visible in the month of Jun?

    Ok, thanks, I'll do that. And thanks again for got code.
  23. Re: Can I create a "Button" on a sheet that only becomes visible in the month of Jun?

    The sheet i would put this in would be sheets("Master")

    I'm taking a course in VBA so I'm a real novice, which means I'm not certain where to put this.

    I could put it in a module but I'm...
  24. Re: Can I create a "Button" on a sheet that only becomes visible in the month of Jun?

    This looks super simple. Even I understand it, i think.

    It looks me like the button will appear on the current worksheet every year, for the entire month of Jun, with no need to update it. If...
  25. Re: Can I create a "Button" on a sheet that only becomes visible in the month of Jun?

    Awsome! Thanks to much!

    But here's the rub... I'm turning this WB over to someone who, most likely, will not know how to edit a macro.
    Is it possible to code it so it updates itself, based on...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4