b10

  1. A

    skip the blank cells

    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.
  2. G

    VBA to convert tabs to PDF if selected from cells

    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
  3. P

    Unique List Issue

    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...
  4. S

    VBA to count number of days between 2 dates

    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...
  5. E

    Extracting Data from list

    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
  6. C

    Speed up code

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

    VBA to pull text out of cell

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

    Referencing same cell when sorting linked spreadsheet

    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...
  9. S

    Calculation to have cell turn red or yellow

    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...
  10. K

    Formula Help

    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...
  11. S

    Excel Macro/VBA, VLOOKUP setting

    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...
  12. C

    Help with Dates in Formula

    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...
  13. S

    Clear Calendar contents with new drop down selection from list

    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...
  14. J

    Look up data across multiple pages

    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...
  15. N

    Formula to predict a10,b10 & c10

    <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
  16. P

    Rearranging data with VBA

    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...
  17. S

    Countifs criteria

    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...
  18. D

    Create error messages based on entries in 2 cells

    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...
  19. M

    Get cell reference

    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...
  20. G

    How to reference a sheet by number not name in formula?

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

Some videos you may like

This Week's Hot Topics

Top