Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Hi Maud, Are you still looking at this? If...

    Hi Maud,

    Are you still looking at this? If not, no problem; will make what I have work.

    Thanks
    Meleia
  2. Hi Maud, Anything new on this? Thanks...

    Hi Maud,

    Anything new on this?

    Thanks
    Meleia
  3. Hi Maud, Have run into a couple of problems....

    Hi Maud,

    Have run into a couple of problems. When some of the % of Cost per Site totals are changed, the values of that site don't change. For example (using sheet above), if I change the value in...
  4. Maud, All I can say is WOW! Can't believe the...

    Maud,

    All I can say is WOW! Can't believe the work you put into this. Believe it will be exactly what I need. I'll be starting to load data into the sheet in the next week and will let you know if...
  5. Hi Maud, Hoping that a full-on VBA solution is...

    Hi Maud,

    Hoping that a full-on VBA solution is still on your radar! Just checking before I begin to set up a formula/range sheet.

    Thanks
    MM
  6. Hi Zeddy, Thanks for the solution above. Have...

    Hi Zeddy,
    Thanks for the solution above. Have been in the middle of another project but will be looking at this one again soon. I appreciate all of your assistance.

    Maud, I'm still interested in...
  7. Thread: Excel Films

    by Myers515
    Replies
    22
    Views
    1,890

    Don't forget Module Brando was Excelent in The...

    Don't forget Module Brando was Excelent in The ExcelFather, too!
  8. Hi Maud, The markup helper column with formula...

    Hi Maud,

    The markup helper column with formula used appears in the first uploaded version to this post. This will give you the clearest picture of how the markup is used.
    Thanks
    MM
  9. My apologies, yes, they should be filled in....

    My apologies, yes, they should be filled in. Posted the sheet before I finished all substitute data. Here is completed sheet.
    Thanks
    MM
  10. That is correct. The totals that I receive are...

    That is correct. The totals that I receive are always based on the Column A business, and no they wouldn't always be sorted.
    Thanks, MM
  11. Thanks for the extra work on this Maud. And of...

    Thanks for the extra work on this Maud. And of course, that's never the end of it. I didn't initially think about a VBA solution so really pared down the data.
    The attached file shows the expanded...
  12. Thanks Maud, will try this on the expanded file....

    Thanks Maud, will try this on the expanded file.
    Appreciate all of your help, always.
    MM
  13. Thanks so much Zeddy and Maud. Since I am...

    Thanks so much Zeddy and Maud. Since I am unfamiliar with VBA, I'll be using Zeddy's solution as I need to expand this to cover several types of "costs" with several thousand sites and possibly...
  14. Thanks for the VBA solution Maud. Since I don't...

    Thanks for the VBA solution Maud.
    Since I don't know VBA, can you describe how the percent and markup is being calculated? And if I need to change the %'s, say A's will be worth 30% more instead of...
  15. Thank you most Excellent Distrubutions...

    Thank you most Excellent Distrubutions Distributor :D
  16. Hi Zeddy, This might help with the "mostly"...

    Hi Zeddy,
    This might help with the "mostly" part: what I am determining is business interruption valuation. Each of the sites has a specific number of subscriber "units". For the cost (actually...
  17. Knew I wasn't going to explain this very clearly....

    Knew I wasn't going to explain this very clearly. See attached file v2. Since I have only a total Cost that I need to divide across all the Sites, I am using a % of the number of Units. However, the...
  18. Formula to increase % of units based on site type

    Hi All,
    I need a formula to increase the % of Units per Site depending on the Site Type. The % of Units per Site is based on the number of units per site.
    An example, if Site Type = A then the % of...
  19. Actually I think I just found the answer -- I've...

    Actually I think I just found the answer -- I've hit the Access 2Gb size limit. (I have some photos that are stored within the database :-( rather than being linked)
    But as you suggested I will go...
  20. Cannot open database ". It may not be a database that your application recognizes

    I have used an Access 2010 database for several years and recently started receiving this error: "Cannot open database ". It may not be a database that your application recognizes, or the file may...
  21. Thanks for responding. And I apologize for...

    Thanks for responding. And I apologize for sounding so vague. I was looking for ideas that existed instead of anyone doing new work.
    It would have been a very large project but it was just...
  22. Need ideas for tracking inventory lead times and capital forecasting

    I have been tasked with tracking inventory orders and receipt including various lead times and trending for different products and different vendors. Along with this will be capital committed,...
  23. Thanks for answering so quickly. I will need to...

    Thanks for answering so quickly. I will need to convert to text so this works. Now that I read your response I may have asked this before a long, long time ago but just couldn't remember how to do...
  24. Change variable length of numbers to three character text

    Good Afternoon,

    I have a list of numbers
    1
    05
    01
    26
    427

    and I need to change them all to text like
  25. Company policy -- no Access databases on the...

    Company policy -- no Access databases on the Sharepoint sites. There is very little VBA in the database anyway. Think I'll create a few simple queries that I know will retrieve some of the most...
Results 1 to 25 of 81
Page 1 of 4 1 2 3 4