Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. Re: can i set up excel default to print all pages of workbook, fit to page??

    Hi daisygirl1977 - Welcome to the forum. It sounds like what you are trying to do is possible. We may need a little more information to be helpful. I can imagine a macro that is run saved in your...
  2. Re: $ difference column in year over year pivot table

    Hi there girlgirlgirl - Welcome to the forum! :) I am not seeing any table below. It may help things get started if you typed in a few rows as an example. Hope this helps to get an answer started.
  3. Replies
    1
    Views
    83

    Re: VBA for Multiply Print Areas

    Hi karolina1406. Have you thought about just selecting

    <colgroup><col style="width:65pt" width="65"> </colgroup><tbody>
    D5:AF131 as your Print Area? You could then set the print to be 3...
  4. Replies
    1
    Views
    109

    Re: Hide rows and count visible cells only

    Hello pwill - If your data is in a table, you may be able to use something like the function SUBTOTAL(). Check out this link -> https://exceljet.net/formula/count-visible-rows-in-a-filtered-list ...
  5. Re: VBA: Cbeck cell if empty, dependent on other cells

    Hi JennV - Welcome to the forum. Maybe this will help get things started. Please explain what happens when you run your code. That may help us help you. Hope this helps.
  6. Re: VBA: fill cell with colors in another workbook

    Hi JennV - Welcome to the forum. I tried to use conditional formatting across two different workbooks and received the message: "You may not use references to other workbooks for Conditional...
  7. Replies
    2
    Views
    121

    Re: VBA Help Required

    Hi Camilla1980. I hope this response helps get things started. Is there any reason you don't have all this data in one spreadsheet with a tab each for a1, b2, c3, d4, e5 and f6 and then with a...
  8. Replies
    5
    Views
    1,963

    Re: What it takes and how to be Excel MVP

    Scary though! Yikes....
  9. Replies
    3
    Views
    232

    Re: index across multiple tables

    Hi Monica at Plastics - You might consider a formula like ->
    =if(A1>0,A1,"")

    If you place this formula in Cell B1, it will look in Cell A1 and place the value in B1 only if A1 > 0.
  10. Re: Help with a formula needed please - sumifs formula not working - maybe another function needed?

    Hi SandyG - Hope this helps. A very simple example of SUMIFS has the formula =SUMIFS(A1:A3,B1:B3,"red") in Cell C1, with Cell A1 = 40, Cell A2 = 50, Cell A3 = 60, Cell B1 = red, Cell B2 = blue and...
  11. Replies
    3
    Views
    232

    Re: index across multiple tables

    Hello Monica at Plastics and welcome to the forum! I think what you are asking is possible, if I understand it correctly. We probably need a little bit more information before we can make...
  12. Thread: Is it possible?

    by goesr
    Replies
    2
    Views
    232

    Re: Is it possible?

    Hi KyleOliver If I understand what you are asking, I would answer your question in the affirmative. It should not be difficult to create a Summary tab that adds up the table cloth orders across all...
  13. Re: Creating cell references between multiple worksheets

    Hi Carolineh12 - Welcome to the forum. If you duplicate a worksheet the format will be duplicated on the new sheet created. I'm not sure what you mean about the number scheme and cell references. ...
  14. Replies
    2
    Views
    328

    Re: Dealing with duplicates in my data

    Hi shophoney - You might consider creating a VBA script that eliminates the duplicates in Table1. I can't see any reason you would want an employee listed twice in a list of employees.
  15. Thread: Cubevalues

    by goesr
    Replies
    1
    Views
    208

    Re: Cubevalues

    Hi shophoney - Have you tried:


    Application.ScreenUpdating = False
  16. Replies
    1
    Views
    106

    Re: Hide/Unhide Button help

    Hi tjktm - Have you considered using the Group feature from the Data tab? This may allow you easily hide/unhide rows as well as adding and subtracting rows within groups. Just a thought.
  17. Re: VBA Macro - use variable in code [INDEX(UPPER()]

    Hi there aLUPIN - you might consider the code below:


    Sub UCASE_aLUPIN()
    Application.ScreenUpdating = False

    Dim rng As Range
    Dim cell As Range

    Set rng = Range("A1:K20")
  18. Replies
    1
    Views
    1,507

    personal.xlsb not automatically opening

    I recently upgraded to Windows 10 and the installation overwrote my old personal.xlsb file erasing all the macros I had stored there. Additionally, when I start Excel now the personal.xlsb file does...
  19. Re: How to set default text box properties (object positioning)

    Hi JenniferMurphy - This macro will affect ALL SHAPES on the Active Sheet. I can be invoked the same way any macro is run and could be assigned to a keyboard shortcut or even made to run...
  20. Re: How to set default text box properties (object positioning)

    Hi JenniferMurphy - Although this isn't exactly what you asked, you might think of trying something like the simple code below which selects all objects and makes them FreeFloating. Hope this...
  21. Re: Formatting problems, search problems, the works.

    Hi Cornelius Morris - Good job figuring it out. I have often found that merged cells on a spreadsheet are "Evil" and should be avoided if possible. I was going to suggest unmerging all cells, but...
  22. Re: VBA date doesn't match with date in workbook

    Hello Strooprover - This LINK may help. Dates can be way confusing. :(
  23. Thread: meal allowance

    by goesr
    Replies
    5
    Views
    334

    Re: meal allowance

    The driver would then have to fill in an x in columns C, D, E, and F as appropriate. If they are away - put an x in column c, if driving at breakfast, put an x in column d and so forth.
  24. Thread: meal allowance

    by goesr
    Replies
    5
    Views
    334

    Re: meal allowance

    The equation in I3 is: =IF(AND($C3="x",E3<>"x"),40,"")
    The equation in J3 is: =IF(AND($C3="x",F3<>"x"),50,"")

    Let me know if you do not understand what I'm trying to do here.
  25. Thread: meal allowance

    by goesr
    Replies
    5
    Views
    334

    Re: meal allowance

    Hello Manolocs - I hope this will help you get started.

    The equation I used in H3 is: =IF(AND($C3="x",D3<>"x"),20,"")
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4