excel 2007

  1. V

    VBA Excel 2007 Security warning when closing workbook with Task Manager

    In Excel 2007 I Create file and macro (vba), I protected workbook using password and to avoid Security warning when closing file through icon red (X) and reopen file and after save my data and indeed, the problem is solved Steps 1- to avoid Security warning (code problem solved is down )2-...
  2. D

    Extract multiple data from cells in a range based on cell color

    i want to take the data in the range C12:K20 and extract only the green colored cells into a list under A1. https://www.dropbox.com/s/51phis2d5cb36ko/Screenshot%202018-12-19%2001.56.35.png?dl=0
  3. E

    VBA to delete chart image in Word

    Hi community. Hope you can help a VBA novice. I've found some VBA code which enables charts in excel to be pasted in to a Word doc. See code below. I want to enhance this further so could you advise on how I do the following: delete the charts in the word doc (40+ each with its own bookmark...
  4. E

    Which is the correct syntax to use in this example formula?

    Hi I am still learning Excel and I am very grateful to the good folk on here who generously give their time to answer all of our questions - Thank you. I am writing a simple If formula that looks at cell B1 and if B1 contain the number 1 the formula does one thing but if it contains a different...
  5. E

    Split Range

    Hi all, Searched a number of forums/website but can't find a solution to my issue. I have the following range examples. I have split the string field below to create start and end fields. Match to identify if numbers match and the difference between the two numbers. <colgroup><col><col...
  6. E

    Formula to check A1 format (General or Date) then return B1 OR C1 depending on A1's formatting?

    Can the following be done with a excel formula as I am unable to get it right? I am using Excel 2007 on Windows. If cell A1 is formatted as 'General' then return the contents of cell B1 but if A1 is formatted as a 'Date' then return the contents of cell C1. I can find a lot of information...
  7. E

    Conditional formatting

    I have a scoring matrix for a number of services. Each service has its own RAG status. Example below. <tbody> Minutes <30 30-59 60-89 90-119 120-149 150-179 1 2 3 4 5 6 Serv1 3 3 6 9 12 15 18 Serv2 3 3 6 9 12 15 18 Serv3 2 2 4 6 8 10 12 Serv4 1 1 2 3 4 5 6 </tbody> I...
  8. E

    How can split an outage time duration into different segments / ranges

    I am monitoring service outages using excel 2007. I have a start and and end time as shown in the example below. Start and end time are in dd/mm/yyyy hh:mm:ss format. <tbody> Start End Days Hours 03/01/2018 18:30:00 04/01/2018 02:42:00 0.342 8.20 </tbody> Days is worked out using the...
  9. Johnny Thunder

    VBA Help - Looping thru a list of values and copy/Paste into another workbook and create a .txt file with the new criteria

    Hello All, I am working on a project and needed some help with code. What I am trying to achieve; Step 1 "Sheet 1" - Contains my list of unique values in Column A - Range A2:A50 - there are 3 blank rows before the next new unique value is found, for example: 1st value is in cell A2...
  10. G

    Excel 2007 formula required

    i have a table like this BANKNIFTY BANKNIFTY BANKNIFTY BANKNIFTY BANKNIFTY BANKNIFTY NIFTY NIFTY NIFTY i want to find address of the cell on which a text occurs first time and last time in a column.eg in above address of first row and sixth row in case of banknifty, and 7th row and 9th...
  11. J

    Excel 2007 Automatically Turning on Design Mode When Saving and Exiting

    Ok, I have a weekly revenue report that several managers must complete each week. It uses command buttons to guide them through it with userforms. Long story short, 2 managers are using Excel 2007 and it keeps turning on design mode when they save it and exit. Some things I've done: Saved...
  12. V

    printing problems in excel 2007

    There are two problems suddenly I encounter windows 7. Microsoft office 2007 2007. 1. in the excel entries are in yellow color. Is it normal and is it default color 2. I am not able to print excel. It comes out blank. I have designated print area in "page layout". This is a recent problem...
  13. P

    Replace part of a text string with the value of another cell

    Hi all, I've searched the web for an answer so I'm hoping this can be done. Basically I am creating a BOM (Bill Of Materials). I am ordering cable in pre manufactured lengths. The cables basically has the same part number A0090CEGAC0BUXXXM the XXX represents the cable length. I also have to...
  14. A

    Method to highlight names with consecutive attendance

    I am using Excel 2007 and asking your help for the best (and the easiest) way to highlight the names of people who have 6-month of consecutive attendance every Sundays. My worksheet's layout are as follow: Column A: Last Name Column B: First Name Row 9: Dates (with "S9" as Jan...
  15. A

    VBA for hiding columns based on inputted date

    I am using Excel 2007 to make an attendance sheet with cell "S9" starting as January 01, 2017 through "NS9" as December 31, 2017. I am hoping that if the user of the form inputs a date (1/03/2017 as an example) in a specified cell (say B3) then the columns with other dates would "temporarily"...
  16. C

    ActiveX ComboBox - Blank rows and duplicate values

    HI I have added 2 combo boxes to a spreadsheet. The 1st is used to select a BU and the second is a dependant drop down for selecting a sub BU based on the BU chosen in combo box 1. I have used this sort of set up before and it has worked fine. However, ComboBox2 doesn't seem to display the...
  17. C

    How to SUM a column with multiple entries in a single cell

    Good Morning, I am new to this forum and a little bit new to Excel 2007. I am struggling to come up with a formula to SUM a column with multiple entries in a single cell where other cells have single entries. The values i require are costing therefore £ values in each column require to be...
  18. G

    Formating a sheet for hour input, with different text color depending on height of input

    Hi there, First of sorry for my poor English. Am no native speaking and writing person. Thx in advance for any assistance. I am forced to make this in Excel 2007, so it has to work in that. I have to adjust a sheet that is used to store the expected hours on a project. People fill in their...
  19. D

    Copy/paste data only for relevant sheets VBA

    Hi All Using Excel 07 I'm setting up a macro enable workbook which produces results (up to 13) based on a number of criteria. The macro currently unhides the result number of sheets that already exist, so if there's 4 results, "All Results", "Result 1", "Result 2", "Result 3" and "Result 4"...
  20. R

    Unusual sorting

    EXCEL 2007. Time, date, load fields. I have entered data for every hour, 24 rows per day. I can sort on date field, nice line up, all 24 rows for 1st date, 24 rows for 2nd day, etc... Now when I sort on time, in order to see 1st hour's data for each date, I get screwy data. Just using sort...

Some videos you may like

This Week's Hot Topics

Top