section

Hi Need a help. In column A of sheet 1, I have links of certain section of company websites. I need to copy all the content from that section to sheet 2 of excel once all content got copied from first link move to 2nd link and copy all content and so on. however i also need an identifier...

Hi, Can you advise the correct way to write this, If .Range("Z14") = FFFF00 and has value Then Red section has me confused

I have "inherited" a workbook from a past worker and there is a formula that doesn't give the information required. The formula posted below works but I needs extra criteria. I want it to match against 3 criteria where the existing formula only matches 2 criteria. Can someone tell me the...

Hello, I have a sheet that I've created a blank row after each change in Column J. I need to have column P in that row to have the formula, but dynamic values for the column O should be dynamic : =ROUND(COUNTIF($O$2:$O$1007,"Late")/COUNTA($O$2:$O$1007)*100,2) at each blank line. I've got the...

I have a form with a header section (containing controls) and the detail section which returns the result of a Search - determined by what is input in the control(s). If I have the vertical scroll bar showing, it extends into both the header and the detail part of the form. Since the...

Hi all, Sheet1 has product Bill of Materials: Sheet2 is for user to input Product & Tonnes in the INPUT section: I'm looking for VBA to calculate & return Ingredients & total Tonnes under the RESULT section. Thanks for any help in advance. Mark

Greetings, I can probably do this for something similar but I just cannot piece together my needs for this specific task. I did not write the code but know if I click the button "Run All" it will go through all the processes contained below. My goal is to run this section on a schedule where...

Hello - any help much apprciated. I have managed to sort a large (varying) data set as below but need a formuale to sum up the values returned, however the number of returned vlaues will not always be the same. For example below i have 4 areas to sum with 3,3,1,1 variables however next time i...

Hi, I do hope somebody can help me. I have 2 sheets... First Sheet Section 1 Fred Bloggs 1001 1003 1005 1007 1009 Section 2 Amy Trams 1000 1002 1004 1006 1008 Second Sheet 1002 9.2 0.00% 1 <section name="" here="">1005 9.7 80.00% 2...

Hi, I cannot think how to do a horizontal search to find a Section Number (Cabin 15001) and hope you are able to help me? The stats screenshot, I would like to be able to add the Section number for 15001, but cannot for the life of me work out how to do it for all cabins for each section...

Hi, Appologies if this is long winded but it seemed the easiest way to explain myself. I need to create a solution to break the following table up into multiple, 2 part sections A&B. The total quanity of each section must be divisable by 15. Neither section can exceed 45,270 and the sum of...

Hi, I am trying to apply custom data labels to my chart from a series. This is the relevant section of my code. ActiveChart.FullSeriesCollection(2).Select ActiveChart.SetElement (msoElementDataLabelCallout) ActiveChart.FullSeriesCollection(2).DataLabels.Select...

Hi I am working on a file that is filled from an Access database. The excel file has multiple tabs with a simple format with a "header", "data" and a "total" line. When the files are updated the formatting tends to get messed up. The data section changes based on the number of cases pulled in...

I have had these lines of code in a program for two years. Sheets("ShiftReport").Select Range("B2").Select ActiveCell.FormulaR1C1 = CDate(frmShiftOnDuty.dtpShiftDate.value) It has worked without any issues, in fact this very section of the code ran yesterday. No code changes...

Hi, I'm having difficulty getting a numbering scheme working correctly. I have a list of descriptions that I want to assign a number. If a certain description is used one time the number that gets assigned needs to be the same number that is used if that description shows up again later down the...

I created a Split form. Used the wizard. It put my fields in the detail section - which I can see all of them and edit them when in Design view. But when I go to Form view there I don't see my fields. I see them in the datasheet section on the bottom and I see the buttons I put in the form...

Hi there, A question about optimizing sheets from colleagues and exterior firms. I've read a bit on best practices and rules of good tables to increase user-friendliness and reduce the reader's cognitive load. As a practice, I'd like to improve and automate the following example. The following...

I have a large amount of data on an Excel worksheet, 4000 rows. The data is split into sections, each section with a title in column D. I am trying, without success to compile an interactive index on a separate worksheet. The Index will comprise only a list of the section titles and I want to...

Hello, I have a table which has two columns, column A & B - Column A have "section" and B consists of User Name. In column B user column the entries will be repeating. I need a formula which will give me the count of unique value base on the section (ref. Table 2) eg. for Section A = no. of...

I am attempting to hyperlink multiple words in a comment section on Excel 2016. When right clicking on a work in the comment, the hyperlink is grayed out and dos not allow for a hyperlink. The only option is to hyperlink the entire cell. Is there a setting that needs to be changed in order to...