section

Hello everyone, I have a table(Below) and would like to assign a conditional formatting to the items under the allocation section, provided that the Investment section items should also have the same color or different doesn't really matter. I did the allocation section by clicking in...

(sorry to start a 3rd post in 2 days...I'm dabbling in foreign excel territory and Google isn't helping). I have a worksheet that spreads over 2 pages. I have command buttons that insert rows as needed in various places. The worksheet is basically spread into 5 sections/categories of items and...

Okay so I read on MakeUseOf - How to Integrate Excel Data Into a Word Document and I need some help. In the last section it talks about being able to update all the labels without needing a button in the Word document. I was wondering how to do that.

good afternoon, i am looking for a way to bring several text cells(excel) or records(access) merged together into a single cell/record. i have 4 columns and the first 3 are grouping/hyarchy with the last column being the text that i need. have a look at this example...

I went to the Test section to see if I could figure out how to post an image. I found that the Insert Image button is not available in that section. Is there some reason for that?

Evening, Last post before bed. Below is a section of code from my userform,i think the section i have supplied will be ok for what is required as opposed to showing it all. My userform has 15 textboxes. All 15 must be filled & not left empty when i click on save,currently if any are left empty...

I have a two part check list. Section and Area. I am using the formula =SUM(IF(FREQUENCY(MATCH(Table1[Section],Table1[Section],0),MATCH(Table1[Section],Table1[Section],0))>0,1)) to tell me how many different Sections there are. and =COUNTIFS(Table1[Area],"*") to tell me how many Areas there...

Hi all, I have created condition based drop-down lists (Equipment tree for production line) so that if you choose line X, you can only choose from section Y, an so on. Now I want to create a matrix that also is condition based. So if I choose Line X and Section Y, certain cells should get...

Hi All Just a newbie searching for help. I have a table that is populated via a userform and would like to enter a date on a different sheet and it would return 3 columns of values associated with that date. The date would appear numerous times in the table. As per below. I would like to extract...

Greetings, I'm currently in the process of finalizing the approach to a dashboard I'm constructing in Excel. I've run into an issue however. I'm trying to have a set of object groups which include a number of header objects. The problem I'm facing is I can't find a way to streamline the...

Hi, I have a spreadsheet which has a number of formulas. The spreadsheet lists names and payments and I often have to add a high number of new rows but as the sheet is alphabetical not in one place. I have a macro which inserts and new row and copies down the formulas I need but leaves the name...

Hi all, Hope your Friday is going well. I am currently working on a dashboard for KPI's and i have been making some pie charts. I have displayed the pie charts percentage on each section of the pie and I was wondering if there is a way to hide the zero percentages. Thank you in advance, Mark :)

Hi, I have excel files. There are different sections in this file. There are different features under each section. Unequal weights are available for these features. The sum of each section is 10. However, if there are no features under a section, the weight of the non-features needs to be...

I have this table layout Section Score Rank A 34 2 B 45 1 C 23 1 A 46 1 Now I am looking for a vba code to rank and show the out as I have under the rank column based on the section. I can do this with a formula but I...

Hello, Can anyone help me tweak the code below? I am using this code to insert a row beneath the header once it finds "Audit_Name". The code works and it does insert the blank row. However, since the header is shaded blue, I need the new row to be in grey (RGB 217,217,217) OR White...

Hey guys, I need a formula that will find a value based on a columns criteria. EX: I am trying to find the opposite of INDEX(x,MATCH(, as it is used for finding values based on a rows criteria. Sheet 1 <tbody> Column A Column B...

hello all, I'm New to Mr.Excel (Access too) I get this message - The expression you entered has a function name that Microsoft Access can't find." I copied the VB from a Mr.Excel video about "Auto BackUp" - I'm using 2007-2010 *I need help to resolve this error [code] Sub BackUp() Dim dTime...

I have two sheets in my workbook---I'm looking to scan the data in Sheet 1 and place it into specific sections (set end destination in Sheet 2). I'm looking to take all of the rows in Sheet 1 that fall under a certain criteria and paste them into their respective section in sheet 2. "If the...

Hi all, I've read the sticky post about signatures, buuuut the Signature bit doesn't seem to be in the Settings section anymore. Can anyone suggest how to add one, please? Thanks! Alice

Hi all, Need help with the above concern. Here is an example data source: <colgroup><col></colgroup><tbody> PS1001 TX1001 TX1001 PS1001 SECTION BE 4 12 S PS1001 TX1001 TX1001 PS1001 SECTION BE 4 12 S PS1001 TX1001 TX1001 BS1001 SECTION BE 4 12 S PS1001 TX1001 TX1001 PS1001 SECTION BE 4...