work

When I run spreadsheets I create tables and charts in them. I format them as desired, then cut/paste them into a Word document. But I have found that the Word document and Excel file are "linked," which I don't want. The last time I copied the Word doc onto a usb driver to work at from home...

I'm trying to use a =Sumproduct and getting a #VALUE error in Google Sheets. Here is the formula that I'm using. =sumproduct(--($B$102:$B$255=A14),(right($C$102:$C$255,2))="AT",A$102:$D$255) When I use that formula in my main table (positioned at E14), I get the error. When I place the...

Is there a formula I can use to search cells in a column for say 3 specific words whether they be on their own or in a text string. I'd like to search for up to 10 words but perhaps this is not possible?! I have used isnumber(find, but can not get it to work with the or function, I have used...

Hi All, I am running a football tournament and want to automate the data as much as possible. I have created a spread sheet to show the table, but I am struggling to get the Win/Lose/draw to work correctly. I am using the following formula in K3, where J3 is the home score and J4 is the away...

This may seem like a simple question but the answer has evaded me so far. I have created an Excel 2007 sheet which has a dozen hyperlinks to different websites, they all work perfectly except one and thats ( www.screwfix.com ) , whenever I click on this I get ( Unable to open...

Hello, im trying to create a check for a bunch of time blocks for staff ID Staff Start End Total Time 1111 8:30 9:30 0:30 "Under 1 hour" 1111 10:00 10:30 0:30 "OK" 1111 10:30 11:00 0:30 "OK" 1111 12:00...

I have a list of work order comments in range H2:H1150. In each cell is a comment like this: "1/8/10 Employee at work-----refer to doctor----$750 cap per listing." I am trying to extract just the dollar amounts from these cells so I can total them in column I but am having a hard time. I...

=IFERROR(INDEX(INDIRECT("'"&$B$1&"'!"&"$E$2:$S$51"),MATCH($A5,INDIRECT("'"&$B$1&"'!"&"$A$2:$A$51"),0),MATCH($B$2,INDIRECT("'"&$B$1&"'!"&"$E$1:$S$1"),0)),"") I'm using the formula above that uses Indirect and the value in cell B1 to determine which worksheet to pull data from. It then uses cells...

Hi all I'm about to have a genuine emotional breakdown over a spreadsheet I've created for work and I'm really hoping someone can help me work out wth is going on and how to fix issues I'm having please. In short, I work at a training company and have created a spreadsheet with multiple...

Hello Everyone, wondering if someone might be able to help me out with a formula I am having trouble with. I have researched the formula extensively on-line and can't seem to get it to work. Basically, I am trying to use a sumifs formula with multiple criteria that sums across multiple...

Morning all, I have a very large excel sheet, over 25000 lines, the dates are brought in with a formula, (they need to remain a formula and is constantly updated) which i need to pivot and group, however i believe, because they are a formula excel will not group them when pivoted. Can someone...

Hi, This my first post, apologies if I break any rules in the forum. I am trying to use VBA to write a simple code to auto fit column width. I have data in columns A:Z and I have also merged cells D5:J5. Naturally, I think a simple line like the following will do the job...

Hi All, I am attempting to create an archiving system for work and having some trouble finding a way to do a certain thing because I'm not sure how to word it for the searches... So, we have an archiving system, which is a 9 x 9 box for samples (81 samples); on the worksheet so far i have a...

hi, Is there any good add-on for scraping html? VBA is too hard to work with.

So I have this (the below) excel formula that does work, =IF('Q1 - Individual Performance'!N9<=60%, "0", IF('Q1 - Individual Performance'!N9<=80.99%, "1", IF('Q1 - Individual Performance'!N9>=81%, "2"))) However the sheet it is reading from has lots of #DIV/0! on there. So I have added in an...

How do I calculate the remaining number of work days left? Based on today's date and an end date?

I need a macro file with the macro button where it should work as below. - When I click on the macro button, pop up should open to select the report from my local drive(the report will be in .xls or .xlsx or .csv format) - Once I selected the report it should ask for the column name to input. -...

Fellas, I have spreadsheet as follows: Column A - location for 8 different maintenance workshop Column B - description ID for work completed (ID#1.5.6) / example tire change = 1.5.6, rim change is = 1.5.7... etc Column C - labor hours for each ID that work has been completed (up to 25000 line...

I'm using Outlook locally with 2 accounts. I want to send emails programatically using the "non-default" account. I checked out "SendUsingAccount", but wasn't able to make that work. Anyone know the syntax? Here's my code: On Error Resume Next With OutMail '.From =...

Hi, I want to set one of my sheet to be non visible. I have set its properities to xlsheetveryhidden, but project protection by password does not work. It will be enough when I add any (even blank) sub inside?