corporate

  1. R

    Macro to change VLookup Range

    Hi Guys, I want to update Vlookup range in the report with respect to sheet name in cell A27. <tbody> <tbody> Business Solution </tbody> Connect Status <tbody> Business Retail </tbody> =VLOOKUP($B$11,Oct!C:J,4,0) <tbody> Business Digital </tbody> =VLOOKUP($B$11,Oct!C:J,6,0)...
  2. R

    Create a tree structure in Excel - Possible VBA input

    Hello all, *Second time posting as the last thread did not display correctly* This may be a long shot but I am throwing this out there to see if anyone can help. I would like to recreate a form of a three-structure in Excel. Below is an sample set of folder structure data. Commercial...
  3. K

    VBA Copy a table and Paste it upside down

    How can I write a VBA that will copy Table A and paste it as Table B (see below). Please allow for Range Selection. Thanks for your suggestions. Table A: <colgroup><col width="161" style="width: 121pt; mso-width-source: userset; mso-width-alt: 5888;"> <col width="107" style="width: 80pt...
  4. R

    Changing of selected font color to red inside a cell

    Hi Everyone, Could you please help me changing of selected font color inside a cell. Selection of words/ characters is depends on the user wants to color. Ex, "John Peter" i wanted to color only "er" which is at the end "Dave Smith is a corporate trainer" color only "a corporate" Kind Regards, RN
  5. H

    Help Please -Sum off multiple adjacent cells

    Hi, I require some help please. I am looking for an equation to that will sum based on multiple adjacent cells have specific terms. I need to total the revenue in row D for all lines that have a specific working in Row A B and C See example below: I need a formula to automatically calculate...
  6. D

    Countifs Help

    So in Column Z I have a credit rating for a bunch of securities (AAA,AA,A,BBB,BB,B etc) and in column AA I have sectors that the securities are in (Corporates, Government Related, Others). What I want to do is count up the number of say AAA securities that are in the Corporate sector. Any help...
  7. R

    Formula Help Please

    Good morning. I'm a new user to this forum but have been using it for a while now to learn and expand my skill set on different formulas. With that being said, I'm stumped on this one. Here's what I'm trying to do with the data below. If the Column D equals "Monitoring" then I want to count...
  8. D

    VLOOKUP, MATCH, Not sure which

    i All, Have come to a wall I'd love to de-brick...Not sure which function or how to solve this problem. I've a single sheet that contains the following... <colgroup><col style="mso-width-source:userset;mso-width-alt:3776;width:106pt" width="142"> <col...
  9. M

    Federal Form 1120-W Estimated Tax Spreadsheet Template

    Does anyone have a Federal Form 1120-W Estimated Tax Spreadsheet Template for Excel? (Not a pdf version of the form - but an Excel spreadsheet to be used to calculate C-corporation federal tax estimated payments)
  10. M

    Register: ModelOff APAC Meetups 2015 (AUS, IND, HK, SG)

    This May and June, the ModelOff Team is traveling around APAC to hold local networking events - and you are invited to join the celebrations! Six FREE drinks networking events will be held in Melbourne (May 26), Sydney (May 27), Singapore (June 9), Bangalore (June 10), Hong Kong (June 11) and...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top