Search:

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

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    4
    Views
    151

    Yes, posting a sample worksheet would have made...

    Yes, posting a sample worksheet would have made it much easier to understand my issue. Will keep that in mind next time...thanks again!
  2. Replies
    4
    Views
    151

    Thanks for the reply, Rory. Unfortunately, the...

    Thanks for the reply, Rory. Unfortunately, the label is one continuous text string "Plot 102 D1 area 1" but I think I am just going to use the MID function to pull out the district and use that to...
  3. Replies
    4
    Views
    151

    Custom Sort in Pivot Table

    I have a data source that has an ID number Plot and a District Number (D1..D8..D14)
    Plot 102 D1 area 1
    Plot 102 D1 area 2
    Plot 173 D1 area 1
    Plot 173 D1 area 2
    Plot 175 D1 area 1
    Plot 175 D1...
  4. Replies
    0
    Views
    105

    Margins Change in Publisher 2007

    I have publisher document that's prints merged badges. The data source for the merge is Word. After completing the merge when I look at print preview the margins are correct. When I merge into a...
  5. You are so awesome...this is just what I needed....

    You are so awesome...this is just what I needed.

    Thanks so much:thewave:
  6. Thanks for the quick reply. It works great until...

    Thanks for the quick reply. It works great until I Autofill the other cells. I have attached the revised workbook.
    Thanks!
  7. Populate Cells with Row/Column Intersection

    Hello All,
    Sorry if the title is a bit confusing. My Class Cost worksheet has cells to enter the range and step, the pricing is based on the combination of the Range and Step. The Pricing...
  8. Replies
    17
    Views
    522

    That is so much easier and more accurate...thanks...

    That is so much easier and more accurate...thanks so much!
  9. Replies
    17
    Views
    522

    Thanks so much for the ISTEXT tip, it worked...

    Thanks so much for the ISTEXT tip, it worked great. The Pivot Table still would not group on hours for me so I used the VLOOKUP to assign hour values then used those in the pivot table. I have...
  10. Replies
    17
    Views
    522

    Thanks to all the replies. When I try the Group...

    Thanks to all the replies. When I try the Group option on the Pivot table I get an error that states I can't group. I am attaching a more thorough example of what they are working with. Thanks!
  11. Replies
    17
    Views
    522

    It is based on 24 hour day...see sample data...

    It is based on 24 hour day...see sample data below:
    05-01-2015 12:53
    05-01-2015 13:07
    05-01-2015 13:26
  12. Replies
    17
    Views
    522

    Thanks for the quick replies, they want to know...

    Thanks for the quick replies, they want to know the total transactions per hour per day.
  13. Replies
    17
    Views
    522

    Sorry the sample didn't paste the first time,...

    Sorry the sample didn't paste the first time, here it is
    Date Time (Local)
    05-01-2015 07:04
    05-01-2015 07:10
    05-01-2015 08:21
    05-01-2015 08:37
    05-01-2015 08:47
    05-01-2015 08:52
  14. Replies
    17
    Views
    522

    Count Time Entries

    Hello,
    I have a user that enters in a date in Column A and a time in Column B. They want to be able to count transactions per hour, per day. The worksheet looks like the sample below:


    Date...
  15. Replies
    7
    Views
    869

    That is Wonderful!...Thanks so much!!:D

    That is Wonderful!...Thanks so much!!:D
  16. Replies
    7
    Views
    869

    Yes, I did that and it works I just thought there...

    Yes, I did that and it works I just thought there might be another way. I could create a macro for the Find and Replace piece but just wondered if there was an easier way. Thanks so much for your...
  17. Replies
    7
    Views
    869

    Excel Formatting

    Hello All,
    I have an Excel worksheet that has a column of data with various data entries for phone numbers. Some of the users have entered in the data as (123) 456-7890 while other have entered...
  18. Thanks Steve, I think that's the solution I will...

    Thanks Steve, I think that's the solution I will go with!
  19. That works great for the Axes but not the data...

    That works great for the Axes but not the data table. Is there a way to format the number format to % in the data table?
  20. Yes, they are linked to the source. So, would...

    Yes, they are linked to the source. So, would the only resolution be to break the link? I would like to keep the link between the 2 workbooks if possible...
  21. The entire worksheet was copied to another...

    The entire worksheet was copied to another workbook. Thanks for the response!
  22. When Copying Worksheet to another Workbook Percentages convert to Decimals

    Hello All,
    I have a worksheet that contains charts I copied to a different workbook. When the source workbook is open the Percentage formatting on the charts display properly, when I close the...
  23. Replies
    11
    Views
    1,043

    Works Great...Thanks so much!

    Works Great...Thanks so much!
  24. Replies
    11
    Views
    1,043

    I receive a syntax error on the following line of...

    I receive a syntax error on the following line of code
    zAddToName = Format(Month([D4],"##") & Format(Day([D4],"##") & Format(Year([D4],"##")

    The date in D4 is formatted as mm-dd-yy, if that...
  25. Replies
    11
    Views
    1,043

    This works great, thanks so much. How would I...

    This works great, thanks so much. How would I change the code if I wanted to copy the TestData worksheet with the same naming convention of NewData_090214 (NewData plus the contents of D4 which will...
Results 1 to 25 of 112
Page 1 of 5 1 2 3 4