corporate

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

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

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

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

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

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

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

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

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)

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