Search:

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

Search: Search took 0.00 seconds.

  1. Replies
    3
    Views
    395

    Thanks 5 Star, you are the man. Worked fine and...

    Thanks 5 Star, you are the man. Worked fine and it now saves me one step.

    thanks Again
  2. Replies
    3
    Views
    395

    Text to Date Value

    I receive a date as the following text, Feb 14 2014, 04:00 PM EST and would like to use a formula to convert it to a date value. I have played around with (left(cell)11) and that will trim it to Feb...
  3. Replies
    4
    Views
    742

    Data Validation Question

    I like to use data validation drop down picks to fill in a cell. My question is about the size of the drop down window and the size of the font. Is there any control over these two aspects? I would...
  4. Replies
    13
    Views
    870

    RetiredGeek, I can use this approach but what if...

    RetiredGeek, I can use this approach but what if we place an "X" in column A beside the ones to print and then remove the "X"'s after the print job is done?
  5. Replies
    13
    Views
    870

    Maud, not working for me. I am using excel 2007...

    Maud, not working for me. I am using excel 2007 if that makes a difference. I think I will play around with it and try a few different things. At this point I will not ask you to do any more work on...
  6. Replies
    13
    Views
    870

    Thanks Maud and RetiredGeek, I appreciate the...

    Thanks Maud and RetiredGeek, I appreciate the work you have done but I still struggle with the worksheet "auto letter revised 3". The pint button seems to be hidden by the select name box. I can't...
  7. Replies
    13
    Views
    870

    Maud, Doesn't the "print all" button print all...

    Maud,

    Doesn't the "print all" button print all customers listed in the customer database sheet? I was looking to print only the subset selected by the dropdox on the Letter sheet.

    Al
  8. Replies
    13
    Views
    870

    Thanks Maud for your help. The reason I wanted to...

    Thanks Maud for your help. The reason I wanted to use a dropbox was to be able to select a subset of names or just one name, from my customer data file. This way I need not print every customer...
  9. Replies
    13
    Views
    870

    I have attached a sample spreadsheet of what I am...

    I have attached a sample spreadsheet of what I am after. Hope this helps.
  10. Replies
    13
    Views
    870

    Sequential print from list

    I have a spreadsheet with a form letter. I currently use a drop down list to select a name which then uses Vlookup to add the correct mailing address for each name. I then print the letter each time...
  11. Replies
    17
    Views
    3,118

    Thanks RG, and I thought I knew everything about...

    Thanks RG, and I thought I knew everything about win7. BTW if D3 is a blank then I will except it. the idea is the return the persons age based on the year in C3, if the year is missing, so be it.
    ...
  12. Replies
    17
    Views
    3,118

    I would like to attach a thumbnail pic of my...

    I would like to attach a thumbnail pic of my problem but if I do a screen print and save it as a jpeg file and attach it turns out so small it is impossible to see. RGeek, how do you create your...
  13. Replies
    17
    Views
    3,118

    Thanks for your help so far. I have been playing...

    Thanks for your help so far. I have been playing around with your suggestion but still have issues.

    Here is an example of the type of string I am working with "John P. Doe 1945" in cell A1. I want...
  14. Replies
    17
    Views
    3,118

    Need formula to extract from string

    Need some help

    How can I create a formula that will extract the last 4 characters ( in this case numbers) of a string which may also contain a number of spaces before the last 4 characters.
  15. Thread: Rolling Calendar

    by alrom
    Replies
    4
    Views
    656

    Thanks to Martin & Paul for your suggestions but...

    Thanks to Martin & Paul for your suggestions but I was hopping for a little more.
    After looking around this site and not seeing what I wanted, I decided this past weekend to try myself to put one...
  16. Thread: Rolling Calendar

    by alrom
    Replies
    4
    Views
    656

    Rolling Calendar

    I want to make a rolling calendar (one sheet per month) in excel for birthdays and Anniversities that will adjust to the correct day each new year automaticlly as I move forward. Any help would be...
  17. Replies
    1
    Views
    410

    Hide Unhide Columns

    I have attached a spreadsheet that I found on this site. In the left hand corner under the formula bar the numbers 1 & 2 appear, clicking on them hide or unhide columns. In addition there is a + and...
  18. Thanks a lot Retired Geek, I will use your code...

    Thanks a lot Retired Geek, I will use your code to develop the one button on/off. I continue to learn something every day. Cheers
  19. Thanks for your help. While I was waiting for a...

    Thanks for your help. While I was waiting for a reply I did a two button work around and have attached the sheet. I will review your macro and see if I can adapt it to my needs.

    Again Thanks for...
  20. Need a Macro to turn "off and on" conditional formating

    I wonder if this is possible.

    I use an Icon set (taffic Lights) in two ranges on my spread sheet. Everything is set up the way I want it but I share my data with others and some may not want to...
  21. Replies
    1
    Views
    637

    Need help with macro

    I would like to create a macro that will produce a PDF file of a section of a spreadsheet (can use range name). I need help with stopping the macro to insert a file name and then proceed to save the...
  22. Thread: Printing Help

    by alrom
    Replies
    2
    Views
    511

    Thank You, Worked like a charm.

    Thank You, Worked like a charm.
  23. Thread: Printing Help

    by alrom
    Replies
    2
    Views
    511

    I have a two page report for which I created a...

    I have a two page report for which I created a print macro. I would like to stop the print job after page one so that I can turn over the page just printed (saving paper) and press a button to...
Results 1 to 23 of 23