section

I have a template spreadsheet for tracking forecast and actual figures, which will be used by many people as so needs to be flexible. On a summary worksheet, there are rows summarising process data in section 1, with one summary per row. It picks up its data from section 2 in another sheet...

I have two tables where one table will populate the data into the other table based on the section and item number I have defined. As per the below image the table in yellow will be populated by the table in white. For example D2 needs to show the value from D48 as the 'Section' and 'Item'...

Hi, new to the site so apologies if this has been asked before! I have a spreadsheet of data with all my source info included in the control sheet referred to as 'master'. This information spans columns B-CA and rows 20-2000. The information relates to different sections of a construction...

I have two worksheets, the first contains a list of items, the second a data set. I am wanting to create a formula in sheet one, which looks up to the data set, finds the highest value in that row and then returns the column header (a date) from this data set. I have included what would be the...

Hello, I am looking for your help in figuring out if it is indeed a macro I need to come up with for the following problem, or if a set of formulas would suffice (which I doubt). My idea is to summarize in the top of the sheet, in a small formatted section, the 10 oldest entries (from a set of...

Hi all, I stumpled upon this amazing looking sales funnel graph. I want to add another section to it, a 5th section but cant seem to get it right. Any hero out there? Link to download the file; Unhide the data sheet...

Hello, Just a quick note to inform the MrExcel Team that the post on Attachements in this section is not up to date. (here : https://www.mrexcel.com/forum/about-board/508133-attachments.html) I tried Excel Jeannie but it bugs. I tried the Forum Addin and it is worst.... So it is a lost of time...

Hello: Im trying to put like a paragraph inside a cell and do not know how to do so: Ex: Section 23.d (page 234) Recording Keeping “You should keep records for ever…” Section 23.f (page 235) Shame on you section How can i put all of these, with the same spaces and alignment inside a...

I have a dashboard that is created in Excel for many different departments, packaged as a PDF using the Ron de Bruin VBA and then emailed to them automatically via Outlook. At the bottom of the dashboard is a section called "Department actions." At present the only way for this to be returned...

I basically get my Data from external dashboard through Copy then paste matching source as Get data from Web function is not possible due to IE limitation. the Data however, when I paste to excel would only be on Column A, that is fine but I need to process it just like in my Example Column B...

A monthly workbook contains a worksheet for each day with a section that contains a differing number of rows each day. I have an array formula which finds the first blank row in a range:- {=MIN(IF(R7:R50="",ROW(R7:R50)))} and wish to include it as part of several other formulas on same sheet...

Hello all, I have a set of values which depict the length of steel rods. But manufacturer has default values of 40feet, 50feet and 60feet. I need to find how many 40', 50', 60' units shall come. The wastage should be minimum. I have done it manually, but have lot of data. wastage is about 6.9...

I am creating a report that has several "ID's" that have various information for each one. Is there a way that I can group together these ID's so when I print it out it will have the following format? ID 1 other info and columns 1 other info and columns 1 other info and columns 1...

I have a list that are all formatted the same: 12345 City, ST (status) I want to pull out the City,ST from the list I can do a find to find the start position and end position. =find(" ",A1,1) to find start position (i need to use formula here b/c the # length is variable) =find(" (",A1,1) to...