section

I have a section of code below from a much larger piece. The section of code worked when using an input box to acquire a userinput. However, I'd like to have userform replace the inputbox. I've tried just using a userform and inserting the line (as seen below) but that didn't work. I need the...

I am wanting to sum two totals if possible. I have a used sale section and a new sale section. These are both separate for other reasons and reports. However i am trying to now create a new section that will combine both the new sales and used sales totals together. I have a list of all...

Hey Team, I have a worksheet with data in columns A thu E that is broken into sections separated by blank rows and a unique "Title" in column A starting each section. I need to select the col A range of a section so that I can format each column differently. CurrentRegion doesn't do it because I...

<tbody> Section 1 Item No. Description Budget Total Invoice Current Invoice 1 AAAA 10 10 0 2 BBBB 10 5 2 3 CCCC 10 0 0 4 DDDD 10 3 3 Subtotal 40 18 5 Section 2 Item No. Description Budget Total Invoice Current Invoice 5 E 10 10 0 6 F 10 5 2 7 G 10 0 0...

I have a spreadsheet that has a tab with sections and within each section there will be tasks added – each task item requires a unique number and must increment to the next available number within a specified number range based on a Work type. The first 2 parts of the number are based on two...

hello, i have just changed my licensing for 365, and reinstalled all office 365 business apps. i have just opened a excel sheet i had and tried to edit the comments. the problem is that there is now no "comments" section showing under the "review" tab, and no comment option appearing when i...

I have multiple workbooks for each month (Named January, February, March, etc) with sheets within the workbooks for each day (010119 for January 1st 2019, 010219 for January 2nd 2019 for example). In each sheet is a list of people who have registered and paid for a sport (see below). Some...

I have a named range (rYvalues) which is a singe column. It can be of variable length (7 to 365). If I want to take an average of a continuous section of that 1-dimensional named range, say average positions 50 to 99, how might I be able to do that? I've been all the web on this one and...

im getting #Value ! when doing a countifs. anything i am missing. i am basically wanting it to count the totals for jan when Q5-Q29991 = "yes", sales AC = a value in a cell, sales R5 = "new" and the sale date (AB) is in january. i have this formula in another section for the sales execs and it...

Thinking how to accomplish filtering on field that is not displayed and ran into a few roadblocks. E.G. - 1. If I put the desired field in the "FILTERS" section, I can't filter on value (i.e. - want to keep all observations greater than 1,000,000 2. The desired field to filter on is not in...

Good day, I'm looking for some advice on how to do the following: I have a range variable named rYvalues to which I assign a range which can be of varying length (7 rows to 365 rows). I would like to do the following: step 1 - divide the range up into sections, the number of which is taken...

how to find the sheet name (section name ) when you type employee no. in a cell? A workbook has 15 sheets named as per sections of the department.In each section has 100 employees in range A2:A101with unique employee no. I have a list of 50 employee nos in different sections. In a new work sheet...

I am trying to create a conversion tool for data I get in a PDF. I have a rows worth of data that all shows up in the same cell when pasted into Excel. I am trying to use formulas to separate the data to make the process repeatable in an easy fashion. (Paste into sheet 1, auto converted copy...

Hi everyone, I got a problem that I cannot solve by myself. I'll try to explain it the best I can. I have two word docs, said A and B: the A is created by an application and comes with 4 sections, the B is created by me without any section. Here's what I have to do: - delete all the text...

I am using vba to interact with SAP and get data out, etc... Generally it all works fine. In this particular section, when I run the whole program it always errors out - it seems to not be allowing the Excel Sheet to actually open before moving on. I have tried adding DoEvents and a wait as you...

Hi guys ! Who can help? I need to visualize data in several coordinate systems - cylindrical and spherical. This is necessary for more accurate results. Is there a tool that will allow you to do this ? Please move the topic in the right section if I'm wrong.

Help, I have many, many cells that have a date and time in them like this 02.08.2018 - 10am I want to remove the - 10am section How do I do this please?

Hi all! I'm working with some data that is pasted in to Cell A1 of Excel. The volume of data occupies Column A and B but can extend thousands of rows down, separated by single empty rows. The data is generally in the following format, where VARIABLE A is in Column A and VARIABLE B is in Column...

All - Hi! I know how to add a hyperlink to send the cursor to a particular cell. However I need to position that cell in a certain location on the screen. The spreadsheet is really wide - and incorporates a Freeze Panes to ease horizontal scrolling. When I hyperlink to the first cell in the...

Hi guys, Bugger if I can make this work with the correct syntax. So I want a formula that returns TRUE if the 1st section is met AND either of the 2nd sections. Does this make sense? 1st section IF(AND($D2>2.29,$D2<7.51,$AP2<"",$A2<=TODAY())) Then 2nd section IF(AND($AR2="afl"...