helpful

  1. C

    Setting a cell to be blank or a minimum value

    Hi, So the title of this thread is probably not the most helpful but I could not come up with anything better - suggestions are welcome. I have a formula like this: =IF(SUM(E9+H9+K9<=8),8,SUM(E9+H9+K9)) which basically says if the sum of the values in cells E9, H9 and K9 are less than 8 then...
  2. D

    Automating "Find"

    Does anyone have a suggestion on how I could create a situation where clicking on a particular word in a cell initiates a Find for that word? I have a list of customers and it would be helpful to be able to click on a particular customer and then see all the other locations in my workbook that...
  3. kweaver

    VBA Helper's Guide by Fluff, Dante, Joe4, et al

    Where's the book, folks? You are all generous and very, very helpful. I'll buy the first copy!
  4. A

    Wee green triangles

    Can they be turned OFF in VBA ? So it saves a User figuring it out and only affects *this" workbook. Thanks for any help. I googled for this and found I'd asked the same thing here back in 2009 but got a not helpful reply. It would be helpful to know if they can't, and I can stop looking.
  5. R

    Copy/Store cell data to be use post Hyperlink?

    Hi, I've created a helpful Hyperlink+VLookUp formula that could really benefit from a small addition. But I just can't seem to figure out a solution. Here's my formula: =HYPERLINK(VLOOKUP(A1,Tab2!$A$1:$B$52,2,1),"Name") Basically, it returns a webpage stored another sheet that matches a...
  6. I

    sum ifs multiple criteria and between values

    This is only my 2nd post, but the 1st one was so helpful, I'm going back to the well. I have a formula that isn't working the way I think it should: =SUM(SUMIFS(c2:c9,b2:b9,{">=6037","<=6332",4010},a2:a9,{100,101,134,136,141,355,357})) ---- How can I fix this...
  7. K

    Automate a mundane task

    Hello all, Hoping you can provide some help to a monthly task... I have a table with a list of individuals with a last date of attendance in one column followed by the 12 months. I have provided an example below: <tbody> Name Actual Date Jan Feb Mar Apr May Jun Jul Aug Sep Oct X1...
  8. R

    VBA to link googlesheet with Excel pivot

    Hi Guys, this is my first post and I have always found this forum helpful for my excel queries, I need to know if there is any possibility to connect my excel pivot with Googlesheet?
  9. J

    Naming cells of a column with VBA?

    Hi all, I need to name all the cells of a column ("A" column) of a sheet with the cell value. I mean, if the cell says "Mister", the name would be "Mister" as well. I know to do it manually, but I think that a macro for this will be very helpful and not too hard to make, but I don´t know how...
  10. JenniferMurphy

    Why the 3-second delay between Liking and Thanking?

    Is there a rational reason why the board requires that I wait 3 seconds between clicking on Like this post and Thank you for posting this? For that matter, is there a rational reason why there are two ways to acknowledge a helpful post?
  11. B

    VBA to generate email

    Hi guys, I need a simple VBA code that will open a new email in outlook and with the TO and CC recipients predefined and the subject line prefilled. Pretty much a newbie to VBA so any help resources for beginners you find useful would be helpful too. Thanks in advance.
  12. A

    Multiple, nested, if, and, or, merge help please.

    Hello all - I would be very grateful for any help with the following: A very helpful board member, jtakw, helped put together the following...
  13. 3

    Pivot table from multiple sheets

    Hi everyone. I need some help creating a spreadsheet to calculate revenue from different businesses, and I want to keep all the data separate. But, I also want the data to interact with each other on one master sheet. There is also data that is the same across spreadsheets that it would be...
  14. 3

    Help needed, pivot table with multiple data sheets

    Hi everyone. I need some help creating a spreadsheet to calculate revenue from different businesses, and I want to keep all the data separate. But, I also want the data to interact with each other on one master sheet. There is also data that is the same across spreadsheets that it would be...
  15. K

    Freeze more than 5 Column's IN spreadsheet/Freeze Specific column in middle of the sheet

    Hi All, I know this is simple but It would be helpful for me to freeze A specific Column in the spreadsheet or Freeze more than 5 Column in spreadsheet..:rofl:
  16. R

    How to: select line to end of line above

    Hi all, Could anyone please remind me of how I can select my current line / fill to the right only to the end of the line above? I.e. I have figures in the line above the blank line I'm currently in and I'd like to copy a formula all the way across to the right. But not as far as the whole...

Some videos you may like

This Week's Hot Topics

Top