b10

Hello Excel experts, I use a formula in Sheet2 from B10 to B100 cells. =IF(DATEDIF(Sheet1!C10,Sheet1!$F$9,"Y")>=59,Sheet1!B10,"") i want to skip the blank cells in Sheet. Sheet2 protected only B10 to B100 cells are not protected. Thanks in advance.

Need to macro to convert selected tabs to PDF Say in A1 to A10 is the tab name and the in B1 to B10 is true or false If it is true in B1 to b10 then it will convert them to PDF

Afternoon, I am using the following formula to create a unique list, typically I wont have a fixed reference point at the point B10 is reference and the formula works fine in these instances. However in this case B10 will be come B11 and so forth, the issue I'm having is the formula is creating...

Hello, I use this code to have the date and time populate in column c, starting in C13. I would like it to also count the number of days between this date, and a date in cell B10, in cell D13. B10 would stay the same, Column C would be different dates. Not sure if this code could be...

Hi all, I am trying to extract data from a list using formula but cannot seem to get it right B10 has a name cell with formula B13:B103 I am looking to extract data from M13:M103 when the list matches B10 in Q13:Q103 Then drag down to extract every entry etc Any help much appreciated

Is there anyway to speed up how Im doing this? I have more code like this but only posted a portion of it. Takes about 5 seconds to run the macro, would really like to lower that time. ActiveCell.Offset(rowOffset:=0, columnOffset:=1).Activate ActiveCell.Value = B1...

Hi - Is there a way to say look in A10 and if the word "March" appears, put "March" in B10? Thanks!

I thought this was straightforward but it does not seem to be. I have a two spreadsheets and in one (call it S1) I get a calculated value in column C. In the other (call it S2), I want to link to the values in column C. If, in S2 B10, there is a reference =S1!C10, and I sort S1, how do I...

In cells A10 and C10, I have two different calculations with a number total for each cell. In B10, I'd like to have a calculation that looks at A10 and C10 . . . if those two numbers are the same or within 1 of each other, B10 is bright yellow. If A10 and C10 are different by more than 1, B10...

Hi All - I'm looking for help with the following scenario: Let's A1 has a numerical value, if B1 is blank, then C1 should be 3% of A1. And, if B1 is not blank (some numerical value), then D1 should be 25% of A1. If B1 is blank, then C1=A1*3% Conversely, if B1>0, then D1=B1*25% Can anyone...

Hi All, Can someone help me please. Below is what i'm trying to do. 'When user inputs value into B10 on the "Calc" sheet, the system will find the same value (or similar value If it doesn't exist) from Column B on the "Data" sheet. Then the data of Column C will be displayed into B11 on the...

Help please. I need a formula that will add 15% to a date. If the resulting date is a Saturday, the date needs to be moved back to Friday. If the resulting date is a Sunday, the date needs to move up to Monday. Here's what I'm using now: - B5 is a start date - B6 is an end date - B7 calculates...

Hey all, Hoping I can get some help here. I created a generic calendar with year (c3) and month input (c4). In each row and column there is another drop down for manger (starting with b10) and to the right (in c10) is a list dependent on b10. This goes all the way through the calendar...

Hi, Its been awhile since I've really used excel and I am trying to put together a worksheet that will look across multiple worksheets and pull data. On the master worksheet in cell A1, i have a data validation where i can select a date. then in cell A2 I have a data validation to select a...

<colgroup><col><col><col></colgroup><tbody> A 1 5 B 0 C 6 2 5 1 4 3 0 3 3 4 2 2 3 5 7 6 9 6 4 2 9 7 9 8 1 8 5 2 3 9 5 7 7 </tbody> 10

This one seems simple but gets hairy as it goes on: I have 2 columns of 182 rows of data (A + B) I need to copy 2 rows of existing data (b10 & b11) ahead of each B cell containing current data. I need to insert 2 blank rows below each A cell with current data. This is what I have (Ignore...

Having trouble finding the solution to this if there is a simple one. My formula looks like this: =COUNTIFS(Model,$A10,Package,$B10,Status,"*DS*") But it is not returning anything. I'm assuming this is because B10 contains varying numbers with 0's in front like "01" or "02" but the Package...

I have a sheet which calculates charges due on an account. I have a box at B10 which can be completed to offer a discount. I have a dropdown which references to box D5 where a user can select a 'Loyalty Discount' (shows "1" for no discount, then either "2"or "3" for the level of discount...

Hi, There is probably an easy way to do this but I can't seem to figure this one out. How do I construct a formula to reference a cell, like "B10" so that the value returned in "B10". I want to the formula to change when the cell moves, for example if I add a column and "B10" moves to "C10...

I have a situation where I want to reference a worksheet by sheet number and not by sheet name because the sheet name changes based on a user input (sheet name will never be standard). Typically I could use the following formula to get the value in cell B10 on sheet called B10: ='BobSmith'!B10...