1. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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...

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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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...